I didn't take the time originally to examine your table structure, but if you were to re-arrange the order of the key columns in your primary key to put wh_id...

Edit: Just found duplicate post here. Please don't post duplicates. I wouldn't have wasted my time answering if I had seen an answer already.

Can you better define...

Duplicate post. Please post answers here

Have you looked at the transfer database task?

Since your columns are defined as non-unicode then when you provide unicode values to the where clause SQL Server has to do an implicit conversion which is likely forcing scans...

Michael has given you probably the only option because once you have given rights to database objects to a login then that login can access the those objects from any...

Something like this will generate the sql you would need to execute:

DECLARE @sql NVARCHAR(MAX)

SET @sql = 'select '

SELECT

@sql = @sql + C.[name] + ' From ' + T.[name] + '...

There is no way to tell you what is the best because it varies by the situation. Certainly backing up daily and having transaction log backups are good. ...

I'm sure the issue was that he set up database mail, but did not configure SQL Server Agent to use database mail. It is a common mistake to forget...

You need to look into using the matrix control which allows you to Pivot/Cross tab the data.

This looks like the code you found is for Oracle.

There is not a way that I know of to do what this trigger does because this looks like...

Instead of doing new trace and then save as a template have you you tried using File -> Templates -> New Template? I was able to create a template...

Yusuf,

There really isn't much you can do about it with the Date type. You can make it a string type, but then you lose the calendar control. Your only...

We had short debate about this in planning for SQLSaturday #21 - Orlando. One of the sponsors wanted to have some time to do a demo of one of...

Apparently I agree with Gus and Gianluca.