DId you check the data for non-null values. If so and you can reproduce then I would check with MS KB site and MS directly. ALso did you try other...

All fixed length datatypes will take up the space if NULL or not. SO a CHAR(4) will take 4 bytes period, an int will take 4, datetime 8 and so...

I agree you are supposed to be putting the DB in Single User Mode or DBO Use Only for some of the indexes to work. However, I did notice when...

quote:

---

I don't think there is a way to know this after the fact. Possibly Log Explorer from Lumigent could get this info.

Steve...

Ok, just let me rephrase one thing Brian states.

quote:

---

Truncate table basically is faster because of how it "removes" the data.

---

To the best of my knowledge unless you had a trace running to watch this you cannot find out.

What is happening in the first example is using a number like 1 is considered the number of days since 1/1/1970 so 1 is 1/2/1970 and 12 is 1/13/1970, all...

Look at the CASE statement in BOL.

I had done lot's of things before I even finished High School.

Roofing

Appliance Repair

Building Construction and Renovation

Concrete mix facility (front end loader, got to drive the gravel and mixer trucks around...

I have always heard and read several places (sorry don't remember) to leave 60 MB minimum for the OS, but the more you leave the better things will be because...

Have never heard such a thing as there is nothing to lock other than the row it is going into. I have a table that processes about one hundred thousand...

quote:

---

(and since pets are being added to the family list, I've also got a dog (a bordie collie)

Two little spawns of satan...

And I have a copy of EE we tested on Home and Professional editions of XP, both did fine even with File and Print sharing turned off. However I have...

Even better open QA then choose Tools->Options and on the General tab you will find a checkbox item labeled "Select SQL Query Analyzer as the default editor for query fiel...

quote:

---

I need to audit a table using instead of update trigger. Since this update trigger will fire instead of the actual...