Viewing 15 posts - 5,941 through 5,955 (of 6,041 total)
charles.gildawie (8/20/2010)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2010 at 9:53 am
The article does present a good educational example on the use of CTEs and the RANK function. However, I don't think ranking is the most practical and efficient solution to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 20, 2010 at 8:38 am
A little off topic maybe, but below is a possible technique to hash demographic or personally identifying data for a QA or Development environment. The distribution of the data remains...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 12, 2010 at 9:33 am
The [Services].[ID] column is part of your PK, and you havn't made it clear why you need to insert the table while leaving that column NULL. From what I see,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 11, 2010 at 11:09 am
When I am developing a stored procedure for reporting purposes, something that is driven by one or more sets of parameters, the parameters are typically contained in a table. I'll...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 11, 2010 at 9:10 am
Jeff Moden (8/10/2010)
For all of you good folks using XML to split things... I suppose that XML either does something special for you or that your consider its performance...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
August 10, 2010 at 7:41 am
I'm surprised by some of the strong emotions expressed here regarding the issue of doughnuts and bagles. You sound like a Dilbert cartoon and are reenforcing negative stereotypes about those...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 30, 2010 at 1:26 pm
thisisfutile (6/30/2010)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 30, 2010 at 9:17 am
I once had a consulting gig at a .com company that managed to (barely) survive the dotcom bust but employed a skeleton crew of about 40 employees, which was a...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 29, 2010 at 4:07 pm
niall.baird (6/23/2010)
I like to see a comment block/change register at the top of each stored proc/function, something like
/* ************************************
Name: pu_mytable
Purpose: Updates dbo.MyTable with values from...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 24, 2010 at 3:47 pm
Steve Cullen (6/22/2010)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 22, 2010 at 1:52 pm
I don't think it should be considered a technical best practice to either use or not use schemas; I think it mostly just an extension of one's overall naming convention,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 22, 2010 at 9:19 am
Any thoughts about how to comment a block of T-SQL ?
I do this often, but over time I havn't been consistent with it.
/* begin: What I'm doing here...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 21, 2010 at 11:20 am
Here is how I would format the same SQL. I like all lowercase and indent my joins, which makes it easier to read when there are four or more joins.
select
...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 18, 2010 at 3:15 pm
ken.trock (6/18/2010)
Also, I think it's important to capitalize keywords too. Something handy for that is using highlight the keyword you want to upper case and use Ctrl+Shift+u. Back to one...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 18, 2010 at 12:14 pm
Viewing 15 posts - 5,941 through 5,955 (of 6,041 total)