AFAIK you cannot disable an index on SQL2000 !

syntax "alter INDEX myix ON myschema.mytable disable;" only works as of SQL2005  ...

And even if you can, DO NOT disable index id...

What are you trying to do with notification services ?

Chances are you can do it more easy and less intrusive on your server /  instance using Extended Events !

With...

I hope you also realize the downsides of using that isolation level !

Why the Query Hint NOLOCK is a bad idea

I used to use Notification services for this, but recently we had major down time due to an overload of connections and SSB-queues not getting processed on time.

We are now...

• This reply was modified 3 years, 12 months ago by Johan Bijnens.

you need a query.

If you build a view, you have no "control" over how it gets used. I mean maybe it gets joined with in queries, ...

if you build a...

Have you checked to use Extended Events to capture login information without having to bother for file sizes and queue sizes?

Have a job process the captured file(s) every x minutes

As already stated, a unique index or a unique constraint are your options

ref:...

Even when adding a new file to a filegroup, SQLServer will not balance the content of that filegroup to all files of that filegroup just like that.

If you would want...

You cannot reclaim disk space without shrinking the database, except for tempdb which is being reset to its original size after stop/start of the instance.

Alternative is to create a new...

Indeed, Jeff.

Those were the timing for the migration of the tables.

I'm still working to see if the applications actually have performance gains too.

Gut feeling says it should, but we'll only...

I prepared all filegroups and files and preallocated the needed space.

These are the results of my test on my test server ( old + slow spindles )