There are ways around case insensitivity, but they aren't easy. There are usually cursors involved with Substrings or PatIndex/CharIndex used in the code.

We were forced to do a case...

Oh, yes. I have the same issue. I have developers who learned T-SQL from SS 6.5 or 7.0 and still refuse to update a lot of their practices,...

The point of my test was because someone at Microsoft (according to the OP) said that what many people have assumed for years about true about the pitfalls of Select...

You need to learn DOS commands. XCopy is probably your best bet.

Also, you'll need to make sure that:

A) Xp_Cmdshell is enabled on your SQL Server (check the SQL...

The quickest way (and as previously mentioned, you'll want to test this) is to script out all the objects in your database as Drop & Creates. Now you could...

Good point, Tim. I just found out about that yesterday. I'm about to spend a lot of time on Channel9. @=)

Like Matt, I would not do a Select Count(*). If you're only looking for the existence of the records instead of caring about how many records there actually are,...

Just a note, I don't think SSRS cares about the email address when it creates a snapshot. A bad email wouldn't cause it to not create the snapshot. ...

Post the full text of the error message please.

That's pretty cool. You should do the "Submit a Script" so that one gets into the newsletter. You'll get all sorts of feedback then. @=)

You're misreading what they are saying. They are not saying "create a file for each CPU" only. They are saying to do it based on your disk configuration...

You can't link indexes between tables. An index only ever goes on 1 table only.

The only way to link tables is with a foreign key constraint and that's not...

Tom,

It's not the number of disks involved in the RAID per say. It's the way the files are divided.

Think of it this way.

In RAID 1, you have...

Keep in mind that one data file per CPU does you little good unless you've got separate disk controllers accessing the data. You might notice a difference due to...

The only security issue I can think of with case sensitivity is Ye Ole Password issue. It depends on whether you want to use case sensitivity on logins.