network profile
| bio | website | movingsql.com |
|---|---|---|
| location | New Jersey | |
| age | 55 | |
| visits | member for | 1 year, 1 month |
| seen | May 20 at 14:12 | |
| stats | profile views | 61 |
coder & programmer of many defunct languages...
|
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. |
|
May 2 |
awarded | Nice Answer |
|
May 1 |
comment |
Is there a better way than the ones listed within to join data in an excel spreadsheet to a table in a SQL Server database? The other obvious option is to "Export" the SQL data to Excel. That is, create a "simple" query that just returns all of the data, then match/filter it in Excel. So "monster" data-size instead of "monster" query. |
|
May 1 |
answered | Force sql server to run query conditions as written? |
|
Apr 30 |
comment |
How to bind contract to service? Also, what version? |
|
Apr 30 |
comment |
How to bind contract to service? Show us the relevant definitions, and the sending code. |
|
Apr 30 |
answered | Worse performance on a new server |
