-
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, you’ll get the following error: Msg 103, Level 15, State 2, Line 1 The identifier…
-
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.
-
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…
-
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.
-
Incorrect syntax near ‘GO’ when creating Dynamic SQL
Learn about line breaks when creating dynamic SQL.
-
Remote Desktop won’t go back to Full Screen after Minimization in Windows 7
Learn how to get your remote desktop back to full screen after Minimization
