Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,141 through 49,155 (of 59,093 total)

RE: Soft Skills

cyndi.horn (7/21/2008)
Jeff Moden's Three Rules of DBA's.
I, DBA?
Or, maybe get a little Edgar Rice Burroughs into it... "Ugh... Me DBA... you user!" 😛
--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)

July 21, 2008 at 4:09 pm

#846068
RE: Soft Skills

Wayne West (7/21/2008)
Jeff Moden (7/21/2008)
[font="Arial Black"]Jeff Moden's Three Rules of DBA's.[/font]
1. A DBA may not injure data or performance of the data or, through inaction, allow data or performance 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)

July 21, 2008 at 4:06 pm

#846066
RE: doubt

Heh... yeah... I'm the same way... it's easier for me to remember an aggregate qualified by a CASE than it is to remember the Pivot syntax because it's so simple....
--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)

July 21, 2008 at 7:29 am

#845752
RE: Soft Skills

jpowers (7/18/2008)
As with any technique for dealing with opponents (whether in communication or karate), one needs to use good judgment. No technique is good for all situations, and may...
--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)

July 21, 2008 at 7:04 am

#845734
RE: Need to remove duplicate records and get distinct values

d_sysuk (7/21/2008)
shame I saw nobody else solve Part II !
No need to gloat... No sense in someone else solving it... you already did 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)

July 21, 2008 at 6:05 am

#845703
RE: doubt

Yes, you can... you'll loose performance, as well. 😉 It turns out that Cross Tabs are generally quicker than Pivots especially if you preaggregate the data in 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)

July 21, 2008 at 5:43 am

#845691
RE: There is insufficient system memory to run this query - system.web

Jonathan Kehayias (7/20/2008)
I still stand by the old rule of thumb that procedural business logic belongs in a middle tier outside of the database.
Heh... like everything else, it depends... 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)

July 20, 2008 at 9:48 pm

#845472
RE: There is insufficient system memory to run this query - system.web

That's a bummer... just goes to show what I've said in the past when people pitch a fit about using undocumented stored procedures... I tell them "Look! Even 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)

July 20, 2008 at 12:56 pm

#845448
RE: There is insufficient system memory to run this query - system.web

Instead of trying to reinvent the wheel... why not just use sp_MakeWebTask?
--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)

July 20, 2008 at 9:11 am

#845420
RE: How to upload 2mb file in text column

So, use something better like Bulk Insert.
--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)

July 19, 2008 at 6:12 pm

#845364
RE: There is insufficient system memory to run this query - system.web

What are you trying to do with the CLR?
--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)

July 19, 2008 at 6:05 pm

#845363
RE: nvarchar concatenation with 'foo' or N'bar'

Ya beat me to it, Chris. 🙂
--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)

July 19, 2008 at 6:04 pm

#845362
RE: doubt

jayrsangani (7/18/2008)
i need this for text columns not for aggregates
thanx for the reply
Heh... trust me... with a little help from ROW_NUMBER(), aggregates are the way to go for this...
--===== Create...
--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)

July 19, 2008 at 5:44 pm

#845361
RE: Things You Didn't Know About Temp Tables and Table Variables

By the way... Folks, say hi to Adam Mechanic... he's the guy that first introduced me to the idea of what I currently call a Tally table.
Thanks again for 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)

July 18, 2008 at 8:46 pm

#845307
RE: Things You Didn't Know About Temp Tables and Table Variables

Adam Machanic (7/18/2008)
Jeff Moden (7/18/2008)
Viswanath S. Dhara (7/18/2008)
I am trying to update a table using a correlated subquery.
Why? Correlated subqueries are a form of RBAR and 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)

July 18, 2008 at 7:44 pm

#845305

Viewing 15 posts - 49,141 through 49,155 (of 59,093 total)