Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,076 through 36,090 (of 59,099 total)

RE: Recursion counting problem. Not your usual issue

CELKO (11/12/2010)
Giving you recursive kludges for an adjacency list is not really helping you. [font="Arial Black"]You are not learning how to think in RDBMS and sets.[/font]
8. To convert an...
--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 14, 2010 at 8:34 pm

#1250504
RE: Data Loading Performance issues

Heh... OK... Now I get to pry the shoe out of my mouth. :blush: It looks like TF 610 does, in fact, help with converting fully logged inserts...
--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 14, 2010 at 7:47 pm

#1250500
RE: Data Loading Performance issues

I haven't looked at the article yet but BOL states that minimal logging will only work on a table with a clustered index if and only if the table starts...
--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 14, 2010 at 7:27 pm

#1250499
RE: Do I need more free space on drive for tempdb?

Once you get TempDB moved, do your self a couple of favors. First, set the initial size to 12GB (in your case based on the numbers you posted) ...
--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 14, 2010 at 7:20 pm

#1250498
RE: Delete old rows from all tables in a database

{S-H-I-V-E-R} Yowch. Deleting data. I'll parition it... I'll save it in an archive or log table. I'll export it and back it up. I do...
--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 14, 2010 at 6:35 pm

#1250496
RE: Setting a pre-allocated size for a database that already exists

{edit} Never mind...
--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 14, 2010 at 5:46 pm

#1250491
RE: Alternative To Cursors?

sqldba_icon (11/13/2010)
sure. where can i find the details?
Google? Books Online? I'm not trying to be a smart guy here... that's where I'd look.
--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 14, 2010 at 5:44 pm

#1250489
RE: 2 questions... first x > '' vs x <> ''

As a side bar, I already have 4 state logic... on, off, don't know, and don't care. That 4th state is data that I leave out of the database...
--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 14, 2010 at 5:37 pm

#1250487
RE: Pivot Query Question

Ok... here we go. First, since you're new to T-SQL, you might want to read up on the following articles so you can do this on your own in...
--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 14, 2010 at 4:58 pm

#1250484
RE: Pivot Query Question

joshtheflame (11/14/2010)
Sachin great work 🙂 just need four things and it will be perfect cause i am trying to change but it has error...not good with sql though.
1. I've lost...
--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 14, 2010 at 4:02 pm

#1250478
RE: dec to hex

Paul White NZ (11/14/2010)
sturner (11/11/2010)
actually there is such a builtin function: master.sys.fn_varbintohexsubstring()
I believe it will work fine for you... you would first cast your integer or decimal data to varbinary...
--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 14, 2010 at 1:36 pm

#1250464
RE: Week Part

Michael Valentine Jones (11/12/2010)
End of Week Function available on this link:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=64760
Michael... please double check me but I believe a documentation change is necessary for that code. Here's what I...
--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 14, 2010 at 8:00 am

#1250428
RE: 2 questions... first x > '' vs x <> ''

Jeff Moden (11/12/2010)
CELKO (11/9/2010)
Do not use the old dialect != from C and Sybase.
I've been trying to get people out of the habit of using != but they're just 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)

November 13, 2010 at 7:07 pm

#1250398
RE: Searching for Plans

Hey Bob! Man, I've gotta tell you it was a real pleasure to finally meet you in person. Thanks for the drink and the pork chops! 😀
--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 13, 2010 at 6:48 pm

#1250397
RE: Are the posted questions getting worse?

ALZDBA (11/12/2010)
Jeff Moden
It has been a pleasure meeting you at sqlpass, as well as meeting Grant, Steve, Andy and other renowned names at SSC.
Thank you for sharing...
--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 13, 2010 at 6:44 pm

#1250396

Viewing 15 posts - 36,076 through 36,090 (of 59,099 total)