Viewing 15 posts - 4,141 through 4,155 (of 6,026 total)
I would love a job where I could spend half my time behind the computer and the other half outdoors in the field, traveling and getting my hands dirty. Perhaps...
February 16, 2015 at 6:51 am
david.gugg (2/13/2015)
February 13, 2015 at 9:01 am
It sounds like in your case the users are actually working for external clients, so unfortunately you're in a position where both you and your managers have to tread lightly....
February 13, 2015 at 8:56 am
Any job that involves ingesting data feeds or managing databases for a number of different external clients can be a pain in the asscii. When an internal user submits a...
February 13, 2015 at 8:33 am
I'm sure our current employers probably benefit from scripts we may have written in our previous jobs. When a company hires a senior level developer or DBA, those of us...
February 13, 2015 at 8:21 am
Gary Varga (2/13/2015)
Brian J. Parker (2/12/2015)
Steve Jones - SSC Editor (2/12/2015)
Brian J. Parker (2/12/2015)
February 13, 2015 at 7:12 am
Brian J. Parker (2/12/2015)
Steve Jones - SSC Editor (2/12/2015)
Brian J. Parker (2/12/2015)
February 12, 2015 at 2:46 pm
Jeff Moden (2/12/2015)
February 12, 2015 at 1:38 pm
jchapman (2/12/2015)
February 12, 2015 at 11:55 am
jchapman (2/12/2015)
Ah... an idealist in the group. 😉
Well, it's good to hold on to our ideals... but we must also carry a big stick. First try to educate and...
February 12, 2015 at 11:38 am
It's odd that the developers would be writing SQL involving complex sub-queries in a data warehouse. Perhaps it's not a star-schema or they're not familar with the data model.If you...
February 12, 2015 at 10:08 am
Assuming there is only one DBA, and you're now it (perhaps the last one left unexpectedly), then taking an inventory of your IT environment is important, but perhaps not the...
February 12, 2015 at 9:24 am
Changing the ordinal position of columns in the ORDER BY clause can cause a change in the execution plan. If the ordinal position matches an index, then it can leverage...
February 11, 2015 at 3:20 pm
The order of columns in the insert does not matter to the optimizer or engine. Also the order of columns in the SELECT, WHERE, and JOIN do not matter.
First,...
February 11, 2015 at 9:15 am
If by deploying often we mean more iterative and incremental deployments, then that can also result in safer deployments, because changes within each release are fewer and more manageable. It's...
February 11, 2015 at 8:07 am
Viewing 15 posts - 4,141 through 4,155 (of 6,026 total)