Old and...

@jchapman ,

Have you already started on this?  I'm asking because I see some red flags in some of the posts above but don't want to waste my time advising if...

Hi,

We have log backup job running daily 5 times. One time run is taking 4-5 times longer than the other runs daily. The backup size is same for all...

The best way to do this is monthly partitioning using either Partitioned TABLE or Partitioned VIEW technology.  Not intending to sound the part of an iconoclast ,...

I've found that changing datatypes in a Tally function really isn't necessary but that's a personal observation.  Implicit conversions usually work just fine here. I've not personally ever run into...

Thanks, Jonathan.

A long time ago, it used to make quite a difference performance wise.  Not so much on singleton big stuff like so many people test with but on the...

Thanks, Scott.  I appreciate it.

WHY did you delete your original post?  That's not very friendly.

A book that addresses real issues is "Weapons of Math Destruction", by Cathy O'Neil.  She talks about how AI algorithms build in unfair behavior, and usually in a way...

My first action would be to have someone check the CPU and I/O on the given application server.  Then, check the code.

Hello and thanks for the response (for some reason I am not getting notifys).

I had another think and tried varous new ways to construct a search in Google and...

The only way to do this with 100% accuracy is if there is an odometer reading present.

Is there an odometer reading in the data?

And, yeah... I agree with Zidar... I...

Either that or the user is a part of an AD User Group that has been...

Just to confirm what happened here and according to the other thread on a similar subject, it's because someone designed the table with numeric dates as Jeremy pointed out in...

patrick chan, while Phil's answer is totally correct, if you are an absolute beginner, his reply might be too complicated for you to understand (you should take efforts to...