Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,281 through 38,295 (of 59,102 total)

RE: Use Dynamic SQL to Improve Query Performance

Just to add my two cents... I loved this article. It's well written, the code is formatted for easy readability. Topics were exposed in the correct order. ...
--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)

May 21, 2010 at 12:17 pm

#1171026
RE: Use Dynamic SQL to Improve Query Performance

shaytoder (5/20/2010)
my mistake,
for some reason i thought this approach will use seeks and not scans,
but now i tried it again, and i see scans.
sorry...:blush:
That's been the common problem throughout 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)

May 21, 2010 at 12:06 pm

#1171020
RE: Comparing two rows in one table for changes in column

Heh... just had to post back before I went to work. There's a trick that uses the difference between two different partitions used while creating ROW_NUMBER that might take...
--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)

May 21, 2010 at 8:23 am

#1170864
RE: Comparing two rows in one table for changes in column

That's exactly what I had in mind. I'll try to get to this after work tonight.
--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)

May 21, 2010 at 8:15 am

#1170858
RE: Deadlock!!!!! plz help

sanketahir1985 (5/21/2010)
it depends on amount of data
but developers have taken care of that thing ,they have used some threading concept in which it checks for thread if it is...
--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)

May 21, 2010 at 8:03 am

#1170845
RE: Crosstab Query

Thanks for the test data... I'll take a whack at it after I get home from work tonight.
--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)

May 21, 2010 at 7:49 am

#1170831
RE: Deadlock!!!!! plz help

Heh... does your stored procedure take less than 5 seconds to run? If it does, then yes, either Leo's pass-through view or my synyonm swap should do the trick...
--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)

May 21, 2010 at 12:15 am

#1170601
RE: Create temp table with from existing table adding a new column

... and, let's say you wanted COL7 to be a NOT NULL INTEGER column...
SELECT COL1, COL2, COL2 , COL4, COL5, COL6, ISNULL(CAST(0 AS INT),0) AS COL7
...
--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)

May 21, 2010 at 12:06 am

#1170599
RE: I almost posted a question today to a forum

Lowell (5/20/2010)
So I almosted posted a topic today,but as i was typing the question, putting in the sample code to demonstrate my mental block, I stopped because my own quesiton...
--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)

May 20, 2010 at 11:46 pm

#1170596
RE: Crosstab Query

BSavoie (5/20/2010)
Yea, that's what I need alright. In my situation, it looks like I would essentially create my month counters in the same way the PIVOT example creates the employeeId...
--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)

May 20, 2010 at 11:22 pm

#1170590
RE: Deadlock!!!!! plz help

Leo is spot on. Truncating a permanent table that's "in service" will always cause some sort of a problem in the future.
In SQL Server 2005 and up,...
--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)

May 20, 2010 at 11:17 pm

#1170585
RE: SQL to manipulate rows of data

Not to worry... and thanks for the feedback. 🙂
If you want to learn more about the dynamic SQL Cross Tab I used, please see the following articles. Of...
--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)

May 20, 2010 at 10:54 pm

#1170581
RE: Getting most common value from several fields into one record

Details are in the comments folks. Heh... ya wanted to get rid of "repeating code", right?
--===== Conditionally drop the test table. It makes reruns easier
...
--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)

May 20, 2010 at 10:35 pm

#1170575
RE: Getting most common value from several fields into one record

elutin (5/20/2010)
I would create aggregate CLR function for this in C#.
Cool... lets see 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)

May 20, 2010 at 8:11 pm

#1170562
RE: Which path to choose (DB Developer Vs DBA)?

Suresh Kumar-284278 (5/20/2010)
Hi All,
I am currently in a dilemma of choosing my career path. I have been doing DB Developer role (SP writing, Query Tuning etc) for the past 5...
--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)

May 20, 2010 at 8:09 pm

#1170561

Viewing 15 posts - 38,281 through 38,295 (of 59,102 total)