Long TRANSACTION Identifier is Long
If you’re like me, you like using descriptive variable, procedure and function names. Along with those, descriptive transaction names are […]
SQL Blogs
SQL and SQL Server database topics. Includes design, issue resolution and tips.
Rudy: An MCITP Today. Rudy: An MCM Tomorrow?
Rudy Rodarte is thinking about taking an MCM immersion class given by the good folks over at http://www.sqlskills.com.
Reset an Identity Column in SQL Server
Reset and verify IDENTITY values in SQL Server using DBCC.
SQL Blogs
Determine Tables Sizes in SQL Server
Everyone is worried about their database size. Even though storage is relatively cheap, if your database is growing linearly or