Apr 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home

SQL SERVER – Discussion – Effect of Missing Identity on System – Real World Scenario

Pinal Dave
SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks
Database, DBA, SQL Constraint and Keys, SQL Index
About a week ago, SQL Server Expert, Imran Mohammed, provided a script, which will list all the missing identity values of a table in a database. In this post, I asked my readers if any could write a similar or better script. The results were interesting. While no one provided…
Read More

SQL SERVER – 2008 – Copy Database With Data – Generate T-SQL For Inserting Data From One Table to Another Table

Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Best Practices, Database, DBA, SQL Scripts, SQL Utility
Just about a year ago, I had written on the subject of how to insert data from one table to another table without generating any script or using wizard in my article SQL SERVER – Insert Data From One Table to Another Table – INSERT INTO SELECT – SELECT INTO…
Read More

SQLAuthority News – Download – SQL Server 2008 Developer Training Kit

Pinal Dave
SQLAuthority News
Database, DBA, SQL Download, SQL Server, SQL Training, SQL Utility

Note : Download SQL Server 2008 Developer Training Kit by Microsoft

SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2005. The SQL Server 2008 Developer Training Kit will help you understand how to build web applications which deeply exploit the rich data types, programming models and new development paradigms in SQL Server 2008. The training kit is brought to you by Microsoft Developer and Platform Evangelism.

Read More