CELKO (12/1/2011)

---

I am amazed at the dialect you got into one query! Here is how to actually write this in T-SQL using real ANSI SQL instead.

SELECT X.*

FROM (VALUES (CAST...

Of course, the other option would be to put a first step in those jobs that would check the time/date, and cause the job to abort if run during the...

If the temp table is created in the dynamic SQL command, it will only exist in that scope. That means it goes away as soon as that command finishes...

Welsh Corgi (12/1/2011)

---

There are no...

I have to admit, I too laugh at some of...

Most of the time, deadlocks can be avoided by writing code to take locks in the same sequence. If you can't ensure that, then deadlock priority low should do...

GilaMonster (12/1/2011)

---

Today's nugget of wisdom - when computer is giving all sorts of drive-related errors, first check that the sata cables are properly seated, especially if the computer has been...

You can actually change the zero date at a server-level, so test it before you count on that. Won't matter if it's being used to strip parts off of...

I guess I'm not sure exactly what you're testing here.

On a server that's not in use yet, I'd use performance stats from the server it's replacing, if there is one,...

Guras (12/1/2011)

---

I took the route of what HowardW sugested since I realized there were some notifications jobs that needed to be running.

Here is my sp

CREATE PROCEDURE [dbo].[PROC_SQLJOBS_ENABLE_DISABLE]...

Dev (12/1/2011)

---

GSquared (12/1/2011)

---

Any reason not to just turn off the SQL Agent service during that window? That'll turn off all jobs in one command. You can...

My wife and I are celebrating our 21st anniversary today. As part of that, I'm taking next week off of work (my third vacation since 1988), and probably won't...

What are the connection settings you're using when you issue the create table command?

Any reason not to just turn off the SQL Agent service during that window? That'll turn off all jobs in one command. You can turn that off and...

Because it's using an XML data type in the trigger, it has to have the correct settings for ANSI NULLs, ARITHABORT, and a few others. They're the ones applicable...