Viewing 15 posts - 1 through 15 (of 68 total)
Interesting article indeed.
As other commentators have noted, statistical results can be manipulated in many ways to fit the desired outcome.
I'd like to add that the 'input' side of the equation...
January 10, 2017 at 8:41 am
You need to maintain a list of what you know the value should be (i.e. ABC Movers) along with a table with all variations that are identified to be associated...
September 7, 2016 at 9:03 am
Short Answer: No.
Context; I have, in the past, moved several times. When I landed in Denver, I decided this was home.
April 5, 2016 at 12:42 pm
Good easy way to end the week (wishing it was Friday), but the query would error in all cases:
the table is created as [RPSGame], but the FROM clause references ...
March 24, 2016 at 3:30 pm
Yup. Got burned by that back in '02.
February 16, 2016 at 1:56 pm
Could? yes, of course.
Should? dunno. depends on the goal.
As for using VCS to compare the databases, I'd say it depends... We cannot because our Production database is very separate...
February 16, 2016 at 1:46 pm
Trick question indeed. Another reminder to not not answer a question while there are assumptions on the table: by stating that transaction log backups run from midnight on, there is...
February 14, 2016 at 10:20 am
I have to agree with @patricklambin: it's not really a 'nested schema', rather it's really an effed up name...
Personally, l would never add FQN delimiters to an object...
November 19, 2015 at 8:10 am
paul 25096 (11/4/2015)
November 4, 2015 at 8:06 am
I don't use bit very often, but when I do, it's NOT NULL and has a default.
Mostly, for other, general status columns, I'll use whatever's appropriate - int, tinyint, varchar(x)...
October 28, 2015 at 9:51 am
Wow. This discussion is almost as lively as the whole tabs versus spaces debate.
I've used 'Active bit not null default 1' for so many years I never thought to question...
October 28, 2015 at 9:05 am
Thanks for the example/exercise. That's really a great way to leverage existing tools (I hadn't seen Google Charts before and will keep that nugget in my toolbox too).
I've been using...
July 28, 2015 at 7:47 am
Nice exercise/example. I see one could easily work in an excel writer an/or an emauler.
For years I've been using Microsoft's uptime tool
(uptime.exe from https://www.microsoft.com/en-us/download/details.aspx?id=14732)
running from a batch file as...
July 24, 2015 at 8:59 am
Now, on top of the impending zombie apocalypse, I have to worry about the friendly random guy at ISNULL(@wherever, 'Starbucks').
Well, you're right, as usual. Laptops are stolen every...
April 15, 2015 at 8:06 am
Kindle. All 5 in one collection: $11.99. Bam! Delivered.
April 1, 2015 at 12:19 pm