Jason-181907 (9/21/2009)

---

For those that use "simple" recovery model, when it comes to backups, does it matter if you are doing full backups or simply backing up the .mdf/.ldf files? ...

Are both instances running SQL Server 2008?

You are never going to be able to rebuild that index - because it is not an index. It is a HEAP (Index ID: 0).

If you need to reorganize...

scott.lothert (9/17/2009)

---

That's a great point Jeff ! I will make that correction.

Both query plans actually are using Index Seeks, the Unicode is doing a clusterd Seek. My bad for...

Review the article I link to in my signature - Gail does a very good job of explaining how to manage transaction logs.

What you are seeing is normal and expected...

Unless I'm missing something, you have a column defined as varchar - and you are passing in nvarchar data types. If you view the execution plans, I would bet...

And the solution was?

You would add that code inside the SUM, for example:

SUM(CASE WHEN...) AS ...

But, I would recommend using COALESCE and NULLIF instead of the CASE WHEN construct - so you would...

You have to run the service pack on all nodes in the cluster to upgrade the non-cluster aware services that exist on each node. For example, SSRS/SSIS will not...

Use sp_rename to change the name, but be careful to identify the permissions on the procedure before you recreate it. Dropping and creating stored procedures removes the permissions and...

Yes you can, but you need to install SQL Server 2000 first (and apply all service packs/patches), then you can install SQL Server 2008 as the default instance. If...

Well, that depends - if you are running on x86 hardware,...

Yes, you can probably assume that. SQL Server 2000 Standard Edition could not use more than 2GB of memory, regardles of how much was available on the server.

SQL Server...

Trooper,

Also be aware of the fact that breaking the log chain has potential issues that could be disastrous to your company. Here is an example:

Full backup at 1am yesterday

Transaction...

As a wish list - I would ask for two systems (clustered) running Windows Server 2008 x64 - 64GB RAM and 4 hex core processors to host SQL Server 2005/2008.

I...