Reputation
32,382
Next tag badge:
978/400 score
79/80 answers
Badges
8 81 137
Newest
 Nice Answer
Impact
~1.0m people reached

10h
revised Is something like this possible in SQL Server?
added 63 characters in body
10h
comment Is something like this possible in SQL Server?
@Jack - Yes - you need to add the column alias to the top of the except. See edited answer.
11h
answered Is something like this possible in SQL Server?
1d
revised Suppressing the SSMS prompt to save changes
added 497 characters in body
1d
revised Subquery magic in PostgreSQL
added 295 characters in body
1d
comment What's the difference between “expression <=1.” and “expression <= 1”?
The lack of any 0 after the decimal point and the fact that decimal has higher datatype precedence than int so the constant would be implicitly cast anyway if needed would make me think that it is likely a typing error rather than deliberate.
1d
revised What's the difference between “expression <=1.” and “expression <= 1”?
edited title
2d
comment How to filter a column of type DATE THE MAXIMUM RECORD DATE IN OBIEE
Please put more effort into your questions than this. Short on explanation and long on ALL CAPS.
2d
answered Subquery magic in PostgreSQL
2d
comment Why isn't my query returning the correct results?
So presumably you have no data matching the where clause then.
2d
answered Index performance on ON versus WHERE
2d
revised Benefits of making a sql server database as read-only?
added 198 characters in body
2d
awarded  Nice Answer
Jun
29
comment concatenating columns from multiple unrelated 1-row resultsets
Or CROSS JOIN of course but hardly worth a separate answer.
Jun
28
comment order of inserting record is mismatching
You state that "the data is stored physically in the order of the clustered index" - as I commented on the other answer this is not always the case. This is shown visually in my answer here stackoverflow.com/a/24470091/73226
Jun
26
revised Datediff with many dates causes poor performance?
added 4785 characters in body
Jun
26
comment Is it better to use an ID (int) or a Name (varchar) as PK for a table?
@Enthusiast - You could still optionally enforce the uniqueness with a unique constraint if you wanted. My point is that it gives you more flexibility. Are you going to tell the business that they can't name a product "bread" because that was the name of a deactivated product 5 years ago?
Jun
26
answered Is it better to use an ID (int) or a Name (varchar) as PK for a table?
Jun
26
comment SQL Server Management Studio greyed out
Hmm, found this for 2005 social.msdn.microsoft.com/Forums/sqlserver/en-US/… the path to the Shell folder will be different for 2008 but could well be basically the same fix.
Jun
25
comment Keep connections alive when disconnected from network
Related recent question dba.stackexchange.com/q/104920/3690