Viewing 15 posts - 7,246 through 7,260 (of 8,416 total)
GilaMonster (8/29/2009)
It's just that within unique indexes is the only place where nulls are considered the same.
NULLs are also considered 'the same' by GROUP BY, DISTINCT, UNION, EXCEPT, INTERSECT...and probably...
August 30, 2009 at 8:58 pm
Ignas Chilewa (8/27/2009)
I was wondering what is the best way of adding a new non nullable column(s) to a wide and large table(taking of like 90M records and more...
August 30, 2009 at 8:47 pm
Yes, because in the mode selected SQL Server has to examine every page.
See http://msdn.microsoft.com/en-us/library/ms188917.aspx for details of the mode parameter (the Remarks section in particular).
The same page is available in...
August 30, 2009 at 4:14 pm
To pre-empt the question: bear in mind that the current versions of SQL Server make it almost impossible to fully defragment indexes which use less than 25 pages at a...
August 30, 2009 at 3:31 pm
The following articles may be of interest to you:
http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/21/tempdb-basics.aspx
http://blogs.msdn.com/sqlserverstorageengine/archive/2008/12/22/tempdb-basics-cont.aspx
Paul
August 30, 2009 at 3:24 pm
The demo script I promised is attached to this post.
Paul
August 30, 2009 at 3:15 am
thomas.garay (8/27/2009)
HiIt must be able to be done some how...
I can't believe that no one ever thought of doing this?
While it is true that it is not quite possible...
August 28, 2009 at 5:38 am
As far as the current topic is concerned:
The only thing I won't tolerate is gross rudeness. Anything else is fine. If someone wants to post 1,000 no-effort questions...
August 28, 2009 at 5:11 am
GilaMonster (8/27/2009)
Lynn Pettis (8/27/2009)
This time an OP took exception to Gail's answer.I wonder how long he's going to protest.
A while longer, I hope.
His request is actually a very interesting one...
August 28, 2009 at 4:55 am
Steve Jones - Editor (8/25/2009)
Nice to see an apology though.
Sure is. Maybe I will invest in some heavy-duty ink remover if the change of heart proves to be genuine...
August 25, 2009 at 7:48 am
ta.bu.shi.da.yu (8/24/2009)
e.g.
SELECT A.colA, B.colB
FROM PrimaryTable A where A.colValue in (select B.colValue from OuterRefTable...
August 25, 2009 at 6:43 am
Mark Johns (8/25/2009)
I am looking for the definition of a session and connections in SQL 2005? I have looked in the SQL 2005 BOL.Can anybody help?
A connection represents the external...
August 25, 2009 at 6:34 am
Jeff Moden (8/23/2009)
Lynn Pettis (8/21/2009)
August 25, 2009 at 6:10 am
Dave Ballantyne (8/25/2009)
Looking forward to this explanation!
One for the 'unique designs' pile. Very amusing. Thanks for the link.
August 25, 2009 at 6:06 am
ali.m.habib (8/25/2009)
Dave Ballantyne (8/25/2009)
Create a unique index on the column , and stop the issue happening in the first place
how to update the old data such that no repeated time...
August 25, 2009 at 6:05 am
Viewing 15 posts - 7,246 through 7,260 (of 8,416 total)