Jeff Moden

Forum Replies Created

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

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
RE: Tempdb data file fills up very often

Angeltica (9/25/2013)
http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-1230-tempdb-should-always-have-one-data-file-per-processor-core/
Based on this article we are configuring out tempDB. But if it is expanding too much, you definitely have to have a look into code.
Here are some basic...
--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 8:02 am

#1653176
RE: Are the posted questions getting worse?

Greg Edwards-268690 (9/24/2013)
wolfkillj (9/24/2013)
Jeff Moden (9/24/2013)
wolfkillj (9/24/2013)
paul.knibbs (9/24/2013)
wolfkillj (9/24/2013)
A recoilless potato rifle??? That would be AWESOME!!!
How expensive would the Gyrojet spuds be, though? 🙂
I'm thinking a model rocket motor embedded...
--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 7:54 am

#1653169
RE: Are the posted questions getting worse?

L' Eomot Inversé (9/24/2013)
Jeff Moden (9/23/2013)
dwain.c (9/23/2013)
I'm more interested in the specs on your rail gun pork chop launcher. 😛
BWAA-HAAA!!!! Sorry... that would be proprietary information. So are 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)

September 25, 2013 at 7:50 am

#1653164

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