Viewing 15 posts - 45,151 through 45,165 (of 49,571 total)
kiranbgiet (8/11/2008)
temporary tables are least in use as they consume the memory resource
Instead of temporary tables you can use the table variable as the table variable is just...
August 12, 2008 at 12:39 am
andrew gothard (8/11/2008)
Do you think of any new features which would be helpful
Personally - since 6.5, I've been waiting for the ability to write a view, and then, when I...
August 12, 2008 at 12:35 am
Getting back to the original question, fascinating as the discussion is...
purplebirky (8/11/2008)
August 11, 2008 at 3:37 pm
andrew gothard (8/11/2008)
Um - you Gail. Hope the suggestion's taken in the way it was meant ...... just thought it was nice and to the point
Wanted to be sure...
August 11, 2008 at 2:54 pm
andrew gothard (8/11/2008)
August 11, 2008 at 2:42 pm
I don't, but if you google you should be able to find some blog posts about it.
August 11, 2008 at 2:01 pm
Arun (8/11/2008)
Wouldnt it be nice if we have a debugger in Management Studio to debug SQL Commands Just like we debug .NET Programs.
Your wish has already been answered. There's a...
August 11, 2008 at 1:45 pm
If TempDB is full, then there isn't going to be any free space for shrink to release to the OS. You need to find out what's using the tempDB space...
August 11, 2008 at 1:04 pm
Can you post the table and index definitions for the tables involved in the query please?
August 11, 2008 at 12:59 pm
However, I have noticed that some of the indexes that showed as having fragmentation are not always "defragged" after reorganizing the index. The vendor DBA told me this is because...
August 11, 2008 at 12:59 pm
Wesley Brown (8/11/2008)
Gail,You made the statement as if it couldn't be done, and that isn't true.
I never said it could not be done. I said you're asking for an unresponsive...
August 11, 2008 at 12:45 pm
andrew gothard (8/11/2008)
Ever thought of expanding that slightly and submitting as an article on here?
Who's that aimed at?
August 11, 2008 at 12:12 pm
Wesley Brown (8/11/2008)
You can run /3GB if you have less than 16GB of ram installed on the server.
Sure you can. Doesn't make it a recommended good practice.
If you...
August 11, 2008 at 12:12 pm
I did a nice long calculation after someone asked me a very similar question in my TechEd session. Turned out, with a 100000 rows table, changing a nonclustered index key...
August 11, 2008 at 10:22 am
Viewing 15 posts - 45,151 through 45,165 (of 49,571 total)