Viewing 15 posts - 31 through 45 (of 117 total)
Thanks for that link. 🙂
given a long-running query started by session ID of 42, you can get the handle to the cached execution plan for the query by running:
We reviewed...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
April 2, 2012 at 1:58 pm
Unfortunately, since the the Stored Procedure pegs the CPU at 100% (and this is a Production system), the Execution plan cannot be viewed as it appears to stop running at...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
April 2, 2012 at 6:49 am
Gianluca Sartori (3/14/2012)
Another option is adding temporarily a new data file in the same filegroup in a different...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
March 14, 2012 at 8:09 am
Thanks for the updates/inputs! 🙂
Everything we do (queries) is very "date-centric" so Date is almost always a part of the clustered indexes on our tables, FYI.... date of a...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
April 25, 2011 at 2:12 pm
Thanks Gail!
I should have known that but I guess my mind was not fully in gear today! 😉
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
February 11, 2011 at 11:32 am
That is why I love this site... always other people with different perspectives and different ways to tackle a problem.
Thanks Ken!
Unfortunately, I cannot modify the dbo.PCList table but my...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
January 12, 2011 at 10:35 am
This definitely took long enough to figure out. Apparently, the cliconfg settings for a Windows 7 64-bit or Windows 2008 64-bit system is located in two places:
C:\Windows\System32\ ---- 32-bit...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
December 23, 2010 at 5:33 am
I read a number of the posts, and I guess I would approach the use of SQL Monitor and the iPad from a different standpoint?
First, when I was hired...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
December 13, 2010 at 1:27 pm
Just as a follow-up, the backups on this server were taking approximately 89 hours/week to complete over the network. Last week we moved the storage array from one server (b)...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
November 8, 2010 at 6:18 am
I personally try to avoid giving access to Master, including making that the default database. I have seen a few instances (just after I arrived here) where people would accidentally...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
August 27, 2010 at 11:57 am
Ok... guess this is what I get for being in a hurry and not doing my research/due diligence.
Here are some posts that answer the questions (about indexes... no comments...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
August 4, 2010 at 2:06 pm
Kevin,
Thanks for the post. I found the same thing elsewhere on the web about 20% for 2005 and 2008.
I found this website that needs more review: Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
August 4, 2010 at 12:36 pm
Execution plans after updating the Statistics on InvSummary table only.
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
August 4, 2010 at 10:40 am
Stefan_G (8/4/2010)
2) Why is the plan generated for Query1 so slow ?The reason for this is probably bad statistics.
Ok... I updated the statistics for the primary key on the dbo.InvSummary...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
August 4, 2010 at 7:08 am
Stefan_G (8/3/2010)
Hmm exactly how did you produce the "scrubbed" plans ?
Did you first execute the real query, capture the execution plan, and then perform a search & replace in the...
Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)
August 3, 2010 at 12:03 pm
Viewing 15 posts - 31 through 45 (of 117 total)