What is the extension you put in the maintenance cleanup task? Do you have two tasks created, one for your full backups and another for your transaction log backups?

Two tricks are available, but limited since you are still on 2000. If you upgrade to 2005 - these 'tricks' are very easy to implement.

First trick is to create...

It really doesn't matter what name you use - they have a lot of problems. ...

Yes - change the inner joins to outer joins, example:

LEFT JOIN tableName b ON b.KeyName = a.KeyName AND b.ValueName = 'SurName'

LEFT JOIN tableName c ON c.KeyName = a.KeyName AND c.ValueName...

I don't think IF statements are related to performance at all. Using IF statements is flow control - not processing so there really isn't anything that would cause a...

You are going to have to join to your table multiple times - once for each value.

SELECT a.KeyName

,a.Value As DisplayName

...

What are the defined workflows for the specified audience? In other words, how is your web application going to be used by specific groups of users?

How you test depends...

When I see a backup file that is larger than the database, the first thing I think is that the backup file has more than one backup in it. ...

If you want to install a new instance into a cluster, you are going to need dedicated resources for that instance. The instance is going to need it's own...

Run the SQL Server Configuration Manager - this will show you all the SQL related services running on the machine.

ps (7/29/2009)

---

Timothy Ford (7/29/2009)

---

I suggest backing up directly to the location you plan on copying the files to. Is that not an option? You should be able to...

Since you don't need the database in full recovery model, I would change the recovery model to simple, then shrink the log file. If you don't change the recovery...

TAman (7/29/2009)

---

Okay, I understand how your code is working now. But your sample data is not like my sample data. My data doesn't always have 6 characters. ...

TAman (7/29/2009)

---

I'm not sure what you are representing when you say "stuff"("stuff"

And what does the '00000' represent?

Select *

,stuff(stuff(right('00000' + cast(TimeValue...

Assuming that your times are what you have shown, the following should work:

Use tempdb;

Go

If object_id('tempdb..#test') Is Not Null

Drop Table #test;

Go

Create Table #test (TimeValue bigint);

Go

Insert Into #test...