Reputation
12,445
Next tag badge:
84/100 score
18/20 answers
Badges
4 34 74
Newest
 Yearling
Impact
~410k people reached

Jun
2
comment What is the optimal way to design an approval queue and audit trail for entities in SQL Server 2008 R2?
@AlexandreJobin You need to either filter on the active bit (since only one customer can be active) or have two customerIDs since it's obviously not a unique identifier.
May
27
awarded  Yearling
May
6
comment Replacing a Cursor with a single Query possible?
What RDBMS? In SQL Server this should be easily done with CTEs and windowing functions like ROW_NUMBER().
Apr
24
awarded  Nice Question
Apr
23
awarded  Nice Answer
Apr
15
comment Is the table in 3NF?
No, because title and author info are dependent on the isbn...You need a separate books table with the book info.
Apr
10
awarded  Famous Question
Apr
8
awarded  Popular Question
Mar
17
comment Joining two inline functions, slows considerably when filtering on second function
If you add a WHERE for that, it makes this an INNER join instead of an outer join. You're actually changing the shape of the plan.
Mar
16
comment Is there any way to set stored procedure options like ANSI NULLs to true or false outside of creation?
You can see the value in sys.sql_modules that the object was created with.
Mar
16
comment Is there any way to set stored procedure options like ANSI NULLs to true or false outside of creation?
It's stored in the metadata about the object, and I think you can set it through SMO though that essentially is rescripting it.
Mar
12
comment Why am I unable to use a temporary table more than once on my Stored Procedure?
You handle it like an actual table. CREATE TABLE #mytable (<columns>); insert into #mytable...
Mar
9
comment SQL Server hitting System.OutOfMemoryException but server has 10GB free
This is client side, I'm guessing. Whatever machine you are running these queries on is choking with the result set.
Mar
9
comment Is it possible to execute queries in random order?
You really need to get the statements in order, there's not going to be a dependable way to sort this out after the fact. And if you DO determine a way, it's not gonna scale or run with acceptable performance.
Mar
7
answered Join 2 columns in one table based on equal values in a third column
Mar
5
revised Deadlock scenario, where is this S lock coming from?
added 83 characters in body
Mar
5
answered Deadlock scenario, where is this S lock coming from?
Mar
4
comment Performance of Combination lookup
Good point, @ypercube. That would cover the group by as well I think.
Mar
4
answered Performance of Combination lookup
Feb
26
comment A transition table, is it a good idea?
Probably...It's fairly well normalized so whatever your parent record is for the import can be tied to the import data. Then you can have multiple versions if needed but know which records tie to which import.