Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,431 through 41,445 (of 59,098 total)

RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Thanks, David. Coming from someone with your background, that's a great compliment.
--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)

October 22, 2009 at 6:56 pm

#1069720
RE: Finding difference of cumulative values in a table

rekha_sara (10/21/2009)
Mark,Sanoj..
Thank you!! The O/p is exactly what I wanted..But the problem is in reality, I'm dealing with more than 400,000 records and the query is going on more...
--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)

October 22, 2009 at 6:25 am

#1069344
RE: TSQL Question about getting data

Brad Allison (10/22/2009)
Jeff, wondering if you were still able to help with this. I have had a busy couple of days, but I will be revisiting this project...
--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)

October 22, 2009 at 5:59 am

#1069326
RE: splitting long sentence into multiple lines

Did it help?
--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)

October 21, 2009 at 6:56 pm

#1069217
RE: Return Daily Values

Thanks! 🙂
--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)

October 21, 2009 at 6:46 pm

#1069215
RE: Date Range Parameters (between)

freezea (10/11/2009)
Hi, mbrady5.
Maybe you can have a try of RAQ Report[/url]. I think you can realize what you want with it.
Is that you Dassin? Are you still spamming RAQ...
--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)

October 21, 2009 at 6:13 pm

#1069209
RE: Comma separated Value

Ivanna Noh (10/11/2009)
Thanks for the additional 'speed tricks' Jeff... 🙂
Btw - how does the performance of the 'FOR XML' method of extraction compare with other methods?
Also, the last line 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)

October 21, 2009 at 6:06 pm

#1069206
RE: alternative for backup/restore for seperate Reporting DB

repent_kog_is_near (10/20/2009)
Jeff
Just thought about it.. we may have to throw in or remove some indexes into the reporting DB.. that essentially rules out the DB Snapshot/Mirror and Shared Database, doesn't...
--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)

October 21, 2009 at 5:49 pm

#1069199
RE: Are the posted questions getting worse?

Steve Jones - Editor (10/21/2009)
Database Pork Chops
---------------------
4 large chops, bone-in
cayenne pepper
flour
sharp knife
trebuchet
With the knife, sharpen the end of the bones until they achieve a dangerous point.
Liberally coat the chops with...
--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)

October 21, 2009 at 5:16 pm

#1069190
RE: What table design is better ?

My recommendation would be to GOOGLE "Slowly Changing Dimension Type 2" and find the WikiPedia article on these two (and more) options. I do it like ALZDBA does above...
--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)

October 21, 2009 at 7:13 am

#1068837
RE: optimize queries

alopeze (10/20/2009)
Hi Jeff, thanks a lot...
Now that you are talking something about the WLAN, when i execute this query in the local server the time is 1 second, but when...
--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)

October 21, 2009 at 12:29 am

#1068682
RE: Loop, Cursor or maybe something else?

Apologies... I modified my previous post because I misread the file data.
Let us know when you get the data loaded (several methods for that have already been offered) with a...
--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)

October 21, 2009 at 12:21 am

#1068679
RE: table variable not reseting

lcsgeek (10/20/2009)
You're exactly correct witht the identity values not resetting. I've modified the nested loop using one of Dinakar Nethi's techniquies
Here is the final code that works if anyone...
--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)

October 21, 2009 at 12:11 am

#1068674
RE: table variable not reseting

Maybe I'm not looking at this problem hard enough, but I don't see the reason for a loop at all. This should be done using set based code.
--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)

October 20, 2009 at 10:46 pm

#1068665
RE: Test the performance of my database

a2zwd (10/20/2009)
Hi pals,
We have installed new server(W2K8 and sql 2008).
The database has many tables and millions of rows.
How can I check the performance whether I can...
--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)

October 20, 2009 at 10:43 pm

#1068664

Viewing 15 posts - 41,431 through 41,445 (of 59,098 total)