2006-11-02
1,095 reads
2006-11-02
1,095 reads
2006-10-31
1,118 reads
2006-10-30
1,104 reads
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,704 reads
2006-10-27
1,551 reads
2006-10-26
1,177 reads
2006-10-25
1,094 reads
2006-10-18
1,206 reads
There are so many new features in SQL Server 2005 that there's one that can make a significant impact in solving many different types of problems. Andy Warren takes a look at one of the features that has been enhanced and is extremely useful, albeit quirky: TOP.
2006-10-05
19,150 reads
2006-09-26
1,022 reads
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers