The answer is yes, it does. But, it's important to understand what that means in SQL Server.

What it isn't is a grid clustering solution - e.g. you can not have...

Your best bet without doing any major code changes is to try something like this:

ALTER TABLE table1

ADD Concatenated_Column as col2 + ':' + col3 PERSISTED

CREATE INDEX IDX_table1_Concatenated_Column ON table1(Concatenated_Column)

You must...

You're never going to get great performance with this type of query, but it's worth checking that at least collation compatible is set to true in the properties for the...

From the perspective of the optimiser, they will have the same performance, however as the above poster said, views tend to be re-used, so different developers will tend to find...

You could just use the Generate Scripts wizard in SSMS.

Make sure you set the "Include If NOT EXISTS" option to true, then select "user defined data types", then run...

Grant Fritchey (6/30/2010)

---

Kit G (6/30/2010)

---

HowardW (6/30/2010)

---

Do you want to share the code for the function with some sample data?

It would be interesting to see if this could be converted to...

Do you want to share the code for the function with some sample data?

It would be interesting to see if this could be converted to an Inline Table Valued Function...

It will still be the Service Account User that uses the CPU in task manager, but as long as you executed the backup command as the user you set up...

Regarding restricting the CPU usage - Microsoft recommends using Resource Governor to limit the CPU used:

http://technet.microsoft.com/en-us/library/cc280384.aspx

The question is why you would want it? What's the point of a stored procedure that can execute any SQL - that's just the same as running ad-hoc SQL.

Assuming you're...

I'd purchase one of the 3rd party backup solutions - they're not very expensive in comparison to new SQL licenses.

Red Gate SQL Backup and Litespeed are both good and have...

If you purchased Software Assurance with your SQL 2008 licenses I think you can upgrade to R2 for free.

Otherwise I'm afraid you have to purchase new licenses.

Nope, the unique constraint would be violated. Trailing spaces are not included in the index B-Tree at all as far as I'm aware.

It's also worth noting that when using fixed width data types such as char and nchar, any values shorter than the maximum length will be padded with trailing spaces regardless...

Or, to simplify, you could rewrite it like below:

delete from users

where userid NOT IN (

SELECT userid FROM dbo.aspnet_users)

or

delete from users

where NOT EXISTS

(SELECT 1 FROM aspnet_users WHERE aspnet_users.userID =users.userID)