Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,846 through 25,860 (of 59,099 total)

RE: Are the posted questions getting worse?

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 make excellent sabot...
--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:48 am

#1653160
RE: Are the posted questions getting worse?

Greg Edwards-268690 (9/24/2013)
Jeff Moden (9/23/2013)
dwain.c (9/23/2013)
Grant Fritchey (9/23/2013)
Careful there! NSA monitoring in progress.
Raccoons knocked it off the shelf in the garage in the dead of winter and the PVC...
--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 24, 2013 at 3:41 pm

#1652908
RE: Are the posted questions getting worse?

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 in a potato specially carved...
--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 24, 2013 at 3:39 pm

#1652907
RE: Are the posted questions getting worse?

Ed Wagner (9/24/2013)
I'd be careful when seeking revenge on the critters in the garage, though. If you use that it sounds like your next project will be repairing 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 24, 2013 at 3:37 pm

#1652906
RE: Are the posted questions getting worse?

paul.knibbs (9/24/2013)
Jeff Moden (9/23/2013)One of these days, I'm going to sit down and calculate the muzzle velocity on that bad boy.
Well, ignoring air resistance you'd be talking something like 150mph......
--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 24, 2013 at 3:33 pm

#1652905
RE: Tempdb data file fills up very often

Angeltica (9/24/2013)
Microsoft recommend unlimited growth for temp databases.
Initial size should be 50 MB for all temp dbs with 500MB file growth with unlimited Max Growth. hope it helps
Where's the MS...
--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 24, 2013 at 3:24 pm

#1652902
RE: Tempdb data file fills up very often

GilaMonster (9/24/2013)
To be honest, I wouldn't trust some of MS's recommendations.
You cannot make a blanket statement as to how big TempDB should be.
+1 to both of those statements.
--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 24, 2013 at 3:22 pm

#1652900
RE: OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active."

Actually, the resident "hack" genius, Mr. Erland Sommarskog, may have provided the solution in one of his many great blog entries. We're testing it out to see what, if...
--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 24, 2013 at 10:57 am

#1652837
RE: Need to fill the Gaps with previous value

cooljagadeesh (10/8/2012)
CREATE TABLE #SAMPLETABLE
(
DATECOL DATETIME,
WEIGHTS float
)
INSERT INTO #SAMPLETABLE
SELECT '08/09/2012',8.2 UNION ALL
SELECT '08/10/2012',9.4 UNION ALL
SELECT '08/14/2012',10 UNION ALL
SELECT '08/15/2012',9.6 UNION ALL
SELECT '08/16/2012',9.3 UNION ALL
SELECT '08/19/2012',9.7
declare @min-2...
--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 24, 2013 at 6:20 am

#1652682
RE: Need to fill the Gaps with previous value

Leifton (9/24/2013)
Hopefully there are still some people that get updates regarding this thread. I have a follow up question as I recently encountered a similar situation to the original...
--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 24, 2013 at 6:18 am

#1652679
RE: Are the posted questions getting worse?

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 Nitrogen tri-Iodide powered Pixie Sticks....
--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 23, 2013 at 10:08 pm

#1652554
RE: SSRS report with dynamic column headers

happycat59 (9/23/2013)
As akhileshguha05 suggests in his last post - use a matrix report. The column headings will be the values found in the dataset (e.g. the months of this...
--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 23, 2013 at 10:02 pm

#1652553
RE: Are the posted questions getting worse?

dwain.c (9/23/2013)
Grant Fritchey (9/23/2013)
Careful there! NSA monitoring in progress.
Thank goodness for that. Someone has to keep us ol' submarine sailors from having too much fun. I figure...
--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 23, 2013 at 9:18 pm

#1652546
RE: OLE DB provider "SQLNCLI" for linked server " " returned message "No transaction is active."

pkennedy 77296 (5/15/2013)
I had the same problem. My two servers were in different domains. I had to add hosts entries on each server. For example, 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 23, 2013 at 7:26 pm

#1652537
RE: Are the posted questions getting worse?

GilaMonster (9/23/2013)
And now that the paperwork has been signed....
November it's good bye consulting, back to full time grind. Starting at a software development house as a technical lead. Focusing 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)

September 23, 2013 at 3:46 pm

#1652498

Viewing 15 posts - 25,846 through 25,860 (of 59,099 total)