Viewing 15 posts - 4,621 through 4,635 (of 49,571 total)
If you're in compat mode 100, then it's not the cardinality estimator. That's usually what causes performance regressions in 2014. The traceflag Phil suggested won't help if it's not the...
October 4, 2015 at 5:14 pm
Absolutely terrible advice. If you're running out of space it means you don't have enough disk space for the database.
Shrinking a database should NEVER be a regularly scheduled operation....
October 4, 2015 at 5:11 pm
A restore will recreate the database exactly as it was at the time of backup
October 4, 2015 at 7:45 am
Welsh Corgi (10/3/2015)
GilaMonster (10/2/2015)
October 4, 2015 at 4:48 am
The difference between EXISTS and JOIN is minimal, so even if you could, there wouldn't be much point in doing so.
Also, a clustered index doesn't have to be unique, it's...
October 3, 2015 at 2:07 pm
Table definitions, index definitions, execution plan (as a .sqlplan file) and the deadlock graph please.
October 3, 2015 at 2:06 pm
toniothomas (10/2/2015)
Check if the query posted at this link works. Seems to get me what I want with respect to an index creation date
Here's a test. Create a table, wait...
October 3, 2015 at 2:04 pm
myzus2004 (10/3/2015)
Jason even if i do it seperately and then join , then also SQL Server will have to use 3000 times XML path .
No, if you insert these (SELECT...
October 3, 2015 at 2:02 pm
tauseef.jan (10/2/2015)
i am getting out of memory pop ups and there are many ad hoc queries running on the server.
SQL Server won't give you popups, it's a server process, it...
October 2, 2015 at 5:24 pm
chuck.forbes (10/2/2015)
You're right, the file isn't 99% unused, it's 99% used. I interpreted that backwards. I can see the need for the checkpoint now.
Checkpoint won't do anything, you...
October 2, 2015 at 5:20 pm
Don't clear them. If it's stuff like index usage, index operational stats, wait stats, latch stats, take a record of the DMV at regular intervals and query for the differences...
October 2, 2015 at 5:18 pm
You can't back up TempDB and shrinking it is pointless if there's a process which uses a lot of TempDB, it'll just grow again. It's like complaining that the 20...
October 2, 2015 at 5:15 pm
That should be a straightforward INSERT ... SELECT. What part of the syntax are you having trouble with?
October 1, 2015 at 1:43 pm
ps_vbdev (10/1/2015)
October 1, 2015 at 1:23 pm
Lynn Pettis (10/1/2015)
GilaMonster (10/1/2015)
You've either got a filter in the trace definition or the deadlock didn't occur.
Only filter used was to the database and user involved (all connections use the...
October 1, 2015 at 1:16 pm
Viewing 15 posts - 4,621 through 4,635 (of 49,571 total)