Eugene Elutin (4/5/2012)

---

Is it 4th Jan...

"where createDate > 2012-04-02" becomes the integer 2006, "where createDate > 2006" and the 2006 gets cast to datetime as 1905-06-30 00:00:00.000, so it's the same as "where createDate >...

When you push the button, do you shout "Say hello to my little friend!" in a really bad Tony Montana accent with a background of synthesized new wave, electronic music?

Jeff Moden (3/26/2012)

---

Michael Valentine Jones (3/26/2012)

---

Here is an alternate method that I use to generate the pseudo random numbers. The basic method is to take the right 7 bytes...

dwain.c (3/26/2012)

---

Jeff,

The following thought occurred to me last night but I didn't get a chance to test it until this morning.

Isn't the modulo function designed to always return a positive...

Here is an alternate method that I use to generate the pseudo random numbers. The basic method is to take the right 7 bytes from the NEWID function and...

The "normal" practice is to not run applications on the same server with a SQL Server.

TravisDBA (3/9/2012)

...Being scared, or not wanting to spend the money is more of an excuse nowadays than it is a reason to not upgrade. Come on, jump on in, the...

We have about 130 instances of SQL 2000 and even a couple of SQL 7.0.

Hardware isn't much of an issue, almost all are on VM's.

As long as it runs, I...

Row version isolation will usually prevent deadlocks between readers and writers or updaters.

I have sucessfully used it for this on a number of systems, and can't say that I have...

Weeks usually have 7 days.

Do you have some special meaning for the number of days in a week?

Elliott Whitlow (3/1/2012)

...

Also since maintenance plan jobs carry the owner of the person who saved the plan last I have a job that runs hourly and sets the owner of...

This shows how to find the first and last day of the week for a given date, with the week starting on Sunday and ending on Saturday. You can...

Create a Developer role in each database and grant it the necessary permissions.

Then add the developers to that role in each database they need access to.

Idera Diagnostic Manager has a nice dashboard for viewing multiple servers, and can collect information all the time, not just when you look at it.

It works with all the versions...