Once you have set up a full back up, make sure you have transaction log back up done at a certain interval. FTP those transaction log to the new location...

You can use CASE Statement itself.

create procedure dbo.uspProductSel

(@ProductID INT, @ProductName VARCHAR(100), Description VARCHAR(255), Price MONEY)

As

set nocount on

select Col1,Col2,Col3, from product

where ProductID = Case When len(@ProductID) =0

...

GSquared (9/2/2008)

---

I'd start by finding out what queries are slow, then find out why. More often than not, that's the problem. Run a trace if you don't know...

Thanks GilaMonster. The scary part is Locking yourself out of the DB. I will have to test this out with different scenarios.

Hi Sharon,

What you have to do or make sure of is to confirm that the TempDB Database files are not on the same drive as that of your Main DB....

Load some test data into the table. Marks idea is a good... I think I could use that.

Was the consultant talking about Transaction Log shipping to another Server? So that you can set up a Warm Stand By?

Are you trying to find out why CPU is being used by the SQL Server? Then you can start with running a profiler with filter on CPU (let us say...

Thanks for clearing up..:)

And you have a cool temper..;)

Hi matija,

UPDATE p

SET P.HourlyRate_Calc = ISNULL(w.PPRRate, hr.hourlyrate)

FROM MQDW.dbo.ETM_PayDataImport p

LEFT JOIN MQDW.dbo.ETM_PPRWages w

ON (p.personnum = w.personnum) AND (p.PeriodEndDate = w.periodenddate) AND (p.weekofyear = w.weekofyear)

This is an example of Updating the Alias....

How are you selecting the data from AS400 and importing to SQL Server? Do you need to update all columns or are you looking for certain column values. If it...

Hi Matija,

I liked the way you kept your cool. I am not sure why you say that you should not try to Update the Alias? That is ANSI Standard....

Thanks for the reply. We are using a compressed Back Up. Litespeed is compressing our 270 GIG DB to 40 Gig. We can do Object level restore from it. I...

The over load of Connection pooling happens in the Web Servers. Not the Database servers. It is the ODBC Driver that throws the error. The best practice to do is...

Another question based on WAN. What would be the effect of Connection pooling? We already have issues with Connection pooling because there are too many open connection and we are...