Viewing 15 posts - 91 through 105 (of 257 total)
David.Poole (7/19/2016)
This situation destroys trust between IT and business people. The question "Why don't you know how to alter the system you wrote?" Is a hard one to answer.
The...
July 19, 2016 at 7:31 am
Beatrix Kiddo (7/18/2016)
JustMarie (7/18/2016)
However my boss's boss has a thing about 'butts in seats' and likes to see his people busily typing away and talking on phones.
This kind of attitude...
July 18, 2016 at 10:05 am
Rod at work (7/18/2016)
I've been wearing earbuds constantly in an effort to try and drown out the distracting noise. Now my hearing is beginning to suffer.
Try switching to sound canceling...
July 18, 2016 at 10:02 am
I'm a developer, not a DBA, but figured I would chime in with my thoughts on WFH.
My team (as it were) is geographically diverse. We use Lync/Skype for IM and...
July 18, 2016 at 7:47 am
jasona.work (7/12/2016)
Yet another wonder tool (so far only an academic project) to...
July 12, 2016 at 9:18 am
Look into the OnError Event Handler. I believe it has the variables you're looking for when it comes to verbose error messages.
I use that event handler all over my ETL...
July 7, 2016 at 9:54 am
What collation are you using?
June 27, 2016 at 8:29 am
Sometimes I just let bad code go.
I'm dealing with legacy stuff that has beauties such as varchar(1) - at least it's not nvarchar(1) - and varchar(max) for text values of...
June 27, 2016 at 8:27 am
Drew points out that the CASE statement allows for more than 2 conditions which is a good thing to have in place for future expansion.
I also believe that SQL evaluates...
June 27, 2016 at 8:19 am
Ed Wagner (6/20/2016)
JustMarie (6/20/2016)
Michael L John (6/16/2016)
Integer division was taught within the first three weeks of my first programming class in my first semester...
June 20, 2016 at 10:00 am
Yes it is 2 packages. My process is done in bite size steps. I could have probably combined them in this case since I put in a constraint with an...
June 20, 2016 at 8:35 am
Michael L John (6/16/2016)
I'm sorry, this post infuriates me.Integer division was taught within the first three weeks of my first programming class in my first semester of school.
To...
June 20, 2016 at 8:24 am
Check your query to make sure you're really only returning one row.
Check your parameter to confirm it's set to data type varchar or nvarchar.
Check your result set to see that...
June 20, 2016 at 8:04 am
Correct. Sequence containers are great for this kind of thing. It keeps your code steps together and you can create a control flow as needed.
June 14, 2016 at 12:21 pm
I have a generic parameter table that I use to store anything that I need to check later (what parameters were used for the last run) or manually entered ones....
June 14, 2016 at 12:20 pm
Viewing 15 posts - 91 through 105 (of 257 total)