1,703 reputation
219
bio website movingsql.com
location New Jersey
age 56
visits member for 2 years
seen 20 hours ago
coder & programmer of many defunct languages...

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).
May
6
awarded  Citizen Patrol
May
6
comment Challenge: Build MySQL table that's not in first normal form
A "Challenge" is not a question. "Comments Welcome!" is not a question. In fact, this whole post more of a polemic than a question, it is argumentative and ultimately, Not Constructive. It is just a very contrived excuse to argue about conflicting interpretations and applications of Relational Theory.
May
5
answered Challenge: Build MySQL table that's not in first normal form
May
3
comment Working Linked Server Query fails in sp_send_dbmail
No, Trace it in your source server, not the target (Linked) server. The error indicates a failure to connect to the target server, so of course you won't see it there, it never gets there.
May
2
comment Force sql server to run query conditions as written?
I believe that the article that I pointed to by Gail Shaw goes into some of the possible solutions, but if you wish I can delineate what the possible solutions are in my response above.