And to really muck up the environment some more, add a filegroup for storing text or (MAX) columns too.

One other note, we do this regularly because, as Steve state, sharing the load across multiple access points is a simple win. However, you now need to be careful about...

Yeah, that's true. Sorry, I should have clarified. My issue is to prevent the INSERT...SELECT...INSERT chain and the OUTPUT clause bypasses that horror show quite well. I do tend to...

Here's a quick example. I'm only using a single row, but the same methodology will work with multiple rows:

CREATE TABLE Master1

(

Master1Id...

Jack Corbett (3/28/2008)

---

Count me on board the biometric side of the debate. I still think my credit card data is safer in a database than when I hand it...

Yeah, Microsoft Connect. You can submit requests for features or changes, etc. Then, you can let others know about the change you've submitted and they can go & vote for...

Honestly, neither.

What scares me is medical data. I was working for a software start-up that provided software to doctors. Not only did it store full patient history, but it had...

We did tests in the past and found that for simple lists, UDF's were WAY better than XML. XML started to shine when we were working with more complex structures.

BTW,...

You can use the SQL Server Management Studio to connect to and work with Compact databases though, if that helps. It's not stored procedures but it is a bit easier...

Version 8.0 is actually "SQL Server 2000."

It sounds like security has changed inside your database? Possibly.

What error? Are you running in SQL Server 2008? This is a 2008 forum.

Looks like tempdb ran out of space.

Either you ran a query against such a large amount of data that you maxed out your tempdb or you may have something wrong...

Also it could be the statistics are changing in your data. Make sure that they're up to date. It's really important, as noted above, to look at the execution plan,...

Database design theory, I'll leave to someone else. I'm using an ancient text called "Handbook of Relational Database Design" by Fleming & von Halle. It's too basic for most of...

Oops. Missed that one. I hate when I get hung on the first error I see.