Grumpy DBA (12/9/2008)

---

You have more control over what actually happens to the tables, indexes, etc. when you write your own maintenance jobs versus using SQL Server's Maintenance Plans. I...

There are a few problems with your datasets. First, you should never use '*' in production code - it will cause issues for you as soon as someone modifies...

When given a list of ID's that you want to search for, I would create a table to hold the ID's and use that in my query. Using a...

Integration Services is not cluster aware and was not installed in the cluster. If you have not already installed it on all nodes - you will need to get...

Why do all of those calculations when it is this simple?

Declare @subjectDate datetime;

Set @subjectDate = current_timestamp;

Select @subjectDate

,dateadd(month, datediff(month, 0, @subjectDate), 0) As FirstOfMonth

...

Okay, so you generate reporting tables and then use the reporting tables for various reports. Instead of trying to fiddle with IGNORE_DUP_KEYS on the index, I would suggest that...

Patricia Monreal (12/5/2008)This is a report I sometimes need to rerun, but I only want to collect the "PTO" data once, so I was attempting to allow the error and...

Very simple: don't.

Identities should not be reused - and, you really shouldn't care what the actual number is. If you really care about what the number is, then you...

I am not sure why the install did not place the shortcuts. Could the install have run under a different user account? And, that user account does have...

A selection in what drop-down?

You should be able to find the link in Start | Programs | SQL Server 2005. What you are looking for is SQL Server Management...

westbrook.chris (12/5/2008)

---

Ok, here's a hypothetical. What if:

a) Recovery model was set to Full

b) No database backups were ever done

c) No transaction backups were ever done

d) No activity was performed...

Just to verify - go to Start | Run and type in SqlWb.exe. If the client tools are on that system, then that should work.

If not, then you need...

There is another option to manage the SPN records. You can add the appropriate privileges to the domain account that is running SQL Server. Review the article at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;811889

Here...

You cannot run the install again to 'Add' components to a SQL Server instance. You need to go into Add/Remove and select Change. Once that starts, you will...

Agent Jobs are stored in msdb - you could try restoring that database to the new system.