Hi,

Currently using Litespeed for backup of 1TB+ database, which compresses down to 103GB within 2hrs, which is pretty good. Depending on your RTO, this may fit or may not,...

Hey,

One issue I came up against not long ago, was extended stored procedures based on C++, which were compiled using a 32-bit compiler and this had to be re-compiled, as...

Hey,

My mistake, as this is something I do on a regular basis.

I was over generalizing and thank everyone for giving me a tilt!

Thanks,

Phillip Cox

Hi,

have a look at this link, which provides a good overview regarding replicating indexed views.

http://msdn2.microsoft.com/en-us/library/ms147873.aspx

Cheers,

Phillip Cox

As most people have already mentioned, until a year ago, I was very suspect in terms of using virtualization due to the required mental change from physical thinking to a...

hey,

Try this link:

http://www.dbazine.com/sql/sql-articles/cook10

Phillip Cox

Next time, you may want to look at a Windows site for this type of information, as this is a SQL Server site.

Here's a brief overview to your...

The long timeout is more likely to due with the NetServerEnum API, on which OLEDB depends to scan the network for SQL Server instances. One of the issues that...

Have you considered using a staging table to load data and renaming tables once ready? Also, if you are using SQL Server 2005 ENT, you may want to look...

It would also be best practice to have a regularly scheduled disaster recovery process with associated procedures to ensure everything works as expected. In addition, I would suggest you...

Hey,

Here's a starting point:

http://vyaskn.tripod.com/moving_sql_server.htm

Hi,

here's a script I have in my tool-kit, which should help you.

Thanks,

Phillip Cox

-- Potentially Useful Indexes

select d.*

, s.avg_total_user_cost

...

Hi,

First question is, why would you want to track all dimension attributes from a business\reporting perspective? Second question is, have you decided on which SCD strategy you will use,...

Where is '%DATABASEFOLDER% pointing to on attach step, as you may be pointing to original location?

On the database mirroring, as long as you are running the same edition on both ends (e.g. std to std or ent to ent), you are fine and 32-bit to...