1,829 reputation
320
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years, 3 months
seen 2 days ago
coder & programmer of many defunct languages...

Sep
18
answered How to know the user doing a delete action on an audit table, when using a shared login?
Sep
18
comment How to know the user doing a delete action on an audit table, when using a shared login?
Fair enough, I should have read your question more thoroughly. I think I have an answer for this, but I may not be able to post it until late tonight.
Sep
9
comment Plan cache memory: parameterized SQL vs stored procedures
The number one reason that I prefer stored procedures is their security control and options that are far superior to any other approach that I know of with SQL Server.
Jul
13
comment Check existence with EXISTS outperform COUNT! … Not?
Heh, you know, I have t-shirt with my username on it, but the first four letters crossed out ("<strike>RBAR</strike>RYYOUNG").
Jul
9
comment TempDB Version Store cleanup
"One of the applications hosted on the database instance has an open transaction that is 40 days old.." This cannot be doing your backups any favors either. Seriously, the best fix here is to stop doing that. Any program or product that holds a transaction open for such extended periods is very broken.
Jun
26
revised Finding the last command issued by a blocking process
added 2 characters in body
Jun
21
answered Finding the last command issued by a blocking process
Jun
6
awarded  Nice Answer
Jun
2
revised How to see what is cached in memory in SQL server 2008?
Add link author's last name.
Jun
2
suggested suggested edit on How to see what is cached in memory in SQL server 2008?
May
29
awarded  Nice Answer
May
20
comment Best practices with large amount of data
OK, fair enough.
May
20
comment Best practices with large amount of data
You present Normalization and Performance as co-equal and independent things in database design. They are neither. The first step in good design is always Normalization, because that's how you make sure that it's a correct design. Not coincidentally, the first step in Performance is also a normalized design. The number of tables has nothing material to do with either of these until much later in the process. Worrying about the number of tables during the design process is a recipe for bad designs, especially for someone who is unsure of what they are doing.
May
20
comment Best practices with large amount of data
"more tables is usually better.." is a gross oversimplification that easily leads beginners to create horribly non-relational designs (like the second one the OP proposed). Let them figure out Normalization first. Only when they understand that completely should they start to worry about the performance of the design (as opposed to the performance of the implementation, which is a different thing).
May
9
comment Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001
+1: good catch.
May
9
comment Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001
@Phillip You had auto-close on?!? Ah. Well yes, auto-close can cause all kinds of errors and other havok.
May
9
comment Msg 21, Level 21, State 1, Line 1 Warning: Fatal error 9001
Well, a bounty has been added to the question, so I assume that the OP is looking for something more than what I provided. However, if that is the case, some feedback to let us know what else is needed would be helpful.
May
6
comment How can I query data from a linked server, and pass it parameters to filter by?
When you say "Distributed Transactions are disabled" what do you mean? How exactly are they disabled and what error do you get when you try that INSERT .. EXEC .. command?
May
6
comment How can I query data from a linked server, and pass it parameters to filter by?
All of your constraints have pretty much eliminated all of the good ways to do this.
May
6
comment Same query taking 0.2 sec in Oracle database but 4 mins in SQL Server
Is the SQL Server Query Plan an Estimated or an Actual? Whichever it is, can you post the other as well? This would be very helpful for figuring out where it is going wrong. Also, what is the total Subtree Costs for each? (this isn't visible in the image, only in the popups).