Oops. Hit the "Post Reply" button too soon.

And no, this isn't a problem, depending on how you apply it. Multiple varchar fields of length 3000 would be a really poor...

You mean "compound" primary keys right? Because you can only have one primary key per table.

Although, you can have multiple unique constraints and refer to those as "alternate" keys...

Nope. That isn't possible.

What you can do, although it is VERY strongly not recommended, is pass the table name in as a string and then use dynamic TSQL to use...

Just remember that Books Online (BOL), the doucmentation installed with SQL Server, is your best friend in the world. Don't be a afraid to open it up and read up...

This is a decent overview.

Sorry Sandy, not a clue. I've only seen MySQL once or twice. I'm just not terribly familiar with it.

After you get the truncate working, you'll want to look at the query plans for the views to ensure that good indexes are in place.

That is odd. Did you try taking off only part of it? Remove the parenthesis? Remove the ON [Primary]? Remove one of the WITH clauses?

I'm just not sure. I've run...

We've used LiteSpeed for quite a while. Nothing spectacular to report. The tools is pretty solid. Quest has been adequate as a vendor. I've also tested RedGate's tool and found...

You've got a second problem as well, you need to make sure that you have the security settings to allow you access to that file. Once you've addressed that...

Can they...

I've stayed away from using functions, but the CROSS & OUTER apply statements work incredibly well with set based SELECT statements applied to the rows returned by the rest of...

To do that automatically you can either buy a tool like Embarcadero Rapid SQL that will do it for you, write a program using SMO to walk each table generating...

You're asking for improved methods of Row-By-Agonizing-Row (RBAR) processing. That type of processing is inherently slow because TSQL is set up & optimized for set based processing. You're almost guaranteed...

Sorry that wasn't helpful. I thought that covered most everything. However, for drill down, one place I go is the Query Procesing Team blog. This is the Storage Engine team's...

I've tested in 2008 and 2005. I also change the compatibility level of the database I was testing on and it worked on all of them, even 7.0. I'm not...