Viewing 15 posts - 1,501 through 1,515 (of 49,571 total)
Your options are:
- Create a covering index
- Live with the key lookup
- Change the query to not select columns it doesn't need, and then add a covering...
April 24, 2017 at 2:52 am
April 24, 2017 at 2:50 am
User "maomfamao" is posting what looks like it could be malicious links all over the forums. I've flagged a couple of posts, but...
April 23, 2017 at 1:12 pm
April 22, 2017 at 3:41 pm
pietlinden - Friday, April 21, 2017 9:50 PMfirst you'd have to post the definitions of views 1, 2, and 3.
Also please post...
April 22, 2017 at 10:44 am
Apologies, the day got away from me.
Ok, so everything less than 2016-03-31 is in the correct partition.
Some of this I know you've already done, it's here for...
April 21, 2017 at 9:56 am
Sounds about right. Those two "2 Bytes for Fixed length" and "2 Bytes for all columns" are storing information about the offsets within the data portion for the fixed length...
April 21, 2017 at 5:48 am
April 21, 2017 at 3:08 am
April 21, 2017 at 2:15 am
I like setting them to sa. The login can never be removed, and you can't accidentally grant higher permissions to it, since sa is sysadmin.
April 21, 2017 at 2:09 am
Rows have headers as well. Dump type 3 on DBCC Page will shred the row as well, so you can see what's there.
April 21, 2017 at 2:02 am
While it may be a new database, the system tables were there before you created the user table, hence the first couple hundred pages are already allocated.
April 21, 2017 at 2:00 am
sreesree.96 - Thursday, April 20, 2017 2:58 PMAnd i big thank you for helping me out.!
Actual execution plan? Table and index definitions?
April 20, 2017 at 3:22 pm
Table definitions and index definitions?
And an actual execution plan would be much more useful. Run the query with the 'include actual execution plan' option turned on (button on...
April 20, 2017 at 2:22 pm
April 20, 2017 at 2:11 pm
Viewing 15 posts - 1,501 through 1,515 (of 49,571 total)