SQL BlogsMay 25, 2011by Rudy1 min1,091

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 great, so you know exactly what type of havoc you were throwing at SQL Server. But, if you’re too descriptive, … Continue reading Long TRANSACTION Identifier is Long

SQL BlogsMarch 24, 2011by Rudy2 min1,433

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. Continue reading Rudy: An MCITP Today. Rudy: An MCM Tomorrow?

SQL BlogsMarch 24, 2011by Rudy1 min1,404

Reset an Identity Column in SQL Server

Reset and verify IDENTITY values in SQL Server using DBCC. Continue reading Reset an Identity Column in SQL Server

SQL BlogsJuly 22, 2011by Rudy2 min1,139

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 exponentially, you’re going to run into issues down the road. One quick way to check things out is to look at your table sizes. I looked all over the web and found Mitch Sellers’ blog with several great SQL Table Size scripts. Here are 2 of the good ones from the comments: EXEC sp_MSforeachtable @command1=”EXEC sp_spaceused ‘?'” This method is quick, but not very clean. You’ll get a separate result for each table, so you really cannot sort. Plus, I … Continue reading Determine Tables Sizes in SQL Server

SQL BlogsDecember 2, 2010by Rudy1 min1,250

Use SQL Server DMVs to find a table’s IDENTITY Column

Use SQL Server DMVs to find a table’s IDENTITY Column. The SQL Server DMVs sys.objects and sys.columns contain valuable information that can identify IDENTITY Columns. Continue reading Use SQL Server DMVs to find a table’s IDENTITY Column