Viewing 15 posts - 1,876 through 1,890 (of 18,926 total)
SQLRNNR (10/19/2011)
Ninja's_RGR'us (10/19/2011)
SQLRNNR (10/19/2011)
Ninja's_RGR'us (10/19/2011)
SQLRNNR (10/19/2011)
Is that what your five finger reference meant?No, that was for stealing!
Somebody stole your ring err pants?:-D
Yes, you actually stole a quote I had posted...
October 19, 2011 at 10:26 am
Other than full text search you won't find much better.
October 19, 2011 at 10:22 am
Ninja's_RGR'us (10/19/2011)
Do you have heaps?
October 19, 2011 at 10:15 am
Actually my phone is still available in google.
Unfortunately, that company seems to be out of business.
October 19, 2011 at 10:11 am
SQLRNNR (10/19/2011)
Ninja's_RGR'us (10/19/2011)
SQLRNNR (10/19/2011)
Is that what your five finger reference meant?No, that was for stealing!
Somebody stole your ring err pants?:-D
Yes, you actually stole a quote I had posted 20 minutes...
October 19, 2011 at 10:09 am
The only guess I have is that the setting is changed during dbcc.
Can't test this tho!
October 19, 2011 at 10:09 am
That can't be. When did the backup go from 3-4 Gb to 20?
October 19, 2011 at 10:01 am
SQLRNNR (10/19/2011)
Is that what your five finger reference meant?
No, that was for stealing!
October 19, 2011 at 9:59 am
GilaMonster (10/19/2011)
Ninja's_RGR'us (10/19/2011)
No phone support?
Yes, I really want to sit on hold for an hour or 3 paying international phone charges. They have a toll-free number, but it's only toll-free...
October 19, 2011 at 9:43 am
Any process that drop and reloads something?
Do you reindex all tables in a job?
Do you have heaps?
October 19, 2011 at 9:43 am
This data is since last server recycle so it makes no difference at all.
I might post a script later about task waits and that one would be during. ...
October 19, 2011 at 9:35 am
No phone support?
October 19, 2011 at 9:34 am
Any table with blobs? or datatype (MAX)?
Been doing lots of deletes lately?
October 19, 2011 at 9:34 am
Top 1 is "easier" because you can get all the columns you need without going back again to the base table.
Another version would be with rownumber but top works nicely....
October 19, 2011 at 9:32 am
1st guess would be blocking.
What does this return?
/*
Microsoft White Paper on waits http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/Performance_Tuning_Waits_Queues.doc
Next query by Paul Randal http://www.sqlskills.com/BLOGS/PAUL/post/Wait-statistics-or-please-tell-me-where-it-hurts.aspx
*/
WITH Waits AS
(SELECT
...
October 19, 2011 at 9:25 am
Viewing 15 posts - 1,876 through 1,890 (of 18,926 total)