Would you rather have someone say something like... "I've never had such a requirement, never heard of such a problem, and therefor,...

I agree mostly... the second one... just loose the square brackets for readability purposes and don't use aliases that require them with the rare exception being reporting queries.

I'm thinking that your connection string had better be connecting you to some database other than the one you're detaching.

These are some fairly broad questions that would probably be best answered by looking up things like "working with cubes in SQL Server" or "using olap" or somesuch in Books...

Might have to setup something like a web service to run on an intra net... lot's of folks do such a thing... Talk to anyone who writes ASP.Net or...

There are very few reasons why this may happen...

--Uncommitted transaction

Do a transaction count at the end of the proc to find out. Might take a bit to find if...

SQL Server 2005 allows you to write PIVOT queries. Lookup the keyword PIVOT in Books Online. Books Online comes free with SQL Server and is the "help" system...

Not likely the database did it... either a human or some other program did it. Finding out what changed it will take some doing, though.

Should never grow by percent,...

One of the cylinders on my car is misfiring... I can't understand why the mechanic blew me off when I told him he couldn't look under the hood because I...

I'd say that's a pretty tall order unless you have a particular domain in mind that want's particular formatting rules. Then, you could use LIKE to build a...

Here's a "cheater" method...

count(*)*1.0/(DATEDIFF(s, MIN(scan_datetime), MAX(scan_datetime))) as ItemsPerSecond

Ok... now that everyone has figured stuff out... how 'bout everyone post their solutions? 😉

I found it... them, really.

http://www.sqlmag.com/Articles/ArticleID/19851/19851/pg/2/2.html?Ad=1

http://www.sqlmag.com/Article/ArticleID/20242/sql_server_20242.html

I'm not a "member" of that particular site so I can't see the whole article. What I glean from the two articles is...

AndyD (6/12/2008)

---

I was only regurgitating...

AndyD (6/12/2008)

---

Yes, I agree, good concise advice.

Just one quick question - you mention the Fill Factor defaults to 100% in 2005, whereas it was 90% in 2000. [To be precise,...