SQL Server Storage sql_variant
sql-server-2008-r2
ooutwire ooutwire
6 The first 2 answers are from the SQL Server Internals Book p.278
Martin Smith
Grouped string concatenation with XML PATH and STUFF error
sql-server-2008-r2
B McCarthy B McCarthy
5 Sorry, I missed a step in the relationship. Try this version (though [Martin's will work as well](https://pastebin.com/Fz601fDC)):
aaron bertrand
4 I thought I would try a solution using XML:
Paul White
Help with PIVOT query
sql-server-2008-r2
Kin Shah Kin Shah
4 This is a bit messy to get the final result because you have multiple `SCHEMA_VER` for each date. Before I demonstrate how to do this with dynamic SQL, I'll first show how to do it with static code to get the logic correct. In order to get the final result you can utilize both pivot and unpivot.
taryn
3 Adding explanation and a fiddle: http://sqlfiddle.com/#!6/c92b2/5.
JoseTeixeira
Giving server-role to login breaks stored procedures
sql-server-2008-r2
BenVlodgi BenVlodgi
7 Grant `CONTROL SERVER` to the login rather than adding it to the `sysadmin` role.
Paul White
Can you explain this execution plan?
sql-server-2008-r2
Andrew Savinykh Andrew Savinykh
10 The constant scans each produce a single in-memory row with no columns. The top compute scalar outputs a single row with 3 columns
Martin Smith
Why doesn't this invalid subquery raise a syntax error?
sql-server-2008-r2
Ravindra HV Ravindra HV
2 This is the same as:
aaron bertrand
Execution plan percentages don't add up to 100%
sql-server-2008-r2
it researcher it researcher
2 The sum of operator costs is more than 100% in execution plan is a [known bug and is closed as by design](https://web.archive.org/web/20131118011039/http://connect.microsoft.com/SQLServer/feedback/details/621330/sum-of-operator-costs-is-more-than-100-in-the-execution-plans)!
Kin Shah
Improve OR inside INNER JOIN
sql-server-2008-r2
racer sql racer sql
3 A common query rewrite that helps with `OR` predicates looks like this:
meme
Better approach for “LIKE OR LIKE, OR LIKE, OR LIKE, OR LIKE”
sql-server-2008-r2
racer sql racer sql
2 Full text indexes generally aren't a magic bullet, and require additional maintenance, disk space, and fairly intrusive changes to query patterns.
meme
Actual rows read in a table scan is multiplied by the number of threads used for the scan
sql-server-2017 sql-server-2008-r2
radu gheorghiu radu gheorghiu
0 Parallel heap scan
Paul White
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.