Reputation
1,847
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
7 21
Newest
 Yearling
Impact
~87k people reached

May
20
comment About Criteria in T-SQL Statement
Please update your question with an example (data sample and the expected output) that shows exactly what you are trying to get.
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
comment can anyone tell me what actually is this transaction log architecture in sql server 2008?
You want it to be free and easy when it probably have taken someone years and, possibly, some money. Be thankful you've got tons of available resources now, have patience and take your time. And feel free to come back with specific questions.
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?
Apr
30
comment Is there any tangible difference between a unique clustered index and a clustered primary key?
@JamesRyan: Yes, between PRIMARY KEY and NOT NULL UNIQUE, the former would be much harder to turn into NULL UNIQUE (particularly if the constraint was already referenced by a foreign key). Would certainly prevent accidental changes from NOT NULL to NULL.
Apr
29
comment String that contains letters representing a negative number
@oharkins: This answer doesn't create anything. The @x thing is a table variable. As far as the T-SQL language is concerned, it is declared, not created. Besides, it is there as a substitute for your table. Your actual query should use your real table.
Apr
29
comment How to format SSIS Expression for weekend
Did you mean to use this "answer" to accompany your comment on @billinkc's answer? This is just confusing (at least with no explanation). Anyway, when posting code in a comment, you can enclose it in backticks (`), and it would look like this: LEFT( REPLACE( (DT_STR, 20, 1252)(DATEADD( "D", (DT_I1)DATEPART("weekday",@[System::StartTime]) ==2 ? -3 : -1, @[System::StartTime])),"-","") ,8) + ".xlsx". Not as nice, but not too ugly either. The niceness of its alignment wouldn't matter in a comment anyway.
Apr
29
revised Difference between Hash, Merge and Loop join?
inproved formatting
Apr
29
suggested approved edit on Difference between Hash, Merge and Loop join?
Apr
29
comment Is there any tangible difference between a unique clustered index and a clustered primary key?
@JamesRyan: That's covered by Jon of All Trades's reason #A.
Apr
24
answered Half of a transaction completes, when the other half fails?