Viewing 15 posts - 7,966 through 7,980 (of 22,214 total)
Both the server-side trace and extended events can be set up to run from a SQL Agent job so that they start at a particular time. Both can also be...
June 14, 2014 at 4:10 am
ramana3327 (6/13/2014)
I am running in dev box only. So stats were not very up to date. Usually to test the changes do we need to run the stats before...
June 14, 2014 at 4:08 am
I'd ask for a demonstration of a point in time restore. If it can restore to 3:57PM yesterday, accurately, without a corrupt database, go with it. I've seen SAN snapshot...
June 14, 2014 at 4:05 am
I agree with Howard. I have seen some interesting improvements in performance because of the new cardinality estimation across quite a few queries, including some I wouldn't have expected to...
June 14, 2014 at 4:01 am
Did you read the post I linked to? You need to have log backups enabled.
June 14, 2014 at 3:57 am
wolfkillj (6/13/2014)
SQLRNNR (6/13/2014)
Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
June 13, 2014 at 11:36 am
Jeff Moden (6/13/2014)
Grant Fritchey (6/13/2014)
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
June 13, 2014 at 11:32 am
Without the execution plan, I couldn't tell you why the other method ran slowly. It could be that the foreign key constraint isn't trusted. This would be because the WITH...
June 13, 2014 at 11:30 am
Sean Lange (6/13/2014)
Grant Fritchey (6/13/2014)
June 13, 2014 at 10:48 am
NOt a great game, but not a bad one so far. First one I've had on so far this World Cup. I missed last night's game with Brazil. Heard it...
June 13, 2014 at 10:41 am
I'm very busy working right now. Didn't just see that corner kick by Cameroon. Nope. Working on an article for Red Gate. That's what I'm doing.
June 13, 2014 at 10:26 am
Yeah. Those cost estimates can be quite high for fairly simple queries that won't benefit from parallelism. Bumping up the default value is one of the first things I do.
Well,...
June 13, 2014 at 10:19 am
Anyone else getting real weird formatting in the text box when replying to posts? It's all squished over to the left side of the screen.
June 13, 2014 at 6:52 am
I've done all the looping outside the procedure.
June 13, 2014 at 5:52 am
Adding to Kevin's list, what's the compatibility level of the database? Have you generated an execution plan on the 2008 box and the 2012 box to figure out what's different?
There...
June 13, 2014 at 4:17 am
Viewing 15 posts - 7,966 through 7,980 (of 22,214 total)