Viewing 15 posts - 211 through 225 (of 432 total)
Jeff Moden (6/13/2010)
Agreed... in standard SQL, that's correct. But we're not using "standard SQL"... we're using T-SQL. 😉
I get it. If Microsoft say that the world is flat or...
June 13, 2010 at 1:17 pm
Jeff Moden (6/12/2010)
Indexes are not just about performance... they're a part of DRI.
Are you familiar with the SQL standard? It most certainly includes DRI and certainly does not include anything...
June 12, 2010 at 12:57 pm
Jeff Moden (6/12/2010)
June 12, 2010 at 12:20 pm
Maybe you are getting confused because you are asking the wrong questions. First determine what keys make sense from a business perspective. If you are thinking purely in terms of...
June 12, 2010 at 4:48 am
I got my first MVP award in January 2004. The best thing about it was that I got to network with some interesting people - other MVPs and people at...
June 10, 2010 at 2:59 pm
It was just intended as a simple example of a common situation. If you prefer then think about the example where an Order must contain at least one Order Item,...
June 3, 2010 at 4:12 am
Suresh Kumar-284278 (5/28/2010)
Would there be any performance impact deciding Integer or Varchar data type for a primary key?
Maybe, but that does seem like the wrong question. A varchar key achieves...
June 1, 2010 at 12:47 pm
RonKyle,
Your design still allows departments without managers. It's easy to create a one-to-one mapping using a table with two candidate keys:
CREATE TABLE Dept
(DeptCode INT NOT NULL, DeptName VARCHAR(50) NOT...
June 1, 2010 at 12:00 am
I don't know about wrong or not but it's a different example from the ones I had in mind.
Take a Manager table and a Department table (obviously manager may not...
May 31, 2010 at 3:40 am
Note that TRUNCATE_ONLY is deprecated. It only works in 2000/2005 and not in 2008 and later.
Also before using this you should be aware that it leaves you vulnerable to data...
May 31, 2010 at 3:31 am
Quatrei.X (5/31/2010)
Found out that this is a limitation of express edition... hmmm... but still, does anyone know any workaround to this
Upgrade to Express 2008 R2. The new limit is 10GB.
May 31, 2010 at 2:52 am
Any specific example? There might be but not seen any situation yet for circular relationships.
I expect you have come across relationships that ought to be mandatory in both directions. It's...
May 31, 2010 at 2:45 am
The DBA has historically covered at least two distinct types of role, sometimes combined into one person or team and sometimes not. Firstly, there's the Production DBA: managing servers, backups,...
May 30, 2010 at 2:15 am
As Ron says, it's not necessarily wrong from a logical perspective. In fact, relationships of this kind which are mandatory in both directions are perfectly common in data modelling and...
May 28, 2010 at 7:56 am
Digs (5/20/2010)
Doesnt a SQL server need maintenance after records have been deleted ?
No, not usually, because data tends to grow faster than rows get deleted and the space freed by...
May 20, 2010 at 12:45 pm
Viewing 15 posts - 211 through 225 (of 432 total)