Jeff Moden

Forum Replies Created

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

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
RE: Formatting Dates with 3 Character Months (SQL Spackle)

peter-757102 (1/25/2011)
Jeff Moden (1/25/2011)
WayneS (1/24/2011)
Yet another article where the discussion is as valuable as the article itself! 🙂
Well done Jeff on (yet another) great article. And well done to all...
--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 25, 2011 at 9:39 am

#1277980
RE: Formatting Dates with 3 Character Months (SQL Spackle)

nigel. (1/25/2011)
WayneS (1/24/2011)
Yet another article where the discussion is as valuable as the article itself! 🙂
Couldn't agree more. Thanks Jeff, when's the next one? 😀
Hi Nigel. Thanks 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)

January 25, 2011 at 7:16 am

#1277828
RE: Formatting Dates with 3 Character Months (SQL Spackle)

WayneS (1/24/2011)
Yet another article where the discussion is as valuable as the article itself! 🙂
Well done Jeff on (yet another) great article. And well done to all that posted enhancements.
Thank...
--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 25, 2011 at 6:53 am

#1277810

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