SQL Tips and Tricks Archives - Page 404 of 536 - SQL Authority with Pinal Dave

SQL SERVER – List All Missing Identity Values of Table in Database

July 27, 2009

SQL Function, SQL Identity, SQL Scripts, SQL Stored Procedure

The best part of any blog is when readers ask each other questions. Better still, is when a reader takes the time to provide a detailed response. A few days ago, one of my readers, Yasmin, asked a very interesting question: How we can find the list of tables whose…

SQLAuthority News – Search SQL Server Solutions

July 26, 2009

Pinal Dave

Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

So far, I have written over 1030 articles on my blog, and I have received an astounding 12,000+ comments. Undoubtedly, it has acquired the status of a huge database now! I nearly receive 200+ emails and lots of comments on this blog every day. I do maintain a log of…

SQLAuthority News – Download – Cumulative Update Package for SQL Server 2008

July 25, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Download, SQL Service Pack

SQL Server 2008 has been out for over two years and now a very significant Cumulative Update has been released. If you are using SQL Server 2008 then you must certainly install it to fix the various bugs. Cumulative Update 3 for SP1: http://support.microsoft.com/kb/971491 Cumulative Update 6 for RTM: I…

SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen

July 24, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

I had a great, unforgettable time at Teched India 2009 in Hyderabad. I had delivered a successful session on SQL Server Management Studio Best Practices, which created a lot of interest in community. I was truly amazed at the tremendous response I got. I received countless different questions on this…

SQL SERVER – Puzzle – Write Script to Generate Primary Key and Foreign Key

July 23, 2009

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts

In one of my recent projects, a large database migration project, I confronted a peculiar situation. SQL Server tables were already moved from Database_Old to Database_New. However, all the Primary Key and Foreign Keys were yet to be moved from the old server to the new server. Please note that…

SQLAuthority News – SQL Server Value Calculator

July 22, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL Documentation, SQL Utility

I have been using twitter for quite some time now (follow me at @pinaldave). In twitter world very often I find something interesting shared by my friends there. SQL Server Expert and Microsoft Evanglist Vinod Kumar has twitted very interesting detail linking to SQL Server Value Calculator. The web version…

SQLAuthority News – SQL Azure – Microsoft SQL Data Services – Introduction and Pricing

July 21, 2009

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Cloud Computing, SQL Azure

Microsoft has updated the branding for SQL Services and SQL Data Services. SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database. Changing the name does not change product but it demonstrates tight integration between the components of the service platforms. As…