Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,271 through 51,285 (of 59,102 total)

RE: Getting my seudo code to T-SQL - Need some help

Actually, you need to go back and review Kent's response... it's pretty much spot on.
--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)

April 6, 2008 at 7:21 pm

#798894
RE: Performance: Every nth item

What is the Primary Key of the table called "Test"?
--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)

April 6, 2008 at 7:10 pm

#798893
RE: Is this query posible in Sql Server 2005 ?

It is possible in a view if you create a column called "TableName". Look at how they do it with the Information_Schema views... particularly the Information_Schema.Columns view.
--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)

April 6, 2008 at 9:53 am

#798869
RE: No XP, but Look Forward To 7

Gates should give everyone who bought Vista a free copy of XP to install whilst we all wait for a decent version of Windows (7?) to come out in 2009....
--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)

April 6, 2008 at 9:36 am

#798868
RE: Update Query for multiple rows based on Multiple Criteria

Since it worked fine for both Matt and I, I've got to ask... are you actually using SQL Server or are you using some other RDBMS?
--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)

April 6, 2008 at 9:32 am

#798866
RE: Very large facttable

jos.haemers (4/6/2008)
Jeff,
I've posted a CREATE script for the facttable with a few records. I can't post any queries because there an no queries yet. In the future the customer wants...
--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)

April 6, 2008 at 9:30 am

#798865
RE: What kind of DBA are you?

Heh... and I thought I was old... 😉
--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)

April 6, 2008 at 9:20 am

#798863
RE: Is anybody knowing How to Improve performance in Stored procedure using cashe memory

Rather than "warming the cache"... try analyzing the code to see where indexes would help you solve the problem.
--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)

April 5, 2008 at 11:07 am

#798799
RE: Getting my seudo code to T-SQL - Need some help

As previously stated, Cursor and loops of this nature WILL kill any hopes of performance...
Your pseudo code said...
-- IF TotalPrice > 0 ...sqlCodeHere
What do you want to do for...
--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)

April 5, 2008 at 11:03 am

#798798
RE: Update Query for multiple rows based on Multiple Criteria

Something is very wrong here... the original query posted by the OP works just fine.
--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)

April 5, 2008 at 11:00 am

#798797
RE: Very large facttable

You might want to post the CREATE statement for your fact table and maybe 10 or so rows of data (see the URL in my signature line for the right...
--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)

April 5, 2008 at 10:55 am

#798796
RE: How to split cells in table format?

Not enough info... will you always have a max of 2 items. Also, it may make a difference if we knew why you wanted to do 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)

April 5, 2008 at 10:53 am

#798795
RE: What kind of DBA are you?

Heh... funny thing is, I'm "old school" as well and I always say "S-Q-L" instead of "sequal".
As you said, doesn't matter how I hear it.
--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)

April 5, 2008 at 7:44 am

#798777
RE: How to update the Created Date on a table in SQL 2005 ?

Wow! I totally missed the fact that the object of the update was a system table.
Updating the system tables directly is "Death by SQL". Don't do it... period.
--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)

April 5, 2008 at 7:42 am

#798776
RE: Stripping out double quotes (") in bulk insert

Outstanding! Thank you for the feedback!
--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)

April 5, 2008 at 7:40 am

#798774

Viewing 15 posts - 51,271 through 51,285 (of 59,102 total)