Reputation
Next tag badge:
508/400 score
72/80 answers
Badges
8 87 147
Newest
 sql
Impact
~1.1m people reached

12h
comment programme scrambeled the screen
I'm voting to close this question as off-topic because the relevance to databases is extremely tangential.
16h
comment Tell SQL Server a query is ad hoc and not to optimize based on it
Regarding missing indexes I see the same thing on 2012 i.stack.imgur.com/lo9ng.png
23h
comment Gigantic gaps in IDENTITY column
Can you add the definition of the table and show us a sample of the results? Is there any pattern to the gaps for example?
Aug
23
reviewed Edit Which command Deletes and Frees Space
Aug
23
revised Which command Deletes and Frees Space
That exam is SQL Server
Aug
23
comment Which command Deletes and Frees Space
What is the definition of the Contact table? Is it a heap or does it have a clustered index?
Aug
22
comment How to find the stored procedure which executed an event?
Extended events would allow you to see the whole TSQL call stack - but I don't think object_deleted is available in 2008. You could create a DDL trigger that logs additional information or that performs some action that is traceable with extended events though then use something like this
Aug
22
awarded  sql
Aug
21
awarded  Nice Answer
Aug
21
revised Alternative to WHERE clause
added 6 characters in body
Aug
21
answered Alternative to WHERE clause
Aug
16
comment Trouble with a NOT IN query
The query you posted looks fine. Are you sure that's exactly what you were executing?
Aug
10
revised Which DBMS are more standard compliant?
edited title
Aug
10
awarded  Taxonomist
Aug
5
comment Why is FORCE JOIN option slowing down query and forcing execution plan to sort prior to joining tables?
@Synergist - These are just screen shots from SQL Sentry Plan Explorer TBH i wasn't expecting removing the TOP to improve things. Removing the row goal must have altered things in a lucky way.
Aug
5
revised Why is FORCE JOIN option slowing down query and forcing execution plan to sort prior to joining tables?
added 203 characters in body
Aug
5
comment Why is FORCE JOIN option slowing down query and forcing execution plan to sort prior to joining tables?
select top 100000 * from anchor won't give you deterministic results. What is the query supposed to be doing? Also table definitions including indexes?
Aug
5
comment How can I learn more about how SQL Server “normalizes” queries prior to creating the execution plan?
8606 gives you the trees before and after normalisation. A similar claim was made here dba.stackexchange.com/a/108863/3690
Aug
5
awarded  Nice Answer
Aug
4
awarded  Constituent