Viewing 15 posts - 391 through 405 (of 1,221 total)
pshore73 (1/26/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 3, 2015 at 2:11 pm
Some stuff that I've seen:
--USA zip codes stored as integers
--USA social security numbers stored as integers
--Date/time stored as strings (those were A LOT of fun to deal with)
--When told that...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
February 3, 2015 at 9:51 am
Jeff Moden (1/21/2015)
Wayne West (1/21/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 22, 2015 at 2:53 pm
I hate to ask this, but is your canned system running an application server? At a prior job we had one that required no stored procedures in the database....
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 21, 2015 at 3:51 pm
Andrew..Peterson (1/16/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 20, 2015 at 3:56 pm
ShineBoy (1/18/2015)
Such a common thing to do I generally have an input parameter in the proc @debug bit = 0 and that...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 19, 2015 at 8:50 am
Eugene Elutin (1/14/2015)
...modern boxes for SQL Server keeping also have LED screens and in-built heating element for hot-fixes...
Heating elements! Is THAT why I've been having problems applying hot fixes?!...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 14, 2015 at 8:28 am
I had no backup problems with our 1.something TB ERP database as a single file backup until our network admin decided that We Must Use Microsoft Backup and I stopped...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 9, 2015 at 9:12 am
ccd3000 (1/8/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 9, 2015 at 8:48 am
I've never been a fan of clouds, too many news stories like this one talking about outages: botched upgrades, misconfigurations, etc. At least this time Verizon is announcing it...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 8, 2015 at 8:22 am
ShineBoy (1/7/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 7, 2015 at 3:59 pm
Markus (12/29/2014)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 7, 2015 at 2:14 pm
It's always interesting, starting out like that and learning new things. Access is a good tool and I use it a lot as my front-end to talk to SQL...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 7, 2015 at 11:21 am
Yet Another DBA (1/7/2015)
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
January 7, 2015 at 10:27 am
DrKiller (12/23/2014)
wow what a complex way of doing it.I'm usually just doing this 🙂
DECLARE @tmpString VARCHAR(MAX)SELECT @tmpString = COALESCE(@tmpString + ', ' + productname, productname) FROM Header
SELECT @tmpString
Six years ago...
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
December 30, 2014 at 2:17 pm
Viewing 15 posts - 391 through 405 (of 1,221 total)