Viewing 15 posts - 14,881 through 14,895 (of 49,552 total)
Missing index DMV = suggestions, not directives. If you're looking at a long-running query, you can use that to see what indexes SQL thinks is missing on the relevant tables....
January 9, 2013 at 11:21 am
Jacob Pressures (1/9/2013)
He suggested that i could perhaps pass the SP or UDF a table name. Is the only way that can be done is through dynamic SQL?
Yes, and...
January 9, 2013 at 8:35 am
GilaMonster (1/9/2013)
There's no permanent store of deadlocks that have occurred unless you have created one.
You can't get the ' list of deadlocks available in the server' because there's no...
January 9, 2013 at 8:06 am
julian.fletcher (1/9/2013)
The client's database has a nightly maintenance job to reindex.
May not be frequent enough. May not update the stats needed.
Does SQL try to do something 'clever' with "If A...
January 9, 2013 at 8:04 am
You might be able to pull some from the system health extended events session. Whether it goes back a full week though is doubtful. There's no permanent store of deadlocks...
January 9, 2013 at 7:19 am
dwilliscp (1/9/2013)
January 9, 2013 at 7:17 am
Unfortunately I would need to see more info to really help with this. It's not a standard or known problem with a well documented solution. Could be a million things.
For...
January 9, 2013 at 7:15 am
dwilliscp (1/9/2013)
January 9, 2013 at 7:13 am
Despite the title, it's got nothing to do with always on. It's a restart of any form.
January 9, 2013 at 6:46 am
In case you missed this...
GilaMonster (1/9/2013)
January 9, 2013 at 6:42 am
Please run the CheckDB and post the results. I can't tell you how to fix it (other than restore from a clean backup) without the full, complete and unedited output...
January 9, 2013 at 6:37 am
shovankar (1/9/2013)
1. Is there a way that I can track this page back to a particular object in the database ?
Not from the information you've given, no. The output...
January 9, 2013 at 4:33 am
Don't run queries with exec plans on to take time stats. Also make sure you run more than once and ignore the first run (caching)
On a larger data volume, but...
January 9, 2013 at 4:26 am
Bhuvnesh (1/9/2013)
julian.fletcher (1/9/2013)
Really? Do you have any links to further details? That would be very helpful.sse this link http://sqlserverplanet.com/optimization/using-union-instead-of-or
That's what I was talking about with SQL 2000 and prior...
January 9, 2013 at 3:03 am
There is not a well known performance glitch with OR. ORs in a where clause used to perform badly on SQL 2000 because the optimiser had few methods to run...
January 9, 2013 at 2:51 am
Viewing 15 posts - 14,881 through 14,895 (of 49,552 total)