besides the fact it is all hidden now inside SLQ server so you got to play CSI to figure em out, they...

VM offers snapshots & Lab Manager to do this sort of stuff. We use differential backups and some nifty bak & log shipping automation to give devMonkeys & reportDonkeys what...

Reboot is a pathetic solution answer for a routine situation that is nearly 100% resolvable without a reboot. I'd rather kill random spids until the shrinkfile command magically works than...

Have you looked at what types of wait's you are getting while it is running? Or ruled out IO bottlenecks.

Usual Suspect list:

1. Bad Code

2. Worse Code

3. Bad SAN

4. Other...

IF "Column 'dri_InwardEntry.Stock_OnEntryDate' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause." THEN you probably need to use...

[code="sql-- Using tempDB

SELECT

'instance',

cast(SUM(unallocated_extent_page_count) as bigint) as 'Free Unallocated',

cast(SUM(version_store_reserved_page_count) as bigint) as 'version store resv pages',

...

SELECT A.name,(SELECT rows FROM dbo.sysindexes s WITH (NOLOCK)

WHERE s.indid < 2 AND s.id = A.ID )AS [Row count],SpaceUsedMB from

(SELECTSO.NAME,SO.ID,

CONVERT(numeric(15,2),(((CONVERT(numeric(15,2),SUM(i.reserved)) * (SELECT low

FROM master.dbo.spt_values WITH (NOLOCK) WHERE...

He wanted a way to nest his 3 Stored Procedures such that if one failed they all would be rolled back, that doen't require a 4th transaction level outside scope...

I have a few highly critical procedures that I raise a event error on if they fail and have SCOM pick up the event and alert me of the failure....

create Procedure [dbo].[custinfo]

@FromDate datetime,

@ToDate datetime,

@capital bit,

@date datetime

as

begin

Declare @temp1 table

(Code Nvarchar(255),

Name Nvarchar(255),

B1 float,

B2 float,

B3 float,

B4 float

)

IF @capital = 1

BEGIN

Insert @temp1

select Code,

Name,

b1 = dbo.fGetcustinfo (dbo.fGetcapitalreturn(C.ID ,...

create table ProcTable1

(

ProcID int identity,

ProcVal varchar(10)

)

go

ALTER procedure Proc1

as begin

begin try

begin transaction outer1

insert ProcTable1

select 'PASS1'

--

begin try

begin transaction inner1

insert ProcTable1

select 'PASS2'

commit transaction inner1

--

begin try

begin transaction inner2

insert ProcTable1

select 'PASS3xxxxxxxxx'

commit transaction inner2

end...

I am assuming you mean within SQL Server management studio (SSMS) ?

Bracket that with good backups just in case;-)

1. CREATE the new table schema

2. INSERT your data over to new schema

3. ALTER table(s) to create PK's on new schema

4. ALTER table(s) to create FK's

5. ALTER table(s) to...

Many homegrown and 3rd party products utilize SQL logins, schema, permissions, roles and rights. The good apps clean up their messes the bad ones leave that to DBA's. If you...