Viewing 15 posts - 10,396 through 10,410 (of 59,065 total)
Let's stop guessing... what is the query? What is the actual execution plan. Please see the second link in my signature line below for what we need to be able...
December 6, 2018 at 9:11 am
eg:
select...
December 6, 2018 at 8:38 am
December 6, 2018 at 8:33 am
Do you have the Standard or Enterprise edition of SQL Server?
Also, spitting the backups to multiple files could actually slow things down unless you can guarantee that each...
December 6, 2018 at 8:14 am
December 6, 2018 at 7:59 am
I find that if it's actually to be found in the default trace, you got damned lucky. Most default traces get full and rollover very quickly on busy systems.
December 6, 2018 at 7:51 am
December 6, 2018 at 6:58 am
Ah... just can't do it... there are a few things wrong with that site including their statement of "you agree to license everything you submit by
December 5, 2018 at 6:38 pm
it is just too darn difficult to choose a good clustering key. As a...
December 5, 2018 at 6:26 pm
December 5, 2018 at 9:56 am
The real key (no pun intended) is that the method you're using to do such an increment is prone to problems. I strongly recommend that find a better way. For...
December 5, 2018 at 9:53 am
gksingh005 - Tuesday, December 4, 2018 9:55 PMcraig it seems this is the default behaviour of sql 2017/19 you need not worry.
Wow......
December 5, 2018 at 9:50 am
I guess my first question would be, when is the last time stats were rebuilt for this index? And, remember, logical fragmentation means very little once something is in memory. ...
December 5, 2018 at 9:44 am
Viewing 15 posts - 10,396 through 10,410 (of 59,065 total)