Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,761 through 20,775 (of 59,098 total)

RE: Are the posted questions getting worse?

I agree with what the others have said. Your community service and that blog have been well above and beyond the call of duty and you advertising yourself 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)

May 14, 2015 at 11:51 am

#1797947
RE: Are the posted questions getting worse?

Ed Wagner (5/11/2015)
WayneS (5/11/2015)
Jeff Moden (5/8/2015)
Lynn Pettis (5/8/2015)
I do love showing people Jeff's DelimitedSplit8K function and pointing them to his article.
:blush: I'm honored, ol' friend. It's not mine...
--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)

May 14, 2015 at 8:38 am

#1797877
RE: Need Ammunition for Developers Doing Select *'s

Careful now... I wouldn't ignore the elapsed time. Frequently, it's a strong indication of disk activity even if stats I/O isn't turned on to see. You just 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)

May 13, 2015 at 6:17 pm

#1797726
RE: MCSA 70-461 Question

There's always an exception to every rule... in this case, it would be the good folks that earned an MCM.
--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)

May 13, 2015 at 6:01 pm

#1797724
RE: Urgent SQL Developer vs Enterprise edition 2012/2014

Steve Jones - SSC Editor (5/13/2015)
Current licensing says 2 core packs. With their verbiage, it's confusing. The licensing PDF does say minimum of 4 cores, so my apologies.
Of course, it's...
--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)

May 13, 2015 at 5:29 pm

#1797720
RE: Are the posted questions getting worse?

jasona.work (5/13/2015)
Ed Wagner (5/13/2015)
Lynn Pettis (5/13/2015)
jasona.work (5/13/2015)
Looks like Grant hadn't had his daily mandatory caffiene intake when he posted here:
:hehe:
On an unrelated note, does anyone here have any experience 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)

May 13, 2015 at 5:23 pm

#1797719
RE: MCSA 70-461 Question

Lynn Pettis (5/13/2015)
Only two reasons I would get the certs right now. One, if my employer came to me and said it was a requirement for my job. Two,...
--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)

May 13, 2015 at 5:10 pm

#1797718
RE: Archieving Data

And just to be sure, there's no freakin' way that I'd use SSIS for any 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)

May 13, 2015 at 4:50 pm

#1797715
RE: Archieving Data

ramana3327 (5/13/2015)
Hi,
Another point to note here is that table is replicating and the table has more than 55000000 records greater than 3 months. Is this no of rows are ok...
--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)

May 13, 2015 at 4:48 pm

#1797714
RE: Refreshing the data warehouse without hurting anybody

GPO (5/13/2015)
it shouldn't void any warranty (BWAAAA-HAAAAA-HAAA!!!! Like someone thought of that in the contract!
Are you psychic? Actually there was one warranty. That was that they'd bill us come...
--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)

May 13, 2015 at 4:39 pm

#1797712
RE: The Service Pack Fiasco

TomThomson (5/13/2015)
Jeff Moden (5/11/2015)
MS has to do one very important thing... they need to slow down and do service packs 100% correct. SPs are supposed to fix things, not...
--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)

May 13, 2015 at 3:43 pm

#1797701
RE: Urgent SQL Developer vs Enterprise edition 2012/2014

Steve Jones - SSC Editor (5/13/2015)
EE at $4k / 2 core? Really? I thought it was closer to $7k/core, min of two. The open price is $14k/core.
I think $4k/2 core...
--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)

May 13, 2015 at 9:16 am

#1797584
RE: Refreshing the data warehouse without hurting anybody

My apologies. I got caught up in my outrage over yet another vendor that can't do what they said they could do.
You and Ron are spot on with 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)

May 13, 2015 at 8:22 am

#1797561
RE: Urgent SQL Developer vs Enterprise edition 2012/2014

Gazareth (5/13/2015)
From MS's point of view: 2-core VM with Enteprise Edition ~$4000. 10 x Dev Editions ~$500. Think I know which one they prefer 😀
Who are you buying you licensing...
--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)

May 13, 2015 at 8:13 am

#1797557
RE: Can Auditing Fail?

Mine's a bit more altruistic than just keeping my butt out of the sling. To make a really long story short, we had a surprise audit and were given...
--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)

May 13, 2015 at 8:10 am

#1797556

Viewing 15 posts - 20,761 through 20,775 (of 59,098 total)