By default, put indexes on your FK columns (so they match the PK they refer to) and have the FK declared with check.

Grant published a little but great article on...

please read http://technet.microsoft.com/en-us/library/dd758814(SQL.100).aspx for more info.

ps

AFAIK SSDs no longer use read/write heads, so they won't have to be aligned ...:w00t:

Default trace typicaly has trace id 1.

Check sys.traces to figure out what kind of trace that is, what file it tries to write to, and check if you can correct...

Installed it on my laptop instance.

It took 30 minutes.

First impressions: seems to be working fine.

First startup of SQLAgent got a "Warning [1]: Possible date calculation spin for Schedule 1"....

SQLkiwi (12/18/2010)

---

Thanks, though the old twitter references...

Hey .. paulwhitenz also disappeared at SSC.:hehe:

Welcome SQLKiwi 😀

Keep in mind to have SSC altering your twitter refs in your articles 😉

sorry for that :Whistling: 😉

btw If these managers have some kind of awareness, they would understand you first need to test it on a DBA-only instance, before you can implement...

Are you already familiar with SQL2008.

If not, start testing it yourself !

maybe even get an upgrade course.

for your db/instance:

1) download SQL2008 upgrade advisor

2) run it against the db you want...

- Personally I don't like those column level select statements in the select clause.

Maybe the engine will even parse it into a join for you, but IMO it is a...

With regards to the beverage, I used milk and honey and that did a good job.

But I will take it into my notes.

That breaking up will indeed be needed if...

Steve Jones - SSC Editor (12/16/2010)

---

Stefan Krzywicki (12/16/2010)

---

I wonder if he's still doing that now that there's Intellisense. I like aliases, even one letter ones, but they have to be...

I noticed my devs prefer getdate because they get confused by sqlservers timestamp data type and that same word in current_timestamp !

:blush:

I think that issue should have been fixed by...

As stated by the other repliers, it doesn't seem to make much sense.

you can restrict login at ipaddress level using a server level trigger (sql2005 SP2 or higher)

but just keep...

what do you expect to be your third value in your in-list ?

Grant Fritchey (12/16/2010)

---

It's going to sound funny when I say this, but the sore throat must have something to do with how you speak. I really don't do anything in...