Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,411 through 43,425 (of 59,097 total)

RE: Append output from SQLCMD in batch file

WayneS (6/14/2009)
Jeff Moden (6/14/2009)
You've added a line of code the OP didn't have in the original problem and that new line is the one responsible for the incorrect operation.
echo %date%...
--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 14, 2009 at 10:59 am

#1009331
RE: Grouping problem

RBarryYoung (6/14/2009)
I guess almost everybody knows this trick by now?
Heh... apparently not. The OP didn't and neither did the 30 or so DBA's/Developers that I gave a couple 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 14, 2009 at 10:54 am

#1009328
RE: Are the posted questions getting worse?

GilaMonster (6/14/2009)
Encountering that kinda attitude either in posts, PMs or emails makes me stop and ask myself why the hell I'm doing the forum thing in the first place.
Heh... you've...
--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 14, 2009 at 10:45 am

#1009326
RE: Are the posted questions getting worse?

Steve Jones - Editor (6/14/2009)
I have removed the account of our (un)professional1 friend from the system and deleted threads. Apologies to those of you that had to deal with him/her....
--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 14, 2009 at 9:50 am

#1009314
RE: Append output from SQLCMD in batch file

WayneS (6/13/2009)
Okay, here's some code to demonstrate what I'm talking about.
Save this code as a batch file, and run it:
for %%a in ("%windir%\*.exe") do SQLCMD -S ServerName -d master -E...
--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 14, 2009 at 9:23 am

#1009309
RE: How to query data on weekly basis

David Jackson (6/14/2009)
Jeff
I think you have not quite got what I am saying. Apologies, I didn't explain it clearly 😉
Ah... got it. And, you're correct. I didn't make...
--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 14, 2009 at 9:09 am

#1009305
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

Aaron (6/13/2009)
The verdict is, 50 second delays has now turned into 28 seconds with the FROM / JOINS fixed in the trigger.
Unless the trigger is super costly, I'm still leaning...
--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 14, 2009 at 9:02 am

#1009301
RE: BETWEEN keyword versus =

Tom Brown (6/13/2009)
I think what Jeff's getting at is doing a date range report, where the data you're querying has time a component.
So you want all June's Data - BETWEEN...
--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 13, 2009 at 12:54 pm

#1009156
RE: What SQL Server Sites do you use?

Jeff Moden (6/13/2009)
... nothing's broke here that I can tell.
... heh... not counting the search functionality and the code windows, that is. 😛
--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 13, 2009 at 12:39 pm

#1009151
RE: Are the posted questions getting worse?

Nope... nothing in the spam folder. I wish they'd have done this all before the early bird specials expired.
--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 13, 2009 at 12:31 pm

#1009145
RE: Are the posted questions getting worse?

GilaMonster (6/13/2009)
The list's just the spotlight sessions, those were invitation only. If you submitted a general session you should have got an email last night (assuming they weren't sending 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)

June 13, 2009 at 12:30 pm

#1009143
RE: Locking Perf Problem: Help Update/Insert WITH table_hints

In that case, I'd add the appropriate indexes to the million row test tables and try the trigger that Paul wrote.
--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 13, 2009 at 12:27 pm

#1009142
RE: What SQL Server Sites do you use?

RBarryYoung (6/13/2009)
Hmm, before I jump into this any deeper let me ask: what would we be trying to accomplish by this? What shortcoming of SSC would we be fixing?...
--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 13, 2009 at 12:16 pm

#1009140
RE: Are the posted questions getting worse?

Steve Jones - Editor (6/13/2009)
Congrats Grant and Gail as well!
I'm an alternate, fine by me. Jeff, any word for you?
Didn't see my name on the list. Looks like some...
--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 13, 2009 at 12:13 pm

#1009135
RE: O(n) , O(n log n), O(n^2)

RBarryYoung (6/13/2009)
Jeff Moden (6/12/2009)
RBarryYoung (6/10/2009)
Jeff Moden (6/10/2009)
If you strip away all the small stuff that won't impact the result much when the numbers get really big, you end up with...
--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 13, 2009 at 11:58 am

#1009132

Viewing 15 posts - 43,411 through 43,425 (of 59,097 total)