Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,831 through 25,845 (of 59,102 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (9/25/2013)
No need for a potato gun, lathe, or automation.
If you need it peeled, find someone that deserves a little punishment. Kids are good for...
--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)

September 26, 2013 at 5:27 pm

#1653800
RE: Are the posted questions getting worse?

Chad Crawford (9/25/2013)
The Dixie Flatline (9/24/2013)
I haven't launched an Estes rocket in almost 40 years, but why stop at potatoes? It strikes me that carrots would...
--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)

September 26, 2013 at 5:24 pm

#1653799
RE: Are the posted questions getting worse?

SQLRNNR (9/26/2013)
hisakimatama (9/26/2013)
SQLRNNR (9/26/2013)
hisakimatama (9/20/2013)
*Huff* *Wheeze* I... I did it! I managed to read the entirety of The Thread! That was... Interesting :-D. Been...
--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)

September 26, 2013 at 5:22 pm

#1653798
RE: Are the posted questions getting worse?

hisakimatama (9/26/2013)
Aaaaaaargh... And now, I need to fume :-P.
Working with the company's vendor software, and one of the reports is coming across super-slow, about 10 minutes to retrieve about...
--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)

September 26, 2013 at 5:13 pm

#1653797
RE: Are the posted questions getting worse?

Lynn Pettis (9/26/2013)
I know most Threadizens know I am currently deployed in Afghanistan as a civilian contractor.
I was notified this evening that my position state side has been cut as...
--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)

September 26, 2013 at 5:12 pm

#1653796
RE: Are the posted questions getting worse?

Jeff Moden (9/26/2013)
GilaMonster (9/26/2013)
Jeff Moden (9/26/2013)
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx
I'd try but that tempDB thread has worn me out.
Is 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)

September 26, 2013 at 9:10 am

#1653619
RE: Tempdb data file fills up very often

AlexMcCo (9/25/2013)
You do not need tempdb ndf file as large as you can make them. It is more than enough to put as 50 mb each. They will expand as...
--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)

September 26, 2013 at 9:04 am

#1653613
RE: Are the posted questions getting worse?

GilaMonster (9/26/2013)
Jeff Moden (9/26/2013)
Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx
I'd try but that tempDB thread has worn me out.
Is that the one...
--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)

September 26, 2013 at 8:55 am

#1653608
RE: Are the posted questions getting worse?

Greg Edwards-268690 (9/25/2013)
So you wore gloves to prevent cuts? Or DNA evicence?
Heh... damn. Secret is 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)

September 26, 2013 at 8:03 am

#1653583
RE: Are the posted questions getting worse?

Jack Corbett (9/25/2013)
GilaMonster (9/25/2013)
Someone want to add a voice of reason to this?
http://www.sqlservercentral.com/Forums/Topic1493948-391-1.aspx
I'd try but that tempDB thread has worn me out.
Is that the one where the fellow...
--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)

September 26, 2013 at 7:58 am

#1653581
RE: Max Memory

gary1 (9/25/2013)
I'm able get the offending query from profiler after selecting the below events in profiler and its taking 16 to 20 seconds in SSMS.
SP:StmtStarting ,SP:Stmtcompleted ,RPC:Starting , RPC:Completed and...
--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)

September 26, 2013 at 7:54 am

#1653579
RE: Are the posted questions getting worse?

L' Eomot Inversé (9/25/2013)
Greg Edwards-268690 (9/25/2013)
Jeff Moden (9/25/2013)
I forgot to mention a feature of the original that I made. I had beveled the muzzle so that it would cut...
--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)

September 26, 2013 at 7:46 am

#1653572
RE: Shift week to Wed - Tues

Michael Valentine Jones (9/25/2013)
That's not really the best way to go because it depends on the setting of a run-time session parameter, DATEFIRST.
Although I certainly prefer you method, I 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)

September 26, 2013 at 6:59 am

#1653533
RE: When Curiosity strikes

That particular thread is also no longer true. The "titles" for the higher levels has changed at least once since that post.
--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)

September 25, 2013 at 11:34 am

#1653288
RE: Shift week to Wed - Tues

paul.j.kemna (9/24/2013)
I do have a Date table at my disposal that has Date, WeekStartSunday, DayOfWeek, etc.
I believe the best thing to do would be to add WeekStartWednesday and DayOfWeekWednesday 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)

September 25, 2013 at 11:22 am

#1653285

Viewing 15 posts - 25,831 through 25,845 (of 59,102 total)