Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,826 through 36,840 (of 59,072 total)

RE: increment string in vchar column

a.borgeld (9/13/2010)
I need the output in *.csv but i can concatenate the output.
Good idea to, i tried something else with a loop, come back on it today.
Thanks guys.
BCP can 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)

September 14, 2010 at 7:04 am

#1220641
RE: LEFT OUTER JOIN IN TEMPORARY TABLE

sanmatrix (9/14/2010)
Well the result is right. Just give a closure look. Look at the first row in the result 2, 1537, null. 2, 1537 is from otpresent. There is no...
--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)

September 14, 2010 at 7:00 am

#1220639
RE: Changing from INSERT INTO...SELECT (with a UNION) to SELECT INTO

Agreed. SELECT DISTINCT usually indicates that more than 1 of the exact same row was created. That usually means the join criteria was NOT sufficient or the design...
--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)

September 14, 2010 at 6:58 am

#1220635
RE: help me

steveb. (9/14/2010)
what sort of maintainence plan are you trying to create?
I wonder if that matters here. It errors on the first step of the wizard according to 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)

September 14, 2010 at 6:45 am

#1220629
RE: Are the posted questions getting worse?

Alvin Ramard (9/13/2010)
Speaking of the Bit datatype, here's an old one for you:
"There are 10 types of people in the world. Those that understand binary, and those who don'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)

September 14, 2010 at 6:36 am

#1220627
RE: XML "CSV" Splitter

Dave Ballantyne (9/13/2010)
---- EDIT bum steer
Heh... "Mad cow"? 😀
--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)

September 13, 2010 at 11:23 pm

#1220447
RE: XML "CSV" Splitter

TheSQLGuru (9/13/2010)
Can I ask why everyone is putting their code inside a UDF? Can't the code just be inlined as necessary?
Actually, the testing I'm doing works against both methods...
--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)

September 13, 2010 at 11:18 pm

#1220445
RE: XML "CSV" Splitter

Brad Schulz (9/13/2010)
Hi Jeff...
Just wanted to quickly respond... I've been busy all day (mostly writing my T-SQL Tuesday Blog Post).
Regarding the plethora of CROSS APPLYs in my code for 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)

September 13, 2010 at 11:16 pm

#1220444
RE: Blocking on tempdb system tables

sporoy (9/13/2010)
What I'm trying to figure out is if the blocking unavoidable in these circumtances? Should I contact with SCOM support? This does not look as SQL's fault..
It's not SCOM's...
--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)

September 13, 2010 at 10:28 pm

#1220433
RE: Are the posted questions getting worse?

Heh... since Steve shut it down (probably a very good thing), I guess I'm a "bit" too late to make any further suggestions. I do have to admit 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)

September 13, 2010 at 10:25 pm

#1220431
RE: Are the posted questions getting worse?

GilaMonster (9/13/2010)
Hey Jeff. Please join the club of people that clearly don't know what a BIT column is. How dare you say that the working code is not working! :-D...
--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)

September 13, 2010 at 10:13 pm

#1220429
RE: Unexpected Columns being set to NULL with record updates

d_s_man (9/13/2010)
Im new to Partitioning so excuse my ignorance.
From what I can see these are real partitions. There is a file for each partition with partition function and range defined.
As...
--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)

September 13, 2010 at 12:14 pm

#1220240
RE: Searching for Plans

Eric Russell 13013 (9/13/2010)
Jeff Moden (9/12/2010)
The "best plan" is dictated only by four things and only two of those really matter where performance is concerned...
4. Code - This is...
--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)

September 13, 2010 at 12:06 pm

#1220232
RE: Blocking on tempdb system tables

I absolutely agree with the above. You should just about never include a temp table in a transaction especially (but not limited to) the creation of a temp 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)

September 13, 2010 at 12:01 pm

#1220227
RE: SQL SERVER 2000 DataType

Lennie (9/12/2010)
Hi Good Guys, :w00t:
I have found the solution to my non Stored Procedure or TRansactSQL SQL String. It working now on the VBNET2008 Form and 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)

September 13, 2010 at 11:43 am

#1220216

Viewing 15 posts - 36,826 through 36,840 (of 59,072 total)