Do you have autogrowth turned on? If so, how much do you increase your log by?

It is impossible to answer definitively without more information.

If I were to hazard a few guesses.

1. You may be reading and writing to tables in different schemas. Qualify your...

Off the top of my head, I monitor:

Blocking above a time threshold

hanging spids

failed jobs

disk space

File sizes/free space

deadlocks

best practice (i.e. indexes created on correct filegroup, etc)

This seems to work:

Declare @var Varchar(10)

SET @Var = null

SELECT

LEFT(USER_NAME(o.uid),10) AS Schema_Owner

, LEFT(OBJECT_NAME(i.id),50) AS TableName

, i.rowcnt Row_Count

, CONVERT(numeric(15,2),(((CONVERT(numeric(15,2), i.reserved)) * 8192 / 1024.0))) AS Reserved_Size_KB

, CONVERT(numeric(15,2),(((CONVERT(numeric(15,2), i.used)) * 8192 / 1024.0)))...

You set the priority of a job to an extent using Maximum Degree of Paralellism. If you want the refresh job to take a lower priority you can reduce the...

There are a couple of options that spring to mind:

You could use UNPIVOT to return one column to count on and 1 column to filter on.

Another option is you could...

Updating this active thread.

An even easier solution:

Two Tables, let's call them MyTableA and MyTableB

You also have a view called MyTable.

Consumers of the data read from the view, MyTable, which points...

An even easier solution:

Two Tables, let's call them MyTableA and MyTableB

You also have a view called MyTable.

Consumers of the data read from the view, MyTable, which points to the...

My guess is your view has a hardcoded null.

This is an odd quirk in SQL Server where a NULL, which is not a value and therefore probably sholdn't have...

The first run is a 'worst case' run. As has already been mentioned, your proc is being compiled. Your data also has to be loaded into the buffer. Physical I/O...

LOL Thankfully...

Thank you, everyone, for the eye-opening research. You guys have contributed some caveats to consider when trying to identify the best solution.

Steve's lead-in was a bit misleading in that...

Yeah, I deliberately left that bit out because it had been covered...

Actually, rereading the thread, I see that Peso did post the size of his dataset; 2,000,000 rows.

It would be interesting to determine a relative cut off point where the row_number...

jcraddock (3/11/2009)

---

These are all well and good, but I rarely need such results in a T-SQL window. Where I need them is in an application where I want to...