Viewing 15 posts - 9,856 through 9,870 (of 22,213 total)
Evil Kraig F (4/26/2013)
Grant Fritchey (4/26/2013)
TheGreenShepherd (4/26/2013)
April 29, 2013 at 4:07 am
TheGreenShepherd (4/26/2013)
April 26, 2013 at 10:08 am
jasona.work (4/26/2013)
As for smuggling back Canucks, do we want the hockey players (in which...
April 26, 2013 at 8:10 am
zi (4/26/2013)
(you may have to run a checkpoint or two before the log rolls over to the free space to allow shrinking) will work,how to run a checkpoint?
Thanks
It's a...
April 26, 2013 at 8:09 am
zi (4/26/2013)
is it correct to convert the recovery model to simple then shrink the log fileThanks
That question is best answered by the people who use your database. How much data...
April 26, 2013 at 7:32 am
ralbers (4/26/2013)
This article is very helpfull. One question: is it also advisable to use these constraints in sqlserver2005?thanx,
Riet Albers
Yes. Same rules.
April 26, 2013 at 5:23 am
After you either backup your log or switch your database to simple recovery, you can shrink the log file. But you need to do one or the other. I have...
April 26, 2013 at 4:16 am
elfishae15 (4/26/2013)
how to insert sql script in flash which will be displayed on the web?? what it could be??Gejala Kanker[/url], Cara Membuat Kue[/url], Cerita Anak[/url]
To get a good set of...
April 26, 2013 at 3:44 am
neeraj.it (4/25/2013)
April 26, 2013 at 3:36 am
So you're joining one view to another to another to arrive at a final view that contains all the other views nested? That's almost as bad an approach as the...
April 25, 2013 at 11:20 am
As the others have said, it could be anything. They didn't list contention, so I'll toss that out there too.
Posting the query & structure along with an actual execution plan...
April 25, 2013 at 11:17 am
No. CXPacket waits are an indication that you have a parallel process that is waiting. It can be an indication of high CPU use, but it's not the root cause....
April 25, 2013 at 11:12 am
I would just add an ORDER BY clause to that TOP query. You can't guarantee the order of the data without it.
April 25, 2013 at 5:53 am
It's just a number used to perform & report on the math internal to the optimizer. It doesn't mean anything. However, it is represented as if it meant the amount...
April 25, 2013 at 4:50 am
The best approach for tuning a query like this would be to start with the execution plan to understand how the optimizer is resolving it. That can help you apply...
April 25, 2013 at 4:48 am
Viewing 15 posts - 9,856 through 9,870 (of 22,213 total)