Viewing 15 posts - 12,826 through 12,840 (of 22,214 total)
SQLHeap (4/4/2011)
If I were to restore a DB from production to any other server, would the execution plans and statistics come with the prod backup?
Yes, on the statistics, no, on...
April 5, 2011 at 5:25 am
Can you try using restricted user instead of single user? I've seen applications that constantly refresh their connection so they can squeek in before you start the restore.
April 5, 2011 at 5:17 am
forsqlserver (4/5/2011)
Is there any free tool but good also?:hehe:
Yes.
Performance Monitor comes free with every instance of windows. You can combine that with the Dynamic Management Objects within SQL Server and...
April 5, 2011 at 5:15 am
Gianluca Sartori (4/5/2011)
kstjacques (4/4/2011)
April 5, 2011 at 5:13 am
Grubb (4/4/2011)
Craig Farrell (4/4/2011) SELECT * FROM master..sysprocesses.
Thanks, Craig. The problem with that is that the query only runs ~400 ms. Do you know of a...
April 4, 2011 at 6:55 pm
Grubb (4/4/2011)
Grant Fritchey (4/4/2011) since "slow" in this case is 300ms
Tell me about it. Not a good one to really cut my teeth on.
The Tuning Advisor recommended my covered...
April 4, 2011 at 11:20 am
It absolutely could be parameter sniffing, yes, but it also could be contention on resources. Does the table have inserts, updates or deletes that occur? If so, you might be...
April 4, 2011 at 10:16 am
Reinforcing what Gianluca said, Red Gate's SQL Monitor really is an excellent choice for monitoring servers and the price is very reasonable. If you want to, you can actually play...
April 4, 2011 at 10:11 am
Even if you place it in single user mode, if you're connected to that database or another connection is there, it might still be active when you try to run...
April 4, 2011 at 6:33 am
Abrar Ahmad_ (4/4/2011)
Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated...
April 4, 2011 at 6:09 am
SQLkiwi (4/4/2011)
April 4, 2011 at 6:06 am
WayneS (4/3/2011)
Grant Fritchey (4/3/2011)
I'm just glad it's over. All that crap is out of my basement. Yay!So, whose more glad about that... you or your family?
Oh, the wife is pretty...
April 4, 2011 at 6:04 am
WayneS (4/1/2011)
I'm specifically interested in the use of stored procedures.
1. Should ORM tools...
April 4, 2011 at 4:57 am
Jeff Moden (4/3/2011)
April 4, 2011 at 4:54 am
SQLkiwi (4/2/2011)
Got to meet heaps of great people including Grant and Stefan K!
If anyone would like to see the slides...
April 3, 2011 at 5:04 am
Viewing 15 posts - 12,826 through 12,840 (of 22,214 total)