Viewing 15 posts - 31 through 45 (of 63 total)
Excellent ideas; we have on going efforts to document the DW and cubes. I'm certain I'll be looking into this more after the beginning of the year.
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
December 20, 2011 at 8:30 am
I’m not so sure we will see new data types, so much as adding DOMAIN to SQL Server. I didn’t know about it until reading one of Joe Celko’s...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
September 6, 2011 at 8:38 am
I would suggest an alternative piece of code in one area you are using. When checking your type 2 attributes for change, you are using a lot of “not...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
June 20, 2011 at 8:09 am
David Greenberg-358875 (6/20/2011)
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
June 20, 2011 at 7:54 am
CELKO (12/29/2010)
rdw-769613 (12/29/2010)
Another good example to use CLR is GMT/Local/Unix time handling. Trying this in T-SQL is near imposible and within CLR it's simple and faster.
I always did this by...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
January 3, 2011 at 9:12 am
In the past I reflected on the advantage of INT (IDENTITY) vs. GUID, typically deferring to the INT (IDENTITY) in my database work due to size and speed.
Now, I’m a...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
October 12, 2010 at 8:22 am
André Lozeau (10/12/2010)
fyi, Microsoft CRM (MS Dynamics) uses GUIDs as clustered primary keys for all tables, at least the way it has been implemted here
I seem to recall that SharePoint...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
October 12, 2010 at 8:07 am
I also noted the lack of a GROUP BY clause. After “assuming” that it was intended, my first thought was 8 (4 for the table, 4 for the index)....
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
August 12, 2010 at 7:40 am
You had me going there; while waiting for the forum link to respond was when I got it.
You might have had fun with a different approach: instead of no NULL,...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
April 1, 2010 at 7:37 am
As it applies to software, I think the early UNIX days work as an example. Each utility addressed a single individual problem, and did it very well. The...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
December 7, 2009 at 7:42 am
harryandrsn (12/5/2008)
...I get hugely frustrated by people who should know better...my chill out respone is "time out" and nicatine!
:ermm:
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
December 5, 2008 at 1:15 pm
For the dieting areas, might I suggest "The Zone Diet". I haven't looked closely at Atkins, but as I understand it, one of the "phases" that you go into...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
December 5, 2008 at 9:10 am
For everyone commenting on smoking: In 2007 I lost my mother and sister both to cancer or cancer treatment “after affects”. My mother had quit some years earlier but...
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
December 5, 2008 at 7:42 am
Procrastination and/or completing tasks that I start. This is mostly related to “personal” projects, things around the house, etc.
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
December 5, 2008 at 7:33 am
Is this so "out there" that no one really works with SSIS this way?
Beer's Law: Absolutum obsoletum
"if it works it's out-of-date"
November 25, 2008 at 7:23 am
Viewing 15 posts - 31 through 45 (of 63 total)