Viewing 15 posts - 10,576 through 10,590 (of 22,213 total)
I'm with you. If you can get a quick, full backup (copy only of course), or better still, like Gail says, a snapshot, then that's the way to go. Absolutely,...
August 13, 2012 at 4:27 am
I'm maxed out for the rest of the year. I'll be in Oklahoma City in a couple of weeks and Rhode Island in September, but after that, it's all SQL...
August 4, 2012 at 6:19 am
WayneS (8/2/2012)
August 3, 2012 at 5:06 am
GSquared (8/1/2012)
Ooohhh! I bet that made you popular!Not that the consultant did anything wrong, but I bet a few people took his comment as a kick to the ego-groin.
I...
August 2, 2012 at 5:36 am
Kiara (8/1/2012)
Does this look like a giant advertisement to anyone else?http://www.sqlservercentral.com/Forums/Topic1039196-391-1.aspx
Nah, I'm sure 5 different people are going to swoop in and post once time on the same forum just...
August 1, 2012 at 7:38 am
SQLRNNR (7/31/2012)
Grant Fritchey (7/31/2012)
August 1, 2012 at 7:36 am
Looks ok. No, it doesn't ignore procedures. Procedures show up in both query stats and proc stats. You can just use proc stats to narrow down what you're querying against...
August 1, 2012 at 7:35 am
To get fine control over that type of maintenance, I'd suggest getting a copy of Michelle Ufford's scripts or Ola Hollengren's scripts. They'll do a much better job than Maintenance...
August 1, 2012 at 7:33 am
GilaMonster (7/31/2012)
Creating a good, solid, scalable design is not premature optimisation. It's doing a good #@$@# job.
+Infinity
Especially for the curse words.
August 1, 2012 at 7:16 am
SQLSACT (7/31/2012)
Grant Fritchey (7/31/2012)
July 31, 2012 at 11:25 am
SQLSACT (7/31/2012)
Grant Fritchey (7/31/2012)
July 31, 2012 at 11:21 am
You should test both approaches.
But, in general, I would expect you'd get better performance by putting all the data into a single table. That assumes that the index on Account#...
July 31, 2012 at 10:33 am
The DMV stores data for queries that are currently in cache. As soon as a plan ages out of cache all the information in that DMV is lost. So it...
July 31, 2012 at 9:06 am
iashurova (7/31/2012)
July 31, 2012 at 9:03 am
SQLKnowItAll (7/31/2012)
Grant Fritchey (7/31/2012)
July 31, 2012 at 8:42 am
Viewing 15 posts - 10,576 through 10,590 (of 22,213 total)