Please note that there still is a difference in supported...

I agree you want to avoid using auto-grow as much as possible. Keep an eye on your space, and grow the files manually when they get close.

For emergency purposes,...

Per SQL 2005 licensing: running ANY component of SQL Server 2005 on a given server requires that that server be fully licensed for SQL 2005.

Meaning - it really doesn't...

Grant - they're not in chronological order... Look back in the sequence - there will be posts you haven't seen before. Look at the post #: the...

You're very welcome!!

(trying this again).

I would use ASP.NET 2005, and simply go with the built-in user controls. there's just about zero coding required.

Drop a formview control on the page, point the formview...

I would use ASP.NET 2005, and simply go with the built-in user controls. there's just about zero coding required.

Drop a formview control on the page, point the formview at...

Nisha (3/6/2008)

---

Thanks a ton, Jeff... I'm so relieved.

I thought I was gonna have to re-write my import process, which took me ages to write in the first place.. what with...

Laurie - it's entirely possible that the DMV recommendation is right. It has access to your statistics (how the data is distributed, etc...), which would make it make that...

Actually - not so sure it has anything to to with timezone settings anymore. It's more like UTC isn't being used anymore - posts are being sorted by local...

Jacob Luebbers (3/6/2008)

---

Whoa! Don't do that - SELECT... INTO... on a temp table needs a schema lock to create...

You should use the NTILE functionality which will allow you to "chunk" it into multiple pieces of the same size. It's described in Books Online.

Your XML markup got "whacked" (you need to do some find and replace stuff before posting it for it not to disappear).

Replace < with ...

Have you considered making the NCI covering? without covering the rest of the fields needed, IF the NCI is being used at all, bookmark lookups would make this take...

Double-posting - follw the conversation over here:

http://www.sqlservercentral.com/Forums/Topic464117-146-1.aspx