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

2d
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.
2d
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
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
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
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
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
21
comment The cost of left out join versus a select
My understanding is the OP can't control the join type because that is something that Ebean (a framework of some kind? I don't know) generates based on an instruction like return aInstance.bInstances. Nevertheless, I don't think there's a much clearer answer to give at this point. They never elaborated on what exactly the generated left join query looks like.
Apr
20
comment how to revoke backup and restore permission from database owner
Why would you modify privileges of the built-in database owner role rather than creating a custom role without the backup or restore permission and moving your users to it?
Mar
31
comment How is the B-Tree created for a composite PK?
When I query this, only PersonID was sorted physically and PersonAge was left out (not sorted) – what specifically do you do when you are trying to determine that?
Mar
24
comment How to query readonly replica in Always On cluster
I wasn't sure I'd manage a coherent answer. Thanks for coming back and sharing what you actually did.
Mar
24
comment How to query readonly replica in Always On cluster
@retif: Could you afford a duplicate linked server item CLUSTERname2 configured the same way as CLUSTERname but additionally having ApplicationIntent=ReadOnly in its connection string (and use CLUSTERname2 in SELECT-only queries, of course)?
Mar
24
comment SQL query for next occurrence of specific date
You could also complicate it even further to get rid of the subselect (no idea if that would be of any benefit).
Mar
18
comment use parameters in a Cte
As for the Connect item, I think it's about a different issue. It's about using functions when calling a stored procedure, and the OP wants to use functions in a specific place of a declaration.