Vinay

If your index lives up to its name and is indeed unused, then no queries will be affected if you drop it. Therefore it is sufficient to use the...

OK, so modify the script accordingly and it should work.

John

Brandie

You can select the name from the list if it's remembered in there, but that isn't always the case. I think it's to do whether the account in question...

Brandie

What I do is right-click on the unmodified SSMS shortcut, choose Run as, and then enter the credentials of the account I want to connect as.

John

http://www.lmgtfy.com/?q=create+non+clustered+index

Yes, I definitely get it. So now what we need from you is the following:

(1) Table DDL for all tables involved, including indexes, constraints, triggers etc

(2) Sample data from...

OK, I think I understand. You've divided your 70 second video into 0.4 second slices, and you want to record on a graph how many times each of those...

Shamshad

What are you asking - how to populate the first table from information in the second, or vice versa, or something else?

John

Shamshad

What are you asking - how to populate the first table from information in the second, or vice versa, or something else?

John

To be honest, it's unlikely. But, looking at it from the other direction, if you intended to keep it Simple then you'd have been well advised to stop the...

Why are you doing log backups on a database that's in Simple recovery mode?

John

The best way is to create a "numbers" or "tally" table - search this site for how to do that, or you can use master.dbo.spt_values as long as you won't...

It's because when you test for NULL, you shouldn't include quotation marks, otherwise you're testing for the specific value "NULL" rather than for a null value. You need to...

Use a SQL Server Agent job, as Scott suggested. It's more flexible than a Windows scheduled task, and it's a more intuitive place to put it.

John

Of course they give you different answers - you have a different column list. Please will you supply sample data (INSERT statements), table DDL (CREATE TABLE statements) and desired...