Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,351 through 43,365 (of 59,102 total)

RE: My Approach to Writing for SQLServerCentral

Outstanding article, David... as usual. Thanks for the great reminders and suggestions.
I'd like to remind folks of two other things...
1. Use a spelling checker...
2. Not everything 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)

June 19, 2009 at 6:05 am

#1012301
RE: Why Object Databases will always be Tomorrow's Technology

I've not had to work with an object database and I quit being a GUI programmer a long time ago when a manager told me to put white lettering 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)

June 18, 2009 at 9:24 pm

#1012155
RE: Are the posted questions getting worse?

I must have made a mistake somewhere on my PASS abstract submittals. I've gotten no email for either acceptance or denial.
I'll send them an email and see what's up.
--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 18, 2009 at 8:04 pm

#1012144
RE: Are the posted questions getting worse?

Bruce W Cassidy (6/18/2009)
[font="Verdana"]I'm guessing that the ISO SQL group weren't thinking of calculating running totals when they defined the windowing version of SUM(). If they add that capability...
--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 18, 2009 at 6:56 pm

#1012136
RE: Are the posted questions getting worse?

Apologies to all... I got the SUM() OVER thing exactly backwards. PARTITION BY is the only part of the OVER clause that can be used. What I'd 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 18, 2009 at 6:34 pm

#1012134
RE: Are the posted questions getting worse?

RBarryYoung (6/17/2009)
Jeff Moden (6/17/2009)
...All they really need to do is make SUM() OVER work according to ANSI standards (or so I've heard). Of course, that particular documented feature change...
--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 17, 2009 at 5:49 pm

#1011368
RE: Are the posted questions getting worse?

Paul White (6/17/2009)
I used both 2005 and 2008 - though the posted execution plan was from my 2005 instance.
The fascinating thing, as Barry remarked, is the rows-in-reverse-order thing. I...
--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 17, 2009 at 3:50 pm

#1011335
RE: SQL script to import data from .txt table using BCP

Ummmm.... there is a way around this in T-SQL but let me ask a couple of questions....
(1) How many delimiters are there supposed to be?
(2) What are the delimiters?...
--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 17, 2009 at 3:44 pm

#1011329
RE: SQL script to import data from .txt table using BCP

Frances L (6/17/2009)
my file is like that.
PID SPECIALTY PNAME ...
--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 17, 2009 at 3:39 pm

#1011324
RE: NULL and Unique IDentifier.. :-(

Jeffrey Williams (6/17/2009)
only4mithunc (6/17/2009)
since by default the unique identifire is non-clustured , the records should be in the same order I have inserted na..?
By definition, a table has no order....
--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 17, 2009 at 11:53 am

#1011175
RE: TempDB mdf file has grown to 11GB

Carl Federl (6/17/2009)
Just for discussion, how do you stop anyone from using tempdb ?
Do what any DBA does... setup a script to wait for the appropriate quiet time. 🙂
I've used...
--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 17, 2009 at 11:48 am

#1011173
RE: pivot or cross tab assistance

Rich96 (6/17/2009)
Jeff & Christopher.. thanks so much for the feedback! Looks like I have some reading to do.
You bet, Rich... thanks for the feedback.
By the way, what's in 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)

June 17, 2009 at 10:39 am

#1011130
RE: Are the posted questions getting worse?

GilaMonster (6/17/2009)
Paul White (6/17/2009)
Yep. I have been quite a proponent of the UPDATE method in the past, but I must admit I am now concerned. The list 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)

June 17, 2009 at 10:35 am

#1011124
RE: Are the posted questions getting worse?

Paul White (6/17/2009)
Lynn Pettis (6/17/2009)
Flip the order of the tables in the trigger and the the update occurs properly based on the clustered index on the table being updated even...
--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 17, 2009 at 10:33 am

#1011121
RE: Are the posted questions getting worse?

GilaMonster (6/17/2009)
Jeff Moden (6/16/2009)
Now, if we could just get them to say that UPDATEs always work in clustered index order... 😛
They won't. The unofficial word from one of the guys...
--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 17, 2009 at 10:26 am

#1011117

Viewing 15 posts - 43,351 through 43,365 (of 59,102 total)