It worked for 10.375 but not for 10.377.

It is because this statement

DecimalPart % (1.0 / Number) = 0.0

is never true

I tried making the tally table 10,000 but it still...

http://www.youtube.com/watch?v=cIVfrBFc5og

In my experience you can't get away with it that easy. I have never had a sales person accept the first no. But if you know that your...

imho it is a service, not rudeness, to the caller to say no thanks and hang up. they are looking for sales and if you know you are not buying...

Okay, I admit it, you got me too!

Good one!

Or you could create the user type -

CREATE TYPE [dbo].[HVCIDdt]

FROM bigint NOT NULL ;

I was in the military too before becoming a DBA and I too volunteered for extra things and never regretted it.

The ones that don't try anything new never get to...

I think I solved this mystery after using the tip of checking the auto shrink setting.

The vendor had a 'smart' re-index script that did a rebuild of the fragmented indexes...

I checked the maintenance plans and didn't see a shrink on any of them.

Good call, I checked and there were two that were set to auto-shrink.

I set the auto-shrink flag to false on those so now I'll wait and see if one of...

Thanks, I would have guessed so but I'm grasping at straws at this point so it seemed worth asking.

Back to the drawing board . . .

Very timely since this topic came up just this week - thanks!

We had one vendor for a major application hard code the SA password in the application instead of creating correct security via a special user id/role etc.

The DBA team didn't...

I had downloaded and tested the Quest tool too but I still like using PowerShell overall because it does not depend on a third party tool.

There are a lot of...

I can't argue that SQLPing does a more exhaustive search and returns more results than the approach used in this article.

I was using it on an IP range so it...