Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,321 through 40,335 (of 59,098 total)

RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

mohd.nizamuddin (1/8/2010)
Excellent article.
BTW I have another version of CTE, which splits delimited string without tally table. I think it works efficiently, also. Please have a look...:-)
Thanks for the feedback, Mohd.
Several...
--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)

January 9, 2010 at 9:40 am

#1101396
RE: Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays

jamesburkill-1146441 (1/8/2010)
In SQL Server 2008 you most certainly CAN parse a table variable as a parameter. When used in conjunction with visual studio 2008 you can even parse 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)

January 9, 2010 at 9:35 am

#1101395
RE: Are the posted questions getting worse?

GilaMonster (1/9/2010)
Great, now I'm getting Twitter messages (along with the PMs and mails) "Please answer this forum thread"
Heh... that's why I've not gone there. I get a lot 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)

January 9, 2010 at 8:29 am

#1101379
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

Thanks for the tip, Peter. That's one thing I never really paid attention to.
--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)

January 9, 2010 at 7:47 am

#1101373
RE: Rebuild Index Task fails

Ali_SQLDBA (1/9/2010)
42.04962GB --LDF
46Gb --Total
4.41632GB-- MDF
Actually, we dont take any log backups. All we do is daily full backups. Also, the recovery model is Full. I know everything is smelling weird....
--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)

January 9, 2010 at 7:43 am

#1101372
RE: Rebuild Index Task fails

Ali_SQLDBA (1/9/2010)
Please advice Immediately.
Thanks
Ali
As a bit of a friendly tip, Ali... I know it's just a difference in languages but the words you used combined with the extreme brevity...
--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)

January 9, 2010 at 7:36 am

#1101371
RE: Running total , missing date , NULL in amount, exception handling

I can't be sure because I was actually there to see everything happen, but it probably has to do with the number of reads before and after tuning. Queries...
--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)

January 9, 2010 at 7:29 am

#1101369
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

Peter Brinkhaus (1/8/2010)
I just downloaded the latest version of BOL 2005 (november 2008). The text didn't change. The topic 'sp_executesql (Transact-SQL)' is annotated as follows: Updated: 5 December 2005. So...
--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)

January 8, 2010 at 11:17 pm

#1101309
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

Heh... wouldn't be the first time MS documentation is, ummm... "misleading". Guess I need to do some digging and find out if VARCHAR(MAX) is implicitly convertable before I bad...
--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)

January 8, 2010 at 10:23 am

#1101046
RE: Execution of DISTINCT Clause

mohd.nizamuddin (1/7/2010)
Thanks for your responses.
But my problem is not the getting data (output) efficiently, rather I want to know that when I was using DISTINCT clause along with COALESCE, 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)

January 8, 2010 at 9:47 am

#1101008
RE: Jr sql dba phone interview questions

ddlawal (1/8/2010)
Been in IT for awhile. Never felt so fullfilled since I took on dba role.
Being a hard worker, I love the challenge and the constant trying to better...
--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)

January 8, 2010 at 9:42 am

#1100999
RE: Hitting nVarchar(max) limitation when running exec sp_executesql

shannonjk (1/7/2010)
Jeff Moden (1/7/2010)
Only if it's a constant... in 2k5, it'll take any variable datatype that's implicitly convertable to NText and that includes VARCHAR.
Jeff can you show an example 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)

January 7, 2010 at 11:09 pm

#1100706
RE: Jr sql dba phone interview questions

Heh... it WAS a pointer! Seriously... why do you want to be a DBA?
--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)

January 7, 2010 at 11:03 pm

#1100703
RE: Date function help!

Code-1029433 (1/7/2010)
I need to set a date variable that will capture the 25th day of the previous month, and I'm having a hard time figuring out how to write 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)

January 7, 2010 at 9:22 pm

#1100680
RE: mod 10 weights 1, 2

Never mind, Lynn... I see why you're subtracting from 10... I did a validation of a full number and you're calculating the check digit.
Modification of my code will change 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)

January 7, 2010 at 9:09 pm

#1100678

Viewing 15 posts - 40,321 through 40,335 (of 59,098 total)