Jeff Moden

Forum Replies Created

Viewing 15 posts - 26,566 through 26,580 (of 59,099 total)

RE: Today's Random Word!

Saint (our resident Saint is headed overseas and will be in harms way).
--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)

June 24, 2013 at 4:16 pm

#1626946
RE: Are the posted questions getting worse?

The Dixie Flatline (6/24/2013)
GilaMonster (6/24/2013)
You shrunk a database? How could you???
:hehe:
Yeah, they told me at PASS that every time you shrink a database a puppy gets killed. :crying:
You sure? ...
--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)

June 24, 2013 at 4:03 pm

#1626944
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (6/24/2013)
Just so the rest of you can feel jealous, I got a hug from Gail and a handshake from Rodney last week 🙂
I can't top...
--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)

June 24, 2013 at 4:01 pm

#1626943
RE: Big Performance Problem with Merge Statement

Couple of other good ones on the same subject...
http://sqlinthewild.co.za/index.php/2010/02/18/not-exists-vs-not-in/
http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/
--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)

June 24, 2013 at 12:58 pm

#1626887
RE: Big Performance Problem with Merge Statement

spaghettidba (6/24/2013)
Paul, your answers could be collected in a book and it would be an absolute best-seller!
Awesome, as usual.
+1000 to that. What would be even better is if MS...
--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)

June 24, 2013 at 10:30 am

#1626855
RE: Running Totals

Thanks, Kevin. :blush: Very kind words, indeed.
--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)

June 24, 2013 at 10:27 am

#1626854
RE: How is the job market in the NYC area?

Aadhar Joshi (6/22/2013)
Jeff sounds interesting, u should do instead.
I've already done it. Wouldn't have recommended it unless I tried it and it worked. That's why I currently have...
--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)

June 23, 2013 at 10:46 pm

#1626645
RE: Great DBAs do <blank>

I guess my take on why there aren't so many articles on how to be a Great DBA is that it's a bit of a Catch 22. The Great...
--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)

June 23, 2013 at 10:15 pm

#1626640
RE: T SQL Update statement that is set based

Add a calculated column to the table to create a persisted datetime column. It'll make life a lot easier.
--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)

June 23, 2013 at 9:32 pm

#1626637
RE: Data Masking

k.thanigaivel (3/24/2011)
Dear All,
I want to mask the data in development server and same need to get back in to production server. how can i done ?please help me.
Look up "LIKE"...
--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)

June 23, 2013 at 9:14 pm

#1626635
RE: Create procedure for data modification

Rauf Miah (6/23/2013)
table name : mrinf
fields : companycode nchar(4), mrno (nchar(9), chqno nvarchar (50), tranamount decmal (18,2)
I have to update the several sequential (incremented by 1) mrno to a new...
--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)

June 23, 2013 at 9:02 pm

#1626633
RE: Pushing around large volumes of data

Most likely, the "Devil is in the Data". Are the columns in the table for Field1, Field2, and Field3 constrained as being "NOT NULL"? If not, that's likely...
--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)

June 23, 2013 at 6:58 pm

#1626629
RE: SQL Server Execution Plans, Second Edition by Grant Fritchey

For anyone that judges a book by the stars on the article that introduces it, pay no attention to the paltry 3 stars. That was due just to 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)

June 23, 2013 at 5:40 pm

#1626627
RE: SQL Server T-SQL Boot Camp 3-5 days anywhere in the United States

SQL_Enthusiast (6/21/2013)
I have a team of coders that I need to train how to code better in SQL 2005 and 2008. Is there a Microsoft approved partner that anyone knows...
--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)

June 23, 2013 at 5:32 pm

#1626626
RE: Running Totals

TheSQLGuru (6/23/2013)
I got to stand on the shoulders of a TSQL Giant (hey Jeff!)! 🙂
So that's what it was... I had a giant standing on my shoulders. 🙂
No pun intended...
--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)

June 23, 2013 at 3:39 pm

#1626625

Viewing 15 posts - 26,566 through 26,580 (of 59,099 total)