I'll second rbarry's post. Performance is not as big a deal now. The others are. Here are a couple of links to Andy Warren's Blog (It Depends)...

You cannot backup based on schema. You would need to put the object within each schema on a separate file. Then you could do file backups and restores.

My...

You obviously do not have autoshrink enabled so you need to manually shrink your transaction log using DBCC ShrinkDB or DBCC ShrinkFile

It looks like you are using Integrated Security to connect and the ODBC connection is grabbing the guest user login for the server. Has that login been granted rights...

Do the tables have the same unique key that you could join on? If they do you do not need a cursor. You could use a full outer...

Have you enabled remote connections on the SQL Express instance?

While I agree with ALZDBA that actually writing the sql for each combination is probably better I will attempt to answer your question.

I would write the code something like this:

CREATE...

I did not find this issue on Microsoft Connect so I submitted it as a bug. Here is the link for anyone who would like to confirm it:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=335613

Thanks again...

Will do.

Guess what, mine matches Todd's. Here it is for confirmation:

Microsoft SQL Server Management Studio 9.00.3042.00

Microsoft Analysis Services Client Tools ...

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 to the...

Well, Rob, I also fall into the performance always matters camp, so I normally don't mind writing specific stored procedures because that is how you get the best performance. ...

Ashwin M N (3/27/2008)

---

I checked each of the queries they are not what we call bad queries. They cannot be optimized further which I am sure. The one thing I...

Rob,

I usually explain things in detail because you never know the expertise of the poster so I like to try to make it so anyone can understand it.

I would have...

wwang (3/27/2008)

---

Jack,

Thanks for your reply.

So, the bigint will serve up to 2^63.

What is the datatype will serve up to 2^127 integer number?

Or, the SQL Server 2005 can have...