Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,746 through 20,760 (of 59,072 total)

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
RE: Urgent SQL Developer vs Enterprise edition 2012/2014

Eric M Russell (5/13/2015)
In addition to the above, unserstand that multiple users may connect to Developer Edition, but licensing requires that each user must have a developer edition license, which...
--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 7:28 am

#1797529
RE: Space needed for clustered index rebuild

Just to summarize the steps using partitioned tables that I imagine we'd do on your system, Ken, is...
1. Setup a database on the "extra storage".
2. Create the partitioned table 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 7:20 am

#1797522
RE: Space needed for clustered index rebuild

Please see the attached zip file for what can be done. The Power Point presentation is well worth watching in the presentation mode, especially when you get to 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 12, 2015 at 10:48 pm

#1797436
RE: Refreshing the data warehouse without hurting anybody

Heh... thanks for the feedback, Bertrand.
Now, if you haven't seen the following, make sure that you don't have your mouth full of your favorite beverage and imagine the negotiations 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)

May 12, 2015 at 8:51 pm

#1797432
RE: Refreshing the data warehouse without hurting anybody

GPO (5/12/2015)
Our management decided for reasons best known to themselves, to outsource our data warehouse development. It became apparent that while the company we chose had probably built some simple...
--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 12, 2015 at 7:17 pm

#1797428
RE: Month name and year in sql

There is a way to seemingly sort formatted month and year combinations. Please see the following article and apply your favorite format.
http://www.sqlservercentral.com/articles/T-SQL/71511/
I second what the others have stated, though....
--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 12, 2015 at 6:36 pm

#1797425
RE: The Service Pack Fiasco

David.Poole (5/12/2015)
I'd love to hear what Microsoft do with testing SQL Server. Do they use TDD/BDD, manual methods and are they designing SQL Server code to be testable?
What are...
--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 12, 2015 at 6:10 pm

#1797421
RE: Not Only a Meeting of Minds, but of Open Minds.

Gary Varga (5/12/2015)
...and then go to the pub 🙂
Heh... that's the ultimate in "open minds" for me because just about ANY pub will do! 😛
--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 12, 2015 at 6:09 pm

#1797420
RE: Update takes too long

I love it. A newbie to the forum with just 7 points and already posting million row test tables.
Welcome aboard, Jason!
--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 12, 2015 at 3:19 pm

#1797393
RE: Not Only a Meeting of Minds, but of Open Minds.

xsevensinzx (5/12/2015)
Jeff Moden (5/12/2015)
Just so that no one thinks I'm a Luddite, I absolutely believe in new and better technology. For example, ROW_NUMBER and the other ranking functions are...
--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 12, 2015 at 2:52 pm

#1797390
RE: Find the position of all occurrences of an expression within a string

j-1064772 (5/12/2015)
The second version has also taught me a lot.
I have been trying to complete the function so that it would return as separate "words" the characters between each delimiter...
--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 12, 2015 at 11:13 am

#1797347

Viewing 15 posts - 20,746 through 20,760 (of 59,072 total)