Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,236 through 41,250 (of 59,102 total)

RE: How to improve performance of the view with 12 joins

I agree... The occasional properly written indexed view or Divide'n'Conquer stored procedure is frequently the only denormalization needed and it can be done quite effeciently without setting up a data...
--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)

November 8, 2009 at 5:08 pm

#1076502
RE: Are the posted questions getting worse?

Jack Corbett (11/7/2009)
Grant Fritchey (11/7/2009)
As far as the cool kids club, I snuck in the back door and I'm trying to be quiet lest anyone notice (not doing a good...
--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)

November 8, 2009 at 4:59 pm

#1076501
RE: Formatting Date Parameters

becklery (11/8/2009)
Hi, eseosaoregie.
In my opinion, maybe you can use RAQ Report to solve your problem.
As I know, it allows users to set format for data easily.
Regards,
becklery.
Heh... first Dassin, now you....
--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)

November 8, 2009 at 4:52 pm

#1076500
RE: adding column to the table

Phil Parkin (11/8/2009)
Nice solution Jeff.
Thanks, Phil. A lot of folks have asked why I haven't taken the time to learn SSIS. It's because of things like this...:-)
--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)

November 8, 2009 at 4:49 pm

#1076499
RE: adding column to the table

UnionAll (11/8/2009)
Jeff Moden (11/7/2009)
Jeff Moden (11/7/2009)
Let me ask this... does it have to be done in SSIS?
Yes, because my situation is more complex than what i have showed...
--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)

November 8, 2009 at 4:47 pm

#1076498
RE: Pivoting a one column table

As a bit of a side bar... if you're using the 32 bit version of SQL Server 2005, doing such a thing as importing a file with an unknown number...
--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)

November 7, 2009 at 10:40 pm

#1076417
RE: adding column to the table

Jeff Moden (11/7/2009)
Let me ask this... does it have to be done in SSIS? The reason I ask is because this is a trivial task in T-SQL.
Heh... see what...
--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)

November 7, 2009 at 10:14 pm

#1076415
RE: adding column to the table

Let me ask this... does it have to be done in SSIS? The reason I ask is because this is a trivial task in T-SQL.
--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)

November 7, 2009 at 9:39 pm

#1076411
RE: Pivoting a one column table

I agree... some readily consumable sample data and a CREATE TABLE statement would be nice.
--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)

November 7, 2009 at 9:01 pm

#1076407
RE: How to improve performance of the view with 12 joins

rshm35 (11/6/2009)
Hi,
I have a view which selects the data with 12 joins in it...
can you give me suggestions how can i optimize this view....
Thanks
Yes...
--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)

November 7, 2009 at 8:55 pm

#1076406
RE: Looping through a directory for sub-directories' names

Thanks, Paul.
--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)

November 7, 2009 at 8:54 pm

#1076405
RE: Training for those new to SQL

Ken McKelvey (11/6/2009)
designing applications and databases is an art which requires experience
Heh... would someone please tell that to the folks that I've worked for? 😀 The term "GUI...
--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)

November 7, 2009 at 8:32 pm

#1076403
RE: Pivoting 1 column table

Double post... no discussion here, please. Keep it all together at the following URL... thanks.
http://www.sqlservercentral.com/Forums/Topic815495-338-1.aspx
--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)

November 7, 2009 at 8:30 pm

#1076402
RE: Pivoting a one column table

See the following articles and keep in mind that the MAX of a single row will always be the value of that row.;-)
http://www.sqlservercentral.com/articles/T-SQL/63681/
http://www.sqlservercentral.com/articles/Crosstab/65048/
--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)

November 7, 2009 at 8:25 pm

#1076401
RE: Comparison Between LinQ and NHibernate

Heh... I can't speak of Linq because I've not had to clean up any messes from it, yet, but Hibernate and NHibernate are both 4 letter words to me. ...
--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)

November 7, 2009 at 8:20 pm

#1076399

Viewing 15 posts - 41,236 through 41,250 (of 59,102 total)