Start sqlprofiler for a while to captura all the load.

It shows the connection and execution settings !

You can load it into a table and analyse later on.

Indeed you have to synchronise these local windows groups (created at install time of your sqlserver instance) when you restore master or if you granted them explicit on userdbs.

yourServerName\SQLServer2005MSSQLUser$yourServerName$yourInstanceName

yourServerName\SQLServer2005SQLAgentUser$yourServerName$yourInstanceName

yourServerName\SQLServer2005MSFTEUser$yourServerName$yourInstanceName

also search your xml-execution plan for "CONVERT_IMPLICIT" . This can ruin your execution !

How about

select MS_ID, Amount

from TableA

where ms_id <> ''

Even when an order by is within the view, chances are that someone just put it in to select the view and see the data sorted like specified in the...

just to add ...

Remove the top 100 percent. Even if it doesn't hurt, it puts you on the wrong foot when you encounter it.

Even when an order by is...

- run sqlprofiler to find out what is going on.

- maybe adding an index solves this problem

- splitting to filegroups and moving a filegroup to another disk may also solve...

the article is gone ???

the link should be :

Did you read http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

1) Yes

2) How much is your total server memory per node ?

If you use AWE with SQL2000 SQLserver will grab all memory ('max server memory')...

Keep in mind identities can have gaps. Your user may not want this

You could have your user raise an alert which launches a...

- I suggest you start sqlprofiler to find out what is filling up you tempdb.

146Gb is quiet a volume for tempdb. It must be holding _all_ your data;

My guess is...

I've seen I posted an older version which doesn't take non-online-rebuildable objects into account.

This version is more suitable.

set...

e.g.

set nocount on

declare @OnlineRebuild char(1)

Set @OnlineRebuild = 'Y'

print '-- Begin ' + db_name() + '  ' + convert(varchar(25),getdate(),121) ;

Declare @SQLStmt varchar(max);

declare c1 cursor for

--print...

did you read http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=510 by Clinton Herring ?

btw

- Are you using the correct BROKER_INSTANCE when you create the route ?

CREATE

ROUTE ErrorLoggerSendRoute WITH