Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,221 through 35,235 (of 59,102 total)

RE: Display More Than 8000 Characters (SQL Spackle)

Matt Whitfield (1/27/2011)
Good article Jeff, nice one.
It does surprise me, though, that it's even necessary. I mean, it's 2011...
I guess that sort of thing is why I very rarely use...
--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 27, 2011 at 10:34 am

#1279219
RE: Display More Than 8000 Characters (SQL Spackle)

nigel. (1/27/2011)
Thanks Jeff, nice article.
Spotted a minor typo in the first code example, has SliceDate instead of SliceData for the column alias.
I know it has no real effect....
--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 27, 2011 at 10:30 am

#1279218
RE: Display More Than 8000 Characters (SQL Spackle)

Koen (da-zero) (1/27/2011)
Thanks, great article Jeff.
You find uses for the Tally table everywhere, don't you 😀
Heh... you bet and thanks for the compliment, Koen.
Almost as frequently, I also find uses...
--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 27, 2011 at 10:26 am

#1279211
RE: Display More Than 8000 Characters (SQL Spackle)

chuckh 3191 (1/27/2011)
You don't have to have a Tally table made in your database. Using common table expressions, you can generate them on the fly. Here is such using 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 27, 2011 at 10:20 am

#1279208
RE: Display More Than 8000 Characters (SQL Spackle)

samir-424465 (1/26/2011)
We can use BCP utility to get the data of the table (queryout option). The contents of the file will have character field (with varchar(MAX) / nvarchar(MAX)) 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)

January 27, 2011 at 10:17 am

#1279206
RE: Display More Than 8000 Characters (SQL Spackle)

ColdCoffee (1/26/2011)
Thanks for this cute Spackle,Jeff 🙂
You bet, CC. Thanks for stopping by.
--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 27, 2011 at 10:13 am

#1279200
RE: Critique - Common SQL Server Mistakes

Grant Fritchey (1/25/2011)
Maybe use the rule of three's like you suggested for mine? I thought it was a good idea.
I'll certainly Google for it but what is the "Rule 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 26, 2011 at 7:28 pm

#1278896
RE: Delete rows older than 1 year (365 days)

Jpotucek (1/26/2011)
I am not the Developer. I take care of the Server that hosts their SQL Server Database and attempt to act as DBA for them. ...
--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 26, 2011 at 7:19 pm

#1278895
RE: Are the posted questions getting worse?

Jeff Moden (1/26/2011)
Dave Ballantyne (1/26/2011)
GilaMonster (1/26/2011)
Dave Ballantyne (1/25/2011)
Any volunteers to read through a draft of an article for me ?
Thanks....
Topic?
Loop unrolling - ie Cursor removal. Pretty high level...
--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 26, 2011 at 1:08 pm

#1278744
RE: Red-Gate SQL Compare

Grant Fritchey (1/25/2011)
Yes, you should be able to do this from the command line, I've done it before. I'll add this to a list of new articles I'm working on...
--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 26, 2011 at 1:06 pm

#1278743
RE: Maintainance plan for DataBase Autogrowth.

Minto Minto(quendans) (1/25/2011)
hi
Please don't delete things from your original post just because you've gotten an answer. 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)

January 26, 2011 at 12:51 pm

#1278734
RE: Delete rows older than 1 year (365 days)

Jpotucek (1/26/2011)
Thank you!! I changed my query to
DELETE FROM forms_holder
WHERE rec_date <= DateAdd(d,-365,GETDate())
related (I think) question. I questioned the developer as to why he wanted...
--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 26, 2011 at 12:48 pm

#1278731
RE: Are the posted questions getting worse?

Dave Ballantyne (1/26/2011)
GilaMonster (1/26/2011)
Dave Ballantyne (1/25/2011)
Any volunteers to read through a draft of an article for me ?
Thanks....
Topic?
Loop unrolling - ie Cursor removal. Pretty high level stuff.
That's one...
--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 26, 2011 at 12:34 pm

#1278721
RE: Are the posted questions getting worse?

Grant Fritchey (1/24/2011)
Jeff Moden (1/24/2011)
Grant Fritchey (1/24/2011)
Threadizens not on Twitter might not have heard the word. I just took a job with Red Gate. It's up on the blog.
Absolutely awesome....
--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 26, 2011 at 12:33 pm

#1278720
RE: Are the posted questions getting worse?

GilaMonster (1/25/2011)
GSquared (1/25/2011)
My usual estimate for that kind of thing is "less than eternity, but longer than breakfast". By that time, I usually don't care if I offend someone,...
--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 26, 2011 at 12:25 pm

#1278711

Viewing 15 posts - 35,221 through 35,235 (of 59,102 total)