Viewing 15 posts - 4,621 through 4,635 (of 49,552 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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2015 at 5:11 pm
A restore will recreate the database exactly as it was at the time of backup
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 4, 2015 at 7:45 am
Welsh Corgi (10/3/2015)
GilaMonster (10/2/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 3, 2015 at 2:07 pm
Table definitions, index definitions, execution plan (as a .sqlplan file) and the deadlock graph please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 2, 2015 at 5:15 pm
That should be a straightforward INSERT ... SELECT. What part of the syntax are you having trouble with?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2015 at 1:43 pm
ps_vbdev (10/1/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 1, 2015 at 1:16 pm
Viewing 15 posts - 4,621 through 4,635 (of 49,552 total)