Viewing 15 posts - 1 through 15 (of 39 total)
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...
April 29, 2014 at 9:40 am
April 15, 2014 at 10:53 am
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...
April 15, 2014 at 6:37 am
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...
April 15, 2014 at 5:48 am
Okay, I admit it, you got me too!
April 1, 2014 at 6:16 am
Or you could create the user type -
CREATE TYPE [dbo].[HVCIDdt]
FROM bigint NOT NULL ;
March 24, 2014 at 6:24 am
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...
January 16, 2014 at 6:58 am
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...
January 24, 2012 at 8:15 am
I checked the maintenance plans and didn't see a shrink on any of them.
January 23, 2012 at 6:15 am
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...
January 23, 2012 at 6:09 am
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 . . .
January 20, 2012 at 9:16 am
Very timely since this topic came up just this week - thanks!
December 9, 2011 at 7:03 am
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...
May 4, 2011 at 11:15 am
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...
April 19, 2011 at 11:12 am
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...
April 19, 2011 at 10:31 am