Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,306 through 40,320 (of 59,072 total)

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
RE: mod 10 weights 1, 2

I don't know which will be faster nor which you prefer to read nor am I sure which is correct (I don't subtract my result from 10 like Lynn did......
--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:04 pm

#1100677
RE: mod 10 weights 1, 2

Lynn Pettis (1/7/2010)
Assuming you have a Tally table, how about the following code:
declare @ TestData varchar(12);
set @TestData = '03EA12J77';
select
(10 - (sum(
...
--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 8:45 pm

#1100673
RE: Best Practices for deploying a single database across multiple sites

The "better mousetrap" requires a "better pipe".
--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 8:11 pm

#1100666
RE: Time For A View?

jmiaebrown (1/7/2010)
Hello. I have a PROJECT_TBL that has id references to other tables. IE. resource_id for the RESOURCE_TBL, task_id for the TASK_TBL. I want to create...
--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 8:08 pm

#1100664
RE: Jr sql dba phone interview questions

ddlawal (1/7/2010)
Hi all,
I am a rookie sql jr dba preparing for a phone interview. Would appreciate any input on what kind of questions to expect.
I am as rookie as 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)

January 7, 2010 at 7:58 pm

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

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 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 7:36 pm

#1100661
RE: Four Rules for NULLs

Greg Martin-419640 (1/7/2010)
Hello and happy new year everyone.
I've looked in the thread and not managed to see an answer to this. I use SQL server.
If I have a Customers table,...
--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 7:20 pm

#1100659
RE: Four Rules for NULLs

bear in a box (6/24/2009)
...but this assumes one knows very field in the table has been allowed or not allowed nulls. this is not the case which is why the...
--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 7:11 pm

#1100657
RE: Women in Technology

Steve Jones - Editor (1/7/2010)
We'll never eliminate bias.
Heh... I found a way... I wake up hating everyone and make exceptions from there. Pork chops for everyone! 😛
--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 6:58 pm

#1100654
RE: One big "ragged right" text file!

imani_technology (1/7/2010)
Okay, but what if we weren't using a SQL Server database? What if we were using SSIS to import a text file into Vertica, for example? Or...
--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 6:51 pm

#1100652
RE: Create a new column with criteria

All that's good but I don't understand what you understand. Please read and heed the article located at the first link in my signature line below so we 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)

January 7, 2010 at 6:45 pm

#1100650

Viewing 15 posts - 40,306 through 40,320 (of 59,072 total)