Are you using the same service account on multiple SQL Servers?

That is a bad idea for many reasons, one of which is how hard it is to change on multiple...

Very urgent???

Do you need to build your data warehouse today?

Is the Location id column a string data type, like varchar or nvarchar?

If it is, you will have to cast the column to an integer datatype in the order by....

mike.styers (4/5/2010)

---

Slippery Slope I think.

Once you break out what each IT service costs, all it takes is a member of upper mgmt to say, "Look what were paying for <whatever...

Why there would be a need to explain SQL in layman’s (Lehman’s) terms?

Are the business people looking at stored procedures to try to figure out what they do?

Try moving the tables you are truncating into a new file group

The files in the new file group should be able to shrink fairly rapidly, since they will be empty...

Wildcards only work with the LIKE operator, not >= or <=

Get a bigger, faster server so it can...

It wouldn’t do anything you can’t do already. You can restore a database with a new name, verify it is OK, drop the old database, and then rename the...

The script on the link below will give you what you want.

Find Table Reference Levels

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72957

I think most problems with database applications are built-in at the design stage.

Once you do a poor job of modeling data, it becomes almost impossible to make a significant change...

If you feel that you really need to shrink the database, the script on the link below should do it. Shrinking the database file will result in index fragmentation,...

Lynn Pettis (3/23/2010)

Actually there are still a good number of current Dungeons and Dragons players out here. Why not call it a "Guild"? Other professions have Guilds, why...

You can create a FK that references a column that has a unique constraint that is not the primary key. If the Code column in TaxTable is unique and...

TravisDBA (3/23/2010)

---

Michael Valentine Jones (3/23/2010)

---

I wouldn’t go as far as to say that certifications are worthless, but I personally give them no weight at all when I look at a...