Viewing 15 posts - 1,501 through 1,515 (of 49,552 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...
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
April 24, 2017 at 2:52 am
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
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...
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
April 23, 2017 at 1:12 pm
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
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...
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
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...
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
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...
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
April 21, 2017 at 5:48 am
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
April 21, 2017 at 3:08 am
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
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.
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
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.
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
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.
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
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?
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
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...
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
April 20, 2017 at 2:22 pm
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
April 20, 2017 at 2:11 pm
Viewing 15 posts - 1,501 through 1,515 (of 49,552 total)