Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,621 through 37,635 (of 59,072 total)

RE: Report with 52 Weeks (A year) of data as columns

Pre-aggregation is essential to such reports. Please see the following articles...
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
Yes, you can use a Matrix to do similar... if there's not too much data to clog the pipe...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 3:31 pm

#1194398
RE: Expire rather than Delete records in a table

Here's a pretty good link that explains SCD's quite nicely....
http://en.wikipedia.org/wiki/Slowly_changing_dimension
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 3:19 pm

#1194390
RE: Expire rather than Delete records in a table

When I need to use the "future expire" method, I use 9999-12-31 for the future date. As a side bar, I prefer the "future expire" method when start and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 3:14 pm

#1194387
RE: SUBSTRING coding problem

Kingston Dhasian (7/16/2010)
Try this
DECLARE @strVariable VARCHAR(100)
SET @strVariable = 'J:\SQL 2008 Database Backups\High School Baseball\HighSchoolBaseball_Full.bak'
SELECTSUBSTRING( @strVariable, 1, LEN( @strVariable ) - CHARINDEX( '\', REVERSE( @strVariable ) ) )
Here i have used...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 3:00 pm

#1194377
RE: Are the posted questions getting worse?

Paul White NZ (7/16/2010)
Jeff Moden (7/16/2010)
...using IDENTITY in combination with some table and index hints, have been able to resolve the ones I haven't be able to avoid (guaranteed multi-row...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 2:36 pm

#1194360
RE: Help with using mulitple replace in a function

I'll try to remember it on Monday, then, Julie. Thanks for your patience.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 1:42 pm

#1194336
RE: SQL DBA to BI Developer Role

Outstanding. Thanks for your time, Steve! It'll help everyone that happens to read this thread.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 1:28 pm

#1194332
RE: Performance on Views that span databases on multiple servers

CirquedeSQLeil (7/15/2010)
My 2 bits on Vendor support of their databases.
That's a load of crap. Vendors should support their database despite other databases being present. I know they pull...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 1:26 pm

#1194331
RE: Multi-parent heirarchy query

Joe Celko (7/16/2010)
The nodes (parts) are in one table and the tree structure (blueprint) is in another. The (lft, rgt) pairs are the primary in a BOM tree so...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 1:21 pm

#1194323
RE: Help with using mulitple replace in a function

Julie Breutzmann (7/16/2010)
I've modified Lowell's function and performed a time-comparison test. Ihaven't thoroughly tested the function, since if it's too slow it won't be useful anyway. I used and input...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 1:13 pm

#1194320
RE: Calendar Tables

Now [font="Arial Black"]there's [/font]an idea for an article... comparing the pros and cons of using a DateTime dates compared to INT dates.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 12:56 pm

#1194308
RE: Becoming a business intelligence architect

da-zero (7/14/2010)
Jeff Moden (7/13/2010)
Have you got a link for all of the requirements, Steve? Thanks.
:blink:
I think I have an URL where you can download experience. If I can find...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 12:43 pm

#1194295
RE: Are the posted questions getting worse?

Gianluca Sartori (7/16/2010)
Paul White NZ (7/15/2010)
Jeff Moden (7/15/2010)
Can you good folks give me an example of when IDENTITY will not work?
When you need a sequence across several tables
When you need...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 16, 2010 at 12:35 pm

#1194291
RE: Multi-parent heirarchy query

CirquedeSQLeil (7/15/2010)
Joe Celko (7/15/2010)
Talking about multiple parents in a Hierarchy makes no seine by definition.
Full on agree with that.
Maybe for a hierarchy but have you ever seen a BOM?...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 15, 2010 at 5:23 pm

#1193833
RE: How to Increase Query Speed by 3 Orders of Magnitude with no Indexes

gary.strange-1058508 (7/15/2010)
This is a forum, inviting users to express their opinion.
I would consider using cut & paste to repeat your comment along the thread contributes nothing of substance.
Perhaps my...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 15, 2010 at 2:11 pm

#1193770

Viewing 15 posts - 37,621 through 37,635 (of 59,072 total)