Lynn,

Thanks for the reply.

Yes, I have. It shows me this line:

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as st

If I comment that...

I have not received overtime for a very, very long time while I routinely work 55 to 70 hours per week, depending.

On the up side, we receive a "premium" when...

Holy cow! Did they give you a fez to wear in the office? 😀

I'm more of a data janitor, to use Steve's idea.

I tend to clean up stuff after has gotten bad. That can be data recovery or improving performance. However, I am...

Yet another valuable lesson learned.

Gail,

I always enjoy reading your posts and blogs. It is awesome that you are so willing to share your knowledge and experience.

One of the items you noted is

Truncate table,...

Shawn Melton (7/5/2011)

---

You should see a 12288 Event ID (I believe) of packages or jobs that the SQL Server Agent is firing.

The SQL Server ERRORLOG has some system events...

Brandie Tarvin (7/5/2011)

---

Which isn't what I...

HowardW (5/4/2011)

---

There will always be an overhead of some kind. How much depends on the setup of the VM infrastructure and whether it's running on virtualisation-aware hardware or not.

There are...

SQL Reporting Services are fairly agnostic in comparison to something like SQL Server Management Studio. I mean, it connects to Oracle (providing you have Oracle's dlls on the Server) without...

Good.

Well, I...

ryan.daulton (5/2/2011)

---

Now when I start sqlserver.exe, I get the following error: 17058

initerrlog: Could not open error log file 'F:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'. Operating system error = 32(The process cannot access...

Brad,

I will echo what others have said here, the conservative approach is going to trump many time saving solutions.

Having said that, I enjoy those solutions that add something to a...

Jeffrey Williams-493691 (1/18/2011)

---

All versions of SQL Server have the capability of backing up to a UNC share. As long as the service account running SQL Server has access to...

Vertigo44 (1/18/2011)

---

So is this DR method called Mirroring? I am only wanting to create a single server in which all sql server will be sending their backups to. It sounds...