Viewing 15 posts - 1 through 15 (of 152 total)
Very good advice!
The available jobs are in a pyramid, the highest paying jobs are at the top of the pyramid. But, as one goes up a pyramid, there are...
September 10, 2016 at 5:36 pm
Most errors I run into are due to one or more of the following:
Failure to make use of affordable data-quality defense-in-depth
approaches. Data value constraints were never defined or...
June 2, 2011 at 12:50 pm
Part of every calculation code deliverable should be another program that independently calculates key subtotals and totals.
The second program can be a set of sql scripts with instructions to fill...
June 2, 2011 at 11:57 am
The poor quality of reading comprehension skills in our population is scary.
Part of the reason is that people are not taught critical thinking skills.
Part of it is that...
January 28, 2011 at 2:51 pm
I've lost track of how many times I've seen documentation like this:
Step 1: Do blah...
Step 2: Do blah...blah...
Step N: Do blah...blah...blah...
Important! Before doing step 1, ...
That's a basic mistake...
January 28, 2011 at 2:45 pm
Steve Jones - SSC Editor (1/20/2011)
January 28, 2011 at 1:11 pm
Yes, the table has a clustered index.
This morning, I created a table with no indexes and got what I expected, an index=0 record for the table. I created...
January 13, 2011 at 5:58 am
Keith Langmead (12/9/2010)
... I think the biggest problem is that no one has really decided what "The Cloud" is.
Keith Langmead (12/9/2010)
In the olden days, computers were very expensive so one company...
December 15, 2010 at 10:13 am
Yo! Original Poster! Listen Up!
GilaMonster has REPEATEDLY told you to avoid the approach you are so avidly accepting.
Go back and re-read his comments and links about alternative ways...
December 13, 2010 at 12:20 pm
As you said, this appears to be a problem. Wouldn't it issue this correlated subquery once per row retrieved?
inner join ConfigArchive CA2 on CA2.NodeID = CA1.NodeID and CA2.ConfigID...
December 13, 2010 at 11:37 am
Here's a simple way.
Create a local temp table with an identity column called sort_id, plus all the columns you want in your output query.
Use dynamic sql to populate the temp...
December 13, 2010 at 11:07 am
It generally helps when you include the error messages you are getting for a given input...
Put this in front of EXEC (@tsql):
Inspect what it prints and try to run...
December 13, 2010 at 10:44 am
I use extended properties extensively in my own work as a developer.
I am loath to use them on other developer's work as a dba.
That's because when a script gets run...
December 3, 2010 at 4:38 pm
I can get the DPM files across the wire (I already am, actually).
But that doesn't turn it automagically into a database that is ready to go as soon as I...
December 3, 2010 at 12:52 pm
Steve, your analogy about the Mission Impossible vs the Mystery Men teams was a good attempt, but it fails in one seriously important aspect.
Even the Mystery Men team "got...
November 3, 2010 at 9:05 am