Jeff Moden

Forum Replies Created

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

RE: Scalability and performance?

The only thing that remains if for you guys to tell us a fool proof way to find a good local tuner. 😉
--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 7:27 pm

#1069731
RE: .fmt and Bulk Insert importing Bad Data

Also, the book is right... change everything in the format file to SQLSCHAR and ad more column width... anything that's an INT should be set to at least 10, 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)

October 22, 2009 at 7:24 pm

#1069728
RE: .fmt and Bulk Insert importing Bad Data

I'd recommend that you take another look at Books Online for how to skip columns. You can't just skip them by leaving them out no matter where they are...
--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 7:22 pm

#1069727
RE: Concatenating Rows

I see it's your first post on SSC... Welcome aboard!
Again, as with many of the other posts, that does the whole table. If that's what you want, then you're...
--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 7:13 pm

#1069724
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

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