Is the storage on the same SAN - there are a lot of options that could be used from the SAN to simplify this process.

To give you an...

Unless there was a specific reason to breakout the date parts - I wouldn't do it that way:

SELECT dateadd(hour, datediff(hour, '20110101', t.create_time), '20110101') As DateHour

...

cfradenburg (5/27/2011)

---

There are select times when adding in more data than is needed and then deleting makes more sense. I had to do that one place because the query...

Welsh Corgi (5/27/2011)

---

I hope that this urgent requirement is only a homework assignment? :w00t:

What you have stated so...

It is generally more efficient to use a single query and let SQL Server do the work. However, there are times when the query or process becomes so complex...

Is this by chance running on Windows Server 2008? If so, then you need to realize (and your client) that the root of drives is more protected on this...

In addition to Gail's recommendations - another option is just to leave the size alone. If you are going to rebuild all indexes - then you need the space....

Matthew Spinks (5/26/2011)

---

I am looking after some inherited databases, and have noticed that there are automated shrinks in the overnight scripts. Now I know they are bad, and I want...

You really do not have an option for an in-place upgrade. You do have an option for an SKU Upgrade.

I would recommend the SKU Upgrade - it is quite...

I also avoid them - all it takes is a misplaced INIT command and you have just lost all of your transaction log backups.

Having a single file is no different...

You can backup directly to a network share. To do so, you have to use the UNC path instead of a drive letter. Since SQL Server is a...

Groleau+SQL (9/1/2010)

---

SELECT _________ FROM ______ AS Data

WHERE DATEPART(month, Data.The_Date_Field)

= DATEPART(month, DATEADD(month, -1, GETDATE()));

(Say, when I screw up, how do I delete my post instead...

Take a look at SQL Assistant from SoftreeTech - this is another tool much like SQL Prompt. This tool works on multiple database systems (SQL Server, Oracle, mySQL, etc...)...

When you say you cannot failover the instance - which instance are you failing over and what is the current node hosting that instance?

When I had a similar problem on...

You can read this blog: http://blogs.technet.com/b/vipulshah/archive/2006/11/30/understanding-perfmon-counters-while-troubleshooting-sql-server-performance-issues.aspx

The actual counters are: Avg Disk sec/Read and Avg Disk sec/Write (sorry - mixed them up, which I always do unless I actually open perfmon).

What...