Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,301 through 45,315 (of 59,101 total)

RE: Hidden RBAR: Triangular Joins

LeeBear35 (2/3/2009)
I'm sure however that they will bring in consultants to address the issues, because that funding comes out of a different bucket.
There is nothing that says you couldn't become...
--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)

February 4, 2009 at 7:18 pm

#938563
RE: Difference between varchar(max) and varchar(8000)

charlesz (2/3/2009)
The contents of Varchar(MAX), NVarchar(MAX), VarBinary(MAX), and XML fields are encoded using "Partially Length-Prefixed" (PLP in short). A PLP stream starts with total length (8 bytes), followed by current...
--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)

February 4, 2009 at 7:11 pm

#938561
RE: Difference between varchar(max) and varchar(8000)

Lynn Pettis (2/4/2009)
(whispering..) I see high velocity pork chops....
(whispering wilst loading the pork chop cannon) C'mon target... stand up again... 😉
--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)

February 4, 2009 at 7:07 pm

#938560
RE: Difference between varchar(max) and varchar(8000)

J (2/4/2009)
Sounds like the beginning of a flame war.
Let's keep our cool here.
Regards
It's hard to keep cool when some forum spammer posts bum information, says that an intelligent member 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)

February 4, 2009 at 7:04 pm

#938559
RE: count of consecutive value

steve dassin (2/4/2009)
I appreciate your insight...when are you going to dive into Dataphor? 🙂
In all likely hood, never. Not because I don't think it's worthwhile or anything like that....
--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)

February 4, 2009 at 6:49 pm

#938556
RE: tempdb - Restricted File Growth option

Colin Lam (2/2/2009)
Jeff
How do you go about shrinking the tempdb through the GUI?
We don't know exactly what is causing the tempdb to grow so big, what we do know alot...
--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)

February 4, 2009 at 6:25 pm

#938553
RE: Sql Query Help

Grant Fritchey (2/3/2009)
I read that three times and didn't see the word concatenate until now... [putting on the blind fold, lighting a cigarette] Fire the pork chops when ready...
Heh... nah......
--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)

February 3, 2009 at 7:46 pm

#937678
RE: Changed to a StarWars Avatar...am I part of the Club now?

Max (2/3/2009)
I don't know, it's tough to say what with RBAR holding out.
Heh... had to stick with the "No RBAR" theme, somehow and still do the Star Wars thingy... changed...
--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)

February 3, 2009 at 7:25 pm

#937672
RE: Difference between varchar(max) and varchar(8000)

charlesz (2/2/2009)
Second, NVarchar(MAX) and Varchar(MAX) can only hold up to 65535 bytes ( The number posted by Gail Shaw was wrong).
Our product DB-WAN Accel communicates with SQL Server using TDS...
--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)

February 3, 2009 at 6:02 am

#937050
RE: count of consecutive value

steve (2/2/2009)
This 'clever' ranking trick is just the latest incarnation of characteristic functions.
BWAA-HAAA! So what? Heh... Consider this... If the people who wrote T-SQL and other languages got...
--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)

February 3, 2009 at 5:54 am

#937044
RE: Truncate Referenced Table

Sanjay (2/2/2009)
I got following error while compiling this x_TruncateTable proc:
Server: Msg 197, Level 15, State 1, Procedure x_TruncateTable, Line 126
EXECUTE cannot be used as a source when inserting into 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)

February 3, 2009 at 5:42 am

#937041
RE: Using trim with Join

benlatham (2/3/2009)
Heh... on that note, I'm glad I do all this stuff in T-SQL. 😛
I agree in general that TSQL should be used to do all the work but 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)

February 3, 2009 at 5:26 am

#937033
RE: Strange network error

kevriley (2/3/2009)
Jeff Moden (2/2/2009)
I can't remember exactly what the phrase in the returned data was, but I've had this happen before. Turned out that one of the "switches" 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)

February 3, 2009 at 5:14 am

#937027
RE: list of month names and week ranges between dates

ghughes (2/2/2009)
ok, I give up. I defer to everyone greater judgement in the matter. Make perfect sense. I have created table......thank you for the help.
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)

February 3, 2009 at 4:38 am

#937013
RE: Tutorial/Tips on writing SPs that are fast and upto standards of development

... and, if your programs are running slowly, the best tip I can give you is to make the paradigm shift from thinking in rows (RBAR) to thinking in set...
--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)

February 3, 2009 at 4:33 am

#937011

Viewing 15 posts - 45,301 through 45,315 (of 59,101 total)