http://msdn.microsoft.com/en-us/library/ms175835%28v=sql.90%29.aspx This should help

I would recommend purchase a copy of the developer edition, costs around $50 and has the same features as the Enterprise edition, just it can only be used for development...

Can you attach the execution plan for the procedure, there might be something obivous in the plan.

As a side note, have all statistics and indexes been checked for being up...

Thanks for the DDL but it is not syntactically correct.

There are misssing columns from table1 (PCount), you are not specifiying enough columns in the union for the results table.

But from...

Another one would be to use Systems Center Orchestrator with the TFS Integration Pack.

http://www.microsoft.com/en-us/server-cloud/system-center/default.aspx

http://orchestrator.codeplex.com/wikipage?title=Integration%20Pack%20for%20Microsoft%20Team%20Foundation%20Server%202010

Use windows task scheduler would act as the alternative to the SQL Agent.

Then you can use SQLCMD, Powershell etc to write a script which will do the backup.

Yep. I'm an admin and it doesnt work for me in VS2008

Managing Transaction Logs - By Gail[/url]

Stairway to Transaction Log Management[/url]

Accidental DBA Guide - Read Chapter 8[/url]

And also remember to change the order of the columns in the foreign key to match the new primary key order. (Just in case anyone finds this in the...

Space will not release once it has been consumed, this is due to the expensive procedure of allocating more space to files.

If it grew to 5GB it will stay at...

Thanks Lynn, have tested in Dev and Test for the column change order and it does indeed now seek on the index instead of scan, for the particular query.

From the...

As Gail mentioned, figure out what is causing the log file to grow, otherwise if it happens again you will be in the same boat.

Something wanted the log file to...

add more space to the drive

or

restart SQL

DECLARE @Account TABLE (AccountNo INT, Name VARCHAR(100))

INSERT INTO @Account VALUES

(60000000,'Mrs Rayford Hufflepuff18'),

(60000001,'Miss Forest Hufflepuff18'),

(60000061,'Miss Bex Ignore'),

(60000068,'Mr Jason Twirl'),

(60000088,'Mrs Katuta Sunger'),

(60000111,'Mrs Corene Ravenclaw19'),

(60000112,'Miss Reta Ravenclaw19'),

(60000132,'Miss Aubrey Ravenclaw19'),

(60000137,'Mr Millicent Ravenclaw19'),

(60000207,'Brigadier Hannah Decorationbextest'),

(60000220,'Professor...

You need to group by in the sub select as your using an aggregate function

SELECT

(

CASE

WHEN (GROUPING([MAT]) = 1) THEN

'Tot'

ELSE

[MAT]

END

) AS MAT,

[myNUmber]

FROM

(

SELECT DISTINCT

CASE

WHEN LEFT (TZZ, 2) = '1D'

OR LEFT (TZZ, 2)...