Reset an Identity Column in SQL Server
Reset and verify IDENTITY values in SQL Server using DBCC.
SQL Blogs
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
SQL Blogs
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.