Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,316 through 42,330 (of 59,102 total)

RE: differiniate quotes as data vs quotes as column identifier

Is the "wholerow" text stored as VARCHAR(8000) or VARCHAR(MAX)? If it's VARCHAR(MAX), does it need to be? Since VARCHAR(MAX) is inherently "out of row" (or whatever you want...
--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)

August 14, 2009 at 2:28 pm

#1039706
RE: Syntax for altering all databases?

Bob's method eliminates the use of a cursor. If you need to "productionalize" something like that, we can do a little XML concatenation into a variable using his good...
--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)

August 14, 2009 at 2:14 pm

#1039697
RE: How to delete huge amount of data

gah (8/14/2009)
Plase excuse my ignorance, but how much is a "crore"?
does one "crore" represent ten million (10,000,000) ?
gah
From WikiPedia.com...
A crore (Hindi: ?????) (often abbreviated cr) is a unit in...
--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)

August 14, 2009 at 1:40 pm

#1039669
RE: Syntax for altering all databases?

For quick and dirty stuff like that, GOOGLE the undocumented sp_MSForEachDB extended stored procedure. It's got a nasty cursor in it but it is convenient for this type 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)

August 14, 2009 at 1:30 pm

#1039658
RE: differiniate quotes as data vs quotes as column identifier

Heh... yeah, I forgot about that. Add TOP 2000000000 to the SELECT in the CTE. Don't use TOP 100%... although I haven't had the time to verify 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)

August 14, 2009 at 1:17 pm

#1039651
RE: Are the posted questions getting worse?

GilaMonster (8/14/2009)
I called this evening to ask if there were any known problems, because I've been having intermittent problems since yesterday morning. Help desk replied that there were no issues...
--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)

August 14, 2009 at 1:12 pm

#1039645
RE: Issue with assigning candidates to a review list

RBarryYoung (8/14/2009)
Jeff Moden (8/14/2009)
RBarryYoung (8/11/2009)
WayneS (8/11/2009)
...
BTW, I think Jeff calls it the "pseudo-cursor". Isn't it Phil that calls it the "quirky update"?
Nah, that's me. Jeff hates the term "pseudo-cursor"...
--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)

August 14, 2009 at 11:07 am

#1039565
RE: Issue with assigning candidates to a review list

RBarryYoung (8/14/2009)
Wayne: Any chance we could get some Create Table defs & sample data Inserts?
See Paul's post... it's the same stuff as before (I think).
--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)

August 14, 2009 at 11:05 am

#1039563
RE: Issue with assigning candidates to a review list

RBarryYoung (8/11/2009)
WayneS (8/11/2009)
...
BTW, I think Jeff calls it the "pseudo-cursor". Isn't it Phil that calls it the "quirky update"?
Nah, that's me. Jeff hates the term "pseudo-cursor" and much prefer'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)

August 14, 2009 at 10:41 am

#1039541
RE: Transfering content of a string variable to a file in a SP

Ah.... my bad, Nigel. More coffee please. :blush: I was thinking of the returns from some commands. Thank you for the catch.
Still, 8191 can be a...
--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)

August 14, 2009 at 10:19 am

#1039515
RE: Transfering content of a string variable to a file in a SP

Command lines are limited by the system to only 255 characters and I don't know if they can actually be of the NVARCHAR data type (never tried it). Obviously, VARCHAR(MAX)...
--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)

August 14, 2009 at 9:18 am

#1039447
RE: 'Add' to a character.

Lowell (8/14/2009)
you cannot reuse the numbers if there are gaps...at least not easily.
I'd like to add to that.... there is no reason to "fill in the gaps". If a...
--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)

August 14, 2009 at 9:13 am

#1039444
RE: Getting away from a lookup table, how?

josh.d.kelly (8/13/2009)
I am a web developer trying to become a better database designer. I have been reading about keeping away from lookup tables.
Do you have a URL where you've been...
--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)

August 14, 2009 at 12:44 am

#1039167
RE: differiniate quotes as data vs quotes as column identifier

Do what the comments in the following state and try it again. Let me know if it helped...
;WITH
cteSplit AS
(
SELECT s.RowNum,
Element = ROW_NUMBER() OVER (PARTITION 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)

August 14, 2009 at 12:21 am

#1039164
RE: SQLServerCentral Editorial Policy - Article Publication

Heh... I had similar feelings about some of the posts. Some of it was so wrong I was moved to say "I'll also say that a lot of 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)

August 13, 2009 at 10:40 pm

#1039137

Viewing 15 posts - 42,316 through 42,330 (of 59,102 total)