Viewing 15 posts - 11,806 through 11,820 (of 22,214 total)
The traditional mechanism is to move only the data you need to move, when you need to move it.
I would not go for the "move everything, we might need it"...
September 26, 2011 at 8:41 am
The difference is how they're called. If you called a procedure through an execute SQL statement in your code, it'll come in as a TSQL batch. If you explicitly call...
September 26, 2011 at 8:37 am
The two indexes that both start with FiscalYear are questionable. Is that the most selective of the two columns in each index? Meaning, does it have the most unique values...
September 26, 2011 at 5:00 am
Not during a restore operation. You'll have to restore the database first, then drop the number of files.
By the way, I'd suggest leaving a few file groups, even if...
September 26, 2011 at 4:57 am
It sounds like something is pegging the resources. Do you have scheduled events in SQL Server? How about in the OS? Do you have any form of monitoring in place...
September 25, 2011 at 5:55 am
Yeah, it would have to be. That's my understanding of how it works.
Heaps are generally weak tables. They have a place in design, but their use should be relatively exceptional....
September 25, 2011 at 5:53 am
a) It depends. Over the last few years I was, in a very lazy fashion, looking for work. I did some interviews, but I wasn't really serious about it. But...
September 25, 2011 at 5:50 am
Just a question, is SQL SErver the only service running on this machine? If so, give it all the memory it can take (leaving a couple of gb for the...
September 25, 2011 at 5:40 am
For remote queries, to see what they are doing, you must look at those queries on the remote server as well as locally.
September 25, 2011 at 5:34 am
I went back and read the article again because it just doesn't feel right to me somehow and then I saw this:
The more I travel, the more I observe that...
September 23, 2011 at 11:19 am
GSquared (9/23/2011)
Grant Fritchey (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading...
September 23, 2011 at 11:06 am
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Based on a long history of reading about muck-raking journalism...
September 23, 2011 at 11:00 am
GilaMonster (9/22/2011)
SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/
Chapter 8: "The how and why of Page Restores", Grant...
September 22, 2011 at 3:10 pm
jcrawf02 (9/22/2011)
September 22, 2011 at 10:44 am
Ninja's_RGR'us (9/22/2011)
Kiara (9/22/2011)
GilaMonster (9/22/2011)
Jim Murphy (9/21/2011)
And where's Gail? Is she not keeping you guys in line?
Doing the final checks and tweaks on Jonathan's book.
Keep this lot in line? How...
September 22, 2011 at 6:24 am
Viewing 15 posts - 11,806 through 11,820 (of 22,214 total)