Jeff Moden

Forum Replies Created

Viewing 15 posts - 51,061 through 51,075 (of 59,098 total)

RE: Indexed View / Creating unique clustered index: Slow, consuming massive disk space

Matt Miller (4/17/2008)
If you start doing Crane kicks...I'm outta here:hehe:
Ya gotta be "stumped" to practice those...:hehe:
--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)

April 17, 2008 at 6:27 pm

#804068
RE: Insert...or UpdateCursor..Which is faster?

Keep in mind what I said in the conclusion of the article on triangular joins...
Not all Triangular Joins are bad. With some restraint and the right criteria, Triangular Joins can...
--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)

April 17, 2008 at 6:15 pm

#804065
RE: application running slow

escaleraroyal (4/17/2008)
Jeff Moden (4/16/2008)
escaleraroyal (4/16/2008)
update.
Vendor says the same applicationX runs fast in another company1 which has a higher volumne of data. He thinks it's our clustering server that is causing...
--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)

April 17, 2008 at 6:09 pm

#804064
RE: I got burned today at a SQL Server Interview!

jburkman (4/17/2008)
Jeff Moden (4/17/2008)
Jeff Moden (4/17/2008)
It's a tail yank, Brandie... someone who hates East Indians and is trying to give them a bad name. It would appear that was...
--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)

April 17, 2008 at 9:49 am

#803827
RE: I got burned today at a SQL Server Interview!

Jeff Moden (4/17/2008)
It's a tail yank, Brandie... someone who hates East Indians and is trying to give them a bad name. It would appear that was the whole intent...
--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)

April 17, 2008 at 8:56 am

#803784
RE: I got burned today at a SQL Server Interview!

Despite that... there's a lot of good information on this thread.: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)

April 17, 2008 at 8:39 am

#803766
RE: I got burned today at a SQL Server Interview!

It's a tail yank, Brandie... someone who hates East Indians and is trying to give them a bad name. It would appear that was the whole intent 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)

April 17, 2008 at 8:34 am

#803762
RE: how to look for an "enter" in a varchar

Look for CHAR(13) carriage return or CHAR(10) line feed.
--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)

April 17, 2008 at 8:27 am

#803755
RE: Insert...or UpdateCursor..Which is faster?

Highwayman (4/17/2008)
but the good news is that now management sees why their design sucks..and I have been given a green light to begin working on normalization...
Then it all worked out!...
--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)

April 17, 2008 at 8:07 am

#803734
RE: I got burned today at a SQL Server Interview!

I'm hoping it's just a tail yanking... dunno if it killed the thread or not... we'll see... heh, like everything else, "It Depends". 😛
--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)

April 17, 2008 at 8:02 am

#803731
RE: Linking to next row using a join on row_number()+1=row_number()

Yeaup... I absolutely agree that things like GROUP BY and by making sure that the triangular joins make very small triangles can be very effective. Still, it's something to...
--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)

April 17, 2008 at 7:53 am

#803719
RE: Grouping by Count

You just shouldn't put an ORDER BY in a view... what if someone wants it in a different order... lots of wasted clock cycles.
--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)

April 17, 2008 at 7:10 am

#803677
RE: Synchronize SQL databases

rbarryyoung (4/16/2008)
And now a word from our sponsors ...;)
Heh... didn't mean too push the sponsor... and I wouldn't have if I never used it. :hehe:
--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)

April 17, 2008 at 7:01 am

#803672
RE: T-sql update name fields

Set up a million row test like I taught you...
--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)

April 17, 2008 at 6:59 am

#803671
RE: I got burned today at a SQL Server Interview!

Mark Markov (4/17/2008)
WOW!!!!!!!!!!!!
I came back here today and was amazed to find 31 pages of responses! I could never imagine that my post would be so popular!
Here's an update 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)

April 17, 2008 at 6:55 am

#803665

Viewing 15 posts - 51,061 through 51,075 (of 59,098 total)