Jeff Moden

Forum Replies Created

Viewing 15 posts - 30,676 through 30,690 (of 59,101 total)

RE: Triangle Join - Can I do it right or a replacement?

Example: Table ProductSummary
Columns: Date, Product, Vendor, Total
Rule: One row per day at maximum.
So, one row per date per product per vendor, correct?
And you want running totals by day and not...
--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)

March 20, 2012 at 6:00 pm

#1461981
RE: Appalling performance of CLR SqlBulkCopy

I guess my suggestion would be to dump the CLR altogether and do the data layer calculations in the data layer.
--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)

March 20, 2012 at 5:47 pm

#1461977
RE: extract data from excel using ssis

wendy elizabeth (3/14/2012)
I receive daily excel 2003 workbooks from my company's main customer to load into a sql server 2008 database r2 standard edition. Right now I am manually copying...
--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)

March 20, 2012 at 5:42 pm

#1461975
RE: Triangle Join - Can I do it right or a replacement?

codebyo (3/20/2012)
Jeff Moden (3/20/2012)
Actually the ExampleTable is very close to the final table because it's meant to be a "result table" with only a few calculations for BI reports. There...
--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)

March 20, 2012 at 5:26 pm

#1461968
RE: Triangle Join - Can I do it right or a replacement?

codebyo (3/20/2012)
SQLKnowItAll (3/20/2012)
Why not put your derived table into a CTE as well? Or a temp table? It doesn't address the triangluar join yet, but that's the first thing I...
--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)

March 20, 2012 at 4:53 pm

#1461955
RE: Triangle Join - Can I do it right or a replacement?

SQLKnowItAll (3/20/2012)
ColdCoffee (3/20/2012)
I dont see a triangular join here. Its pretty straight forward join. Or maybe im overlooking something here :blink:
Triangular join because the join condition is >=
Also, look at...
--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)

March 20, 2012 at 4:45 pm

#1461951
RE: Attracting Talent

GSquared (3/20/2012)
The stories about interviewees who have "10 years SQL Server" on their resume and don't know what an index is, also go around and create a bigger impression than...
--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)

March 20, 2012 at 4:37 pm

#1461944
RE: Unexpected table grow .

michael wang-201906 (3/20/2012)
the data source is on DB2, which i don't want to modify, that's why i download them to SQL by SSIS.
thank you everyone, i will try to create...
--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)

March 20, 2012 at 10:24 am

#1461760
RE: best book for sql server

mahesh.shiv (3/20/2012)
I would like to know about this book 'MS SQL Server 2008 Professional Programming' by Robert Vieira .
Considering the way this thread has been going, let me first say,...
--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)

March 20, 2012 at 10:22 am

#1461758
RE: combining tables

Just a tip. The two jears worth of employee data probably shouldn't be in separate tables to begin with. Understanding that it may not be possible to actually...
--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)

March 20, 2012 at 9:22 am

#1461702
RE: Unexpected table grow .

michael wang-201906 (3/20/2012)
Hi, everyone:
i met a very wierd problem this morning. i have a SSIS package, which clean a table, then run a SP to insert records to this table....
--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)

March 20, 2012 at 9:14 am

#1461697
RE: BCP out slow first time, fast after. Help!

Eugene Bereznuk (3/20/2012)
I have to BCP this table "out" and then "in" to another table (which, normally, is faster than INSERT..SELECT..).
If the target table can be dropped before being...
--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)

March 20, 2012 at 7:00 am

#1461582
RE: Transpose Row into columns

I personally never use PIVOT because I don't like it the way they wrote it (PIVOT in Access is much easier and more more powerful) and it's comparatively slow.
The following...
--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)

March 20, 2012 at 6:53 am

#1461580
RE: Set based approach to 'pivoting' rows into columns

The following two articles will teach you how to handle just about any situation. For character based columns, use MAX instead of SUM.
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/T-SQL/63681/
--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)

March 20, 2012 at 6:47 am

#1461575
RE: Fetch table name,size

Thought I'd throw my own version of sp_SpaceUsed out there. Undoubtably, this will need to be updated some time in the near future but it works just fine in...
--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)

March 20, 2012 at 6:44 am

#1461574

Viewing 15 posts - 30,676 through 30,690 (of 59,101 total)