Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,416 through 20,430 (of 59,072 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (6/9/2015)
Jeff Moden (6/4/2015)
Shifting gears a bit...
Have any of you ever used a CTP of SQL Server to power your real production databases? Personally, I...
--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)

June 9, 2015 at 9:47 pm

#1804192
RE: Finding / getting in touch with recruiters?

jasona.work (6/9/2015)
Starting from the bottom:
Jeff: Yes, I'm currently up in Clinton Township.
As for the commute, Toledo would be a last-ditch resort, unless the telecommute option was on the table...
--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)

June 9, 2015 at 9:38 pm

#1804191
RE: Should Salary Information Be Confidential?

TomThomson (6/9/2015)
Jeff Moden (6/9/2015)
Eric M Russell (6/9/2015)
Jeff Moden (6/8/2015)
...
I also won't work for a company that does intelligence or personality testing. Again, it has been a powerful indicator 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)

June 9, 2015 at 9:36 pm

#1804190
RE: Normalizing a database

madan.preeti2005 (6/9/2015)
Oh yes i forgot to mention that, once data is populated, indexes will be recreated. Do you think that will tune query to some extent?
Do you know how 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)

June 9, 2015 at 4:32 pm

#1804173
RE: SQL Server DBA or BI

dniranjan2000 (6/9/2015)
Dear Friends,
I am new to SQL Server, working as an IT support for the past 7 years and want to move to SQL
I am learning TSQL , and need...
--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)

June 9, 2015 at 4:26 pm

#1804170
RE: Like to have data returned in 1 row vs. multiple rows

Is the number of columns in the final output a given or do we have to have the code figure that 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)

June 9, 2015 at 4:18 pm

#1804168
RE: Parsing large varbinary fields

Hi Tom,
Understood on the existing rows.
Peeling 1 potato at a time, can you use SQL CLR? The reason I ask is because there's a decent SQL CLR splitter...
--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)

June 9, 2015 at 4:16 pm

#1804167
RE: Finding / getting in touch with recruiters?

@jasona,
Aren't you right here in SE Michigan? If so, I have several great recruiters that I can put you in touch 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)

June 9, 2015 at 2:34 pm

#1804130
RE: Parsing large varbinary fields

The easiest way would be to do things "on the way in". How do these large Stats_Data values get into the table you posted to begin 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)

June 9, 2015 at 1:08 pm

#1804096
RE: Archive Every Day

From the article:
Maybe we should have partitioning implemented early on, though the edition limits on that technology are problematic.
Somehow, it seems, that partitioned views have fallen out of vogue...
--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)

June 9, 2015 at 1:02 pm

#1804093
RE: Archive Every Day

Lynn Pettis (6/9/2015)
Would be nice if Microsoft brought partitioning to all editions of SQL Server, well, maybe not Express but it wouldn't hurt for people experimenting.
It's a little different 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)

June 9, 2015 at 12:51 pm

#1804089
RE: The Multi-skilled Developer

David.Poole (6/9/2015)
For some reason I kept hearing "by the time a man thinks his father may have been right he has a son who thinks he's wrong".
Back in the 1980s...
--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)

June 9, 2015 at 8:35 am

#1803980
RE: Should Salary Information Be Confidential?

Eric M Russell (6/9/2015)
Jeff Moden (6/8/2015)
Andy Warren (6/8/2015)
Jeff, maybe I didnt ask the question well. I'm not arguing with your choices - yours to make! Just curious to understand if/why...
--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)

June 9, 2015 at 8:27 am

#1803975
RE: SELECT INTO vs INSERT INTO on Columnstore

The scenario descriptions in the final chart of the article also don't seem to match the actual scenario descriptions in the text of the article. That also means (I...
--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)

June 9, 2015 at 8:05 am

#1803967
RE: SELECT INTO vs INSERT INTO on Columnstore

Irish Flyer (6/9/2015)
Your article is incomplete without adding that a SELECT INTO is considered a DDL statement and completely locks both source and target tables for the duration of its...
--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)

June 9, 2015 at 8:03 am

#1803966

Viewing 15 posts - 20,416 through 20,430 (of 59,072 total)