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...

You can do:

EXEC tempdb.dbo.sp_spaceused #MyTempTable

I suppose once you have the size of the temp table you could estimate how many rows would add up to your size cutoff. The...

Gopinath

Thanks for the question, which demonstrated a useful point. Please accept my criticisms in the spirt of constructive feedback which, of course, you are free to ignore if you...

You've still got that unnecessary WHILE loop in there.

Even if you insist on keeping the loop, the #resultSET table isn't needed - you can just do this:

SELECT

@filter = @filter +...

Well, the alternative is to calculate...