Retrieving Identities on set-based inserts
Learn a foolproof way to get identity values for multi-row inserts with the OUTPUT clause in SQL Server 2005 without using a cursor.
2010-01-20
4,150 reads
Steve McRoberts
Using XML to pass and return values to procs
Tips on parsing and sculpting XML from within a SQL 2005 stored procedure
2009-10-19
10,244 reads
2009-10-05 (first published: 2009-09-21)
1,884 reads
Blogs
Improving TweetDeck with Better TweetDeck
By John
If you are at involved with the #sqlfamily, you are bound to hear about...
Interview with Bob Ward
By damianwidera
This is the eight interview we have done. This time our guest is the...
SQL in the City Comes Back to Seattle
By Steve Jones
This year at the PASS Summit, Redgate is holding our SQL in the City...
Forums
Help to optimize select query
Need help to rewrite the query for faster result. use ABC_DB; SELECT c.otherID, a.shortname,...
Help to optimize select query
Need help to rewrite the query for faster performance. use ABC_DB; SELECT c.otherID, a.shortname,...
OLDEST_PAGE log reuse wait
In SQL Server 2016 SP2, we had a transaction log that had a truncation...
Ask SSC