Viewing 15 posts - 1,021 through 1,035 (of 49,571 total)
July 31, 2017 at 5:36 am
Crystal ball to aisle 7 please. Crystal ball to aisle 7.
https://www.sqlservercentral.com/Forums/1889451/Should-I-Redesign-table
July 31, 2017 at 5:33 am
A picture's not very useful. Save the deadlock graph as a .xdl file, and attach it.
July 31, 2017 at 5:32 am
No way to answer that question without a lot more details.
Start with the table design and the deadlock graphs
July 31, 2017 at 4:13 am
Make sure you only have one file name in that window, otherwise your backup is spread across the files and they are *all* necessary to restore the backup (they're slices,...
July 30, 2017 at 4:10 pm
When you give the backup file a name, give it the .bak extension. SSMS doesn't do it automatically (or you can change it after the backup, will have the same...
July 30, 2017 at 3:53 pm
July 30, 2017 at 3:36 pm
You could have en extended event session that tracks the recompile and cache insert events, but then you'd still have to check what plans is in cache and have some...
July 30, 2017 at 7:36 am
Can you post any relevant logs, SQL error log, Windows event log?
July 30, 2017 at 7:33 am
Don't ever run DTA against your production DB. If you do want to use it, run it on a test server and evaluate its recommendations carefully before implementing any.
July 28, 2017 at 4:19 pm
Oh this is going to be a bloody pain to fix. 🙁
How big is the DB?
To be honest, it may be simpler to move everything over to...
July 28, 2017 at 2:32 am
July 28, 2017 at 2:28 am
Can you post the code?
July 28, 2017 at 2:26 am
Viewing 15 posts - 1,021 through 1,035 (of 49,571 total)