Yes.

if the guy doesn't want to give your the download credentials just ask the guy to download it for you and put it in a share someplace in the network.

You are facing a capacity planning issue.

Just in case, what's your timeout setup for the offending environment?

1- Script offending database creation

2- Take a full backup

3- Drop your offending database

4- Delete mdf, ndf and ldf related datafiles.

5- Alter database creation script setting -perhaps - 2 Gig for...

You said FACT table therefore you are talking about a Data Warehouse environment.

You do not use a natural PK on Data Warehouse, by using surrogate keys you are doing the...

please post the result of...

SELECT count(*)

FROM Database.dbo.trace

WHERE textdata like '%UpdateAccount%'

As a quick workaround you can always add a WAITFOR DELAY command in your loop, that would free resources for other sessions to use in each iteration of your WHILE...

Yes.

Yes, providing you implement the right partitioning strategy.

Partitioning strategy should target at least one...

You are not telling how you are doing it right now so it's kind of hard to suggest something better.

Lets go to the basics.

LOGINS...

... belong to the instance therefore if...

I see... you didn't even...

100% support Jeffrey.

By the way, I'm wondering of what kind your fourth index is......

This is a text book example of what you may expect to happen when people tries to pack the application's logic into triggers.

Application's logic should be on the application side.

... and the question is?

:w00t: May be is because of the bottle of Brandy but believe me I couldn't figure it out what are you looking for... I'll check back when I back to...

Here is a reason...

Picture this scenario, you work in...