Viewing 15 posts - 1 through 15 (of 93 total)
This thread has been dormant for a while. Has anyone tried the Knotty Brunette at Twin Peaks? A good dark beer along the lines of Newcastle Nut Brown....
February 21, 2014 at 1:44 pm
Something else to point out:
SET @EndDate = '2013-02-13 00:00:00.000'
Midnight (00:00:00.000) is the beginning of the day, not the end. You're essentially getting data from Jan. 1st through Feb. 12th....
March 14, 2013 at 2:14 pm
You didn't indicate where you are located, but if you don't report actual hours worked, you may be opening yourself, the consulting company you work for, and the client up...
March 13, 2013 at 12:09 pm
Four years ago I was in a Data Admin group that got tired of being called to fix problems in these rogue installs. The Manager got a bright idea...
March 11, 2013 at 2:56 pm
Boy, some of you are wishin' and hopin' that all the bad in the world will go away just because you think it should be so. The purpose of...
February 27, 2013 at 11:30 am
NuNn DaddY (2/1/2013)
February 5, 2013 at 9:17 am
Back in the Dark Days of mainframes, VSAM, and JCL, a DBA was the guy getting called at 2:00am when something went poof. A DA was a Data Analyst...
January 17, 2013 at 2:31 pm
AndrewSQLDBA (1/11/2013)It is like asking users to type in the state name where they list. Most will get the spelling correct. Some will not.
And there's no way to limit what...
January 15, 2013 at 9:37 am
When I worked at The Major US Motorcycle Manufacturer the salaried employees were warned during our orientation to never leave our workstations unlocked when we stepped away. Seems that...
January 2, 2013 at 11:38 am
OP: Do you know what sentiment analysis actually is? ("Generally speaking, sentiment analysis aims to determine the attitude of a speaker or a writer with respect to some...
January 2, 2013 at 9:56 am
Maybe if they'd gone with data culottes instead...
January 2, 2013 at 8:58 am
Also, hopefully you've considered if there is any private data (names, addresses, DOBs, etc.) in the Prod database that would have to be scrubbed before landing in a potentially unsecure...
November 26, 2012 at 8:48 am
Posting the same question multiple times doesn't help you get to the right answer, it just fragments the responses you get.
You don't store dates in SQL Server formatted as anything....
October 26, 2012 at 9:06 am
Wasn't sure about the input format, especially the "-Mon-" segment. Maybe...
DECLARE @Dob TABLE (birth VARCHAR(15))
INSERT INTO @Dob
October 25, 2012 at 2:21 pm
Excellent article, and I hope it gets a lot of "eye time" across the interwebs.
But it can be a bit irritating to find the same sort of mistake a dozen...
October 18, 2012 at 9:34 am