Retrieving the identity value from an inserted row should be a very simple task. But based on his survey at TechEd 2005 as well as some recent interviews, Andy Warren points out some of the wrong answers and turmoils he has faced in getting this question answered.
2006-10-27 (first published: 2005-08-01)
32,659 reads
Damon Armstrong learned the hard way about the consequences of not having a clearly defined project scope or work contract
2006-10-27
3,089 reads
The SQL Server memory manager is one of the more complicated parts of SQL Server and we had the chance recently to talk to the person that ensures it runs as smoothly as possible. Get to know the man behind the SQLOS.
2006-10-26
2,826 reads
SQL Server 2000 and 2005 do not include much in the way of financial functions, but there are many sources for the formulas for financial calculations. In this tip, I present the present value (PV) and future value (FV) functions, both of which are scalar UDFs.
2006-10-26
2,458 reads
In this video, Kathi continues her T-SQL series and exands how to use the WHERE clause.
2006-10-26
3,469 reads
We've moved the subscriptions for the SQL Server Standard to it's own site and just completed the November issue. Read on for how to access your subscriptions or subscribe today.
2006-10-25
2,099 reads
This is the last week to register for the PASS 2006 Summmit in Seattle and save $300. Read on about what you'll be missing if you don't get up there.
2006-10-25
1,370 reads
The definitively "hands-on" guide to handling dates and times in SQL Server
2006-10-25
2,883 reads
Data warehousing is becoming more and more popular, especially as companies seek to leverage the information stored in various systems to improve their business processes. Warehousing expert Vincent Rainardi brings us the next installment of his series on data warehousing, examining the issues of loading data.
2006-10-24
15,094 reads
In this and the related articles, we will overview Actions in Analysis Services 2005. Much as they did in the previous version of Analysis Services, Actions allow information consumers to go beyond the robust OLAP perspective offered by Analysis Services, and to "step outside" for related information, or to generate commands or initialize programs, without leaving their current analysis focus.
2006-10-24
2,654 reads
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers