Viewing 15 posts - 7,246 through 7,260 (of 8,415 total)
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
GSquared (8/24/2009)
Lynn Pettis (8/24/2009)
Looks like he's been on. Changed his name to Express12. Like that will keep him off peoples radar! 😉
I don't think anyone yet has accused...
August 25, 2009 at 5:50 am
Viewing 15 posts - 7,246 through 7,260 (of 8,415 total)