Viewing 15 posts - 1,366 through 1,380 (of 49,571 total)
May 30, 2017 at 8:20 am
It looks like I can create an index, then drop the table to accomplish the...
May 30, 2017 at 7:24 am
Ignore it.
Fragmentation is highly unlikely to be the cause of your performance problems.
Performance problems mostly come down to poor indexing (as in incorrect or no indexes) and...
May 30, 2017 at 6:44 am
nadersam - Tuesday, May 30, 2017 5:04 AMBut could you tell me please how could a bad plan go into cache
Nearly...
May 30, 2017 at 5:42 am
Most likely nothing to do with the indexes themselves.
Rebuilding indexes updates statistics and updating statistics invalidates all execution plans that use those stats. If a couple bad plans...
May 30, 2017 at 4:58 am
ChrisM@Work - Tuesday, May 30, 2017 1:57 AMYou can, but you have to pay a shoulder and a leg for it 🙂
Your...
May 30, 2017 at 3:18 am
A case statement returns expressions (constants, functions or variables), not select statements
If you want to not query the table at all if it's empty, then you need an...
May 30, 2017 at 3:16 am
And Python will be usable in the next version of SQL Server (2017)
I decided to start with R, and then pick up Python later
May 30, 2017 at 1:20 am
May 29, 2017 at 1:19 pm
Oh, and Eirikur...
Brown lamb shanks in a pan, remove from pan
Soften some onion and garlic
Add a good amount of curry powder (I use pre-made, as we...
May 29, 2017 at 1:18 pm
May 29, 2017 at 8:05 am
krishnabudampati - Monday, May 29, 2017 5:36 AMHow to get execution plan of a SQL which has executed two days back?
Unless that...
May 29, 2017 at 7:53 am
Something tells me that this is going to take a while...
https://www.sqlservercentral.com/Forums/1878491/SQL-server-2014-is-very-slow
May 29, 2017 at 7:48 am
That is not what I asked for. Please read what I'm asking.
Filter out the meaningless waits. There are plenty of references online as to which ones are not...
May 29, 2017 at 7:46 am
Viewing 15 posts - 1,366 through 1,380 (of 49,571 total)