Reputation
2,035
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
7 21
Newest
 Yearling
Impact
~97k people reached

May
28
revised SELECT DISTINCT on multiple columns
changed to a CROSS JOIN (thanks ypercube)
May
28
answered SELECT DISTINCT on multiple columns
May
28
revised How to Retrieve data within nested select statement?
resized the first image for readability
May
28
suggested approved edit on How to Retrieve data within nested select statement?
May
26
revised How to monitor history of logins to database if login auditing is not enabled?
removed redundant empty lines from the script, corrected spelling, (slightly) improved formatting
May
26
comment Outer left join with WHERE loses row
Because 'some value' != NULL doesn't evaluate to True. It doesn't even evaluate to False, it evaluates to Unknown (but is treated the same way as False in this case).
May
26
comment How to monitor history of logins to database if login auditing is not enabled?
The OP doesn't seem to be interested in index usage per se. They want the history of logins and they've only mentioned sys.dm_db_index_operational_stats because someone suggested that DMV as a way to get the information they want.
May
26
suggested approved edit on How to monitor history of logins to database if login auditing is not enabled?
May
26
comment MYSQL - number of rows returned equals number of connections?
Whether the connection is dropped immediately after the query or not might depend on the architecture of your application or on the settings/capabilities of the middle tier that your application uses to actually connect to/communicate with the database. If the database component uses a server-side cursor for the result set returned, the connection may stay live all the time until you've finished working with the application or explicitly specified to close the connection.
May
20
comment SQL Server - Best practices on debugging extremely complex stored procedures
100+ parameters, but surely not all of them are mandatory? Perhaps there are patterns of parameter combinations that the procedures are supposed to be called with? I would start with finding and refactoring those.
May
16
revised CTE Error (nvarchar to numeric)
added a missing phrase
May
16
suggested approved edit on CTE Error (nvarchar to numeric)
May
15
comment Deep cloning a hierarchical database structure
If you are using SQL Server 2008+, take a look at this Stack Overflow question. Its Linked section can give you examples of usage of the method.
May
14
comment SQL Server 2012: set a column to only use a single case?
Or have a computed column for it that shows the UPPER/LOWER version, and read that instead of the source column.
May
4
revised Why is Full Recovery model a requirement for AlwaysON?
grammar, punctuation
May
4
suggested approved edit on Why is Full Recovery model a requirement for AlwaysON?
May
4
comment Why Update trigger makes Insertion slow in mysql?
Are you inserting or updating rows? Do you only have an AFTER UPDATE trigger on the table or is there an AFTER INSERT one as well?
Apr
30
comment Normalization of library book table with multiple authors
All right. I didn't make any point in this thread apart from my previous comment, but that's okay. :) Of course, you could just post a comment under the other answer to point out this aspect to the OP, but fine. Personally I'm not in the habit of downvoting duplicate answers, but some people might be (just FYI).
Apr
30
comment PostgreSQL function definition “syntax error at or near +”
How did it work great then? What did you mean by that?
Apr
30
comment Normalization of library book table with multiple authors
Hm, but that's just what the other answer suggests. What is your point in repeating the same suggestion?