Viewing 12 posts - 1 through 12 (of 12 total)
I, too, chose the last answer, not because I thought it would actually fail, but because none of the other three answers contained the correct date.
That's the reason I...
September 27, 2019 at 3:12 pm
Wouldn't 633 HRs move him from rank 7 to rank 6? So is there a part 2 to this question to update the rank?
Good question! But like most...
March 4, 2019 at 9:21 pm
Jeff Moden (8/10/2011)
Paul Herbert (8/10/2011)
A minor correction if you don't mind. If you are going to quote my 'Really?!", I think it...
August 11, 2011 at 10:37 pm
Excellent article, as always, Jeff! And as all of your articles that I mange to see and read, this one has been added to my briefcase. I only...
August 10, 2011 at 12:22 am
50 and 16 are correct, as is very clearly stated on this link http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx . The 50/50 referenced in the MSDN link is for the maximums for SQL Server...
May 28, 2009 at 11:54 pm
Thank you Jeff.
And thanks for pointing out the RBAR aspect of recursive queries. I'm still not very good at spotting hidden RBAR, and you are the master of that...
October 11, 2008 at 10:59 pm
Cade.Bu (10/10/2008)
But I still cannot understand why deleting items from the cteDV will delete items from the base temporary table, or is this something specific to the CTE statement.
So...
October 10, 2008 at 11:57 pm
I agree that you need to write something to go with your script.
And I believe that your script is slightly flawed, it looks like it will only delete the first...
October 9, 2008 at 11:03 pm
It was SQL 2000 in a power controlled data center. The raid card had a battery for the cache but, if I recall, it might have been suspected has being...
August 26, 2007 at 5:36 pm
I don't know if this could be it or not, but have you checked for corruption of the database? There are a couple of checks you can run with DBCC. ...
August 24, 2007 at 10:16 pm
I am working on implementing a modified version of this audit solution and while testing Jeff's function (fnColumnsUpdated) I discovered a bug when @BinaryColNums = 0x20 or any case where 20 is the...
August 14, 2007 at 4:02 pm
Viewing 12 posts - 1 through 12 (of 12 total)