Clean pages aren't moved to disk. The only pages that are written back to disk are dirty pages, so the lazy writes/sec measures the total number of pages per sec...

dan-572483 (12/9/2013)

---

Security may be a factor as this was a new drive created because the old drive used for SQL log files was no longer large enough. But...

declare FindFragment cursor for

SELECT object_id, '['+name+']' FROM #IndexFrag WHERE (avg_fragmentation_In_Percent > 5) and (avg_fragmentation_In_Percent < 40) and (name not like 'null')

Or don't spend time re-inventing the wheel and use http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

It won't.

Please read through this: http://www.sqlservercentral.com/articles/Administration/64582/

I stand by what I said earlier. Sounds like some process is logging in every couple of days and updating the table to old values. Check logs, set up a...

What are the definitions of the two tables?

A rollback could not cause that unless you had a transaction open since November (and if you had, you'd have known by now due to the blocking and the tran...

Why? Unless you're dropping and recreating tables, the object id and column id will remain the same. They don't change at random times for no reason. If you're frequently dropping...

Code please (and maybe use people's names not their forum status?)

SQL won't skip lines in a procedure so there's something odd going on, possibly stuff failing silently.

Columns are uniquely identified by the combination of object_id (for the table) and column_id. They don't have a single unique ID of their own.

The only time a table's object_ID can...

Igor's not the OP.

Tina, any chance you could post the definitions of the procedure having the problem? Also, consider putting PRINT statements or using RAISERROR to raise informational messages to...

To restore master you need to take the server down, restart it in single user mode, restore then restart again. Running scripts to create logins requires no downtime at all....

Igor just said there is a try-catch construct...

I generally recommend not restoring master from one server to another. Script the logins, server-level roles and permissions and linked servers and apply on the new server.

Jeff Moden (12/8/2013)

---

Since the files that I'd be rebuilding the Clustered Index on would not have any modifications or new inserts in progress, it might just work if I apply...