Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,446 through 20,460 (of 59,098 total)

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
RE: Native Audits

phegedusich (6/8/2015)
Jeff, Guardium captures the activity and provides very granular reporting capabilities (who did what when). It's read-only as far as interaction with SQL Server. A Guardium user can't 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)

June 8, 2015 at 4:40 pm

#1803854
RE: Should Salary Information Be Confidential?

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 joining a company that has...
--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 8, 2015 at 4:15 pm

#1803852
RE: Should Salary Information Be Confidential?

Eric M Russell (6/8/2015)
Jeff Moden (6/8/2015)
Eric M Russell (6/8/2015)
Jeff Moden (6/8/2015)
Andy Warren (6/8/2015)
Jeff, would you decline an offer from a company that publishes all salaries?
Yes.
Even if the company were financially...
--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 8, 2015 at 4:07 pm

#1803851
RE: Restore Sequence

Now for a question to you... Your avatar is of a book cover for a "Complete Guide to Database Administration". Isn't this information in that book?
--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 8, 2015 at 2:53 pm

#1803831

Viewing 15 posts - 20,446 through 20,460 (of 59,098 total)