If you take a look over the query plans of either stored procedures then you will see that Eager Spool operator is used by the query optimiser in some cases,...

Just an add on, build 3152 has got the problem described here. You would need to upgrade to at least 3159.

The log file grows too large because this is the way the application is running the back-end transactions; unless you can optimise tsql, it seems you have to do the...

it was not meant to insert a wink; the statement is

alter table );

As much as I can see, you're trying to create a clustered index on a separate filegroup than the one where your table resides on. By definition, all clustered indexes...

If you say that you can run the plan manually then it can be assumed that the sql agent service is up and running. If your sql instance is SP1...

It is hard to give a short answer to your question as indexes are the core of sql server databases. You can srat with BOL, also look on internet for...

CREATE TABLE [dbo].[DDLEventLog](

[EventDate] [datetime] NOT NULL,

[UserName] [sysname] NOT NULL,

[objectName] [sysname] NOT NULL,

[CommandText] [varchar](max) NOT NULL,

[EventType] [nvarchar](100) NULL

) ON [PRIMARY]

--

create trigger [ReturnEventData]

on DATABASE

FOR

CREATE_PROCEDURE, DROP_PROCEDURE, ALTER_PROCEDURE

AS

declare @eventData XML,

@uname nvarchar(50),

@oname nvarchar(100),

@otext varchar(max),

@etype...

Install and run dbo.sp_help_revlogin on the instance you are db_owner; copy the query result in a script for the logins you want to move then ask the prod dba to...

Create an Integration Services package and schedule it to run daily/weekly, depending how often you add/remove logins. There is a "Transfer Logins Task" where you can select the logins that...

You would have to monitor your dbs access for a certain period; there is not a straight way to "select last transaction date" from a db.

What I would do: create...

You cannot restore your master from a x32 to x64, but you can use http://support.microsoft.com/kb/918992/ MS article to move your logins to the new instance (How to transfer...

Thanks all for your responses. It's a relief to know that the outage would be for a reboot only.

The new LUNs would be added as resources for the new cluster group; it's included already with the hardware design requirements. What I do not understand is if, by adding...

I may add that you cannot achieve a file shrink by running DBCC SHRINKFILE if the database is in simple recovery mode.

The recovery model of a db can be viewed/modified...