Daily Archives: June 8, 2011

---

Stuff I learned today – Table Types

This entry was posted in Features T-SQL and tagged SQL 2008 Table types on June 8, 2011 by Colleen M. Morrow

Since SQL Server 2000, you’ve been able to create variables of type TABLE, but you needed to define that table structure when (and each time) you declared the variable. You also couldn’t pass these table variables into a stored procedure. SQL Server 2008 introduced the user-defined TABLE datatype. Now you can create and store custom-made […]

---

Stuff I learned … yesterday – statistics

This entry was posted in Features SQL Tuning and tagged SQL tuning statistics on June 8, 2011 by Colleen M. Morrow

Yesterday was a pretty full day between training and the ONSSUG June meeting immediately afterwards, so I didn’t get a chance to blog.  Anyway, I did learn something yesterday, but it didn’t come from the class I’m taking.  Erin Stellato (blog | twitter) gave a great presentation at ONSSUG about statistics.  I really wish she’d had more […]

---