Not a bug.

Management studio has the same behaviour as enterprise manager did. No matter what change you make to a table, both of them drop and recreate the table,...

Itzik's 2 books in the Inside SQL Server 2005 series are excellent. T-SQL Querying and T-SQL programming

Could you give more details on the problem please?

Is the log reader slow in picking up transactions? Are the transactions taking time to get from the distributor to the subscriber?...

Rob Reid (2/4/2008)

---

I was always under the impression that putting bits or other very non selective columns in the index

was not a good idea especially if the index is ordered...

Looks like you've mostly got it under control.

Regarding those 3 older indexes, and looking at what you've said, I'd suggest the following.

nclidx_JOBS_Live_TempMode_FeatureScore - Change to Live, TempMode, SiteFK, LiveDate,...

Please do not cross post. It wastes people's time.

Please direct replies to the following thread -

Error in parameterised query (SQL 2000)

Not exactly. The OP admits that he posted in the wrong forum initially and reposted in the 2000 forum after you replied.

Since this was reposted in the SQL 2000 forum, please direct replies there.

Select distinct.. order by newID() (SQL 2000)

Is that error written into the SQL error log? What's the message that you get?

Could you post the code that you're using for the time calculation please. Along with any tables that it uses, sample data and expected output.

See http://www.sqlservercentral.com/articles/Best+Practices/61537/

Looks pretty good. If you had left...

With the table structure you've given, there's no way to tell 100% which days are holidays. It's easy to tell which days are not work days (SELECT dt FROM Calender...

You're getting stack dumps and hung schedulers. I would suggest you contact PSS (microsoft product support) and log a case with them.

I doubt this is anything that we can...

And one thing to note about the procedure cache is that only one session may put a specific proc in the cache at a time.

If you have multiple users recompiling...

What problems are you having?