Resources
Posts Tagged "SQL"
Check out all of the posts tagged with "SQL".
Using datediff to display results as HH:MM:SS
DateDiff is a great tool in SQL Server. But you have to extend DateDiff a bit to get things in a nicer format, such as HH:MM:SS. See what Rudy found on SQLServerCentral.com which saved the afternoon!
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. ...
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.
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 ...
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.