Let us know how that PR works out, George.  I've got a bunch of places where I found errors, need better examples, or is missing information.  I've frequently been seriously...

I still concern myself with such things because it doesn't make sense to use something that's known to be slower when there's something easy you can do to avoid the...

I have to strongly disagree...

As a bit of a sidebar, Sergiy posted while I was working on mine.  That's about the same kind of simplicity that I built into mine because you can, as...

Thought I'd toss my hat into the ring.  Details are where they should be... in the code. 😀  It also tolerates leading, embedded, and trailing spaces, which is a frequent...

• This reply was modified 5 years ago by Jeff Moden. Reason: Added a couple more important notes

There are several methods for doing this.  Steve Collins has correctly identified what most people identify as the "Best Method" and it frequently is.

There are 3 methods that I'll try...

Please see the following article for calculating durations.  It's really simple to do when you understand the hidden powers of the DATETIME datatype.  Heh... you may never use DATEDIFF() to...

It's an amazing thing... I've been working with SQL Server since before SQL Server 7 came out and it just dawned on me that I've never tried to alter a...

In my sql server instance I renamed 'sa' account and disabled. I confirmed no sa account.  I configured server side audit log and I can see some sa activities....

Hi Pete,

This is interesting.  I've never seen such a thing before.  The reason for my question is I'm looking for something else that might be causing this problem for you. ...

Does 'tablename' in the errors you're getting match the tablename in the ALTER TABLE statement?

Hi

Accidental DBA here

We have an application that runs a select * on a table upon starting the application. There are 2.4 million rows in the table. Today it was...

BWAAAA-HAAAA-HAAA!!!   Great title... and that's exactly what I'm doing! 😀

HI Jeff,

I apricate your wanting to know I did not want to bother you with it, but I would like to get the SSIS  to work. As I said...

Crud... I went to hit QUOTE and, instead, hit REPORT by mistake.  My apologies, Joe.  I'll contact the webmaster and let them know.