Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,746 through 8,760 (of 59,067 total)

Reply To: Should Salary Information Be Confidential?

x wrote:
Jeff Moden wrote:
x wrote:
Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on the other...
--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)

August 28, 2019 at 1:47 pm

#3675071
Reply To: Should Salary Information Be Confidential?

x wrote:
Well that's different, on one hand we have associates at work who we will be personally familiar with and often work closely together, and on the other hand, we...
--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)

August 28, 2019 at 12:49 pm

#3675034
Reply To: Are the posted questions getting worse?

Ray K wrote:
Had a very pleasant surprise on Saturday!!!
I spoke in Providence on Saturday. Among my audience were these two gentlemen, one of whom was Jeff Moden. (Hi, Jeff! Good...
--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)

August 28, 2019 at 12:44 pm

#3675033
Reply To: Are the posted questions getting worse?

Beatrix Kiddo wrote:
Grant Fritchey wrote:
Ask them the difference between blocking and deadlocks. Those are always awesome answers. Less fun, but still fun, what's the difference between a clustered and non-clustered index is...
--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)

August 28, 2019 at 12:41 pm

#3675032
Reply To: Dynamically concatenate string

Whatever method you're trying, you're probably running into problems because you've defined the [FileName] column as a CHAR(400). For the value of "ABC", that means the row contains "ABC" followed...
--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)

August 28, 2019 at 5:19 am

#3674939
Reply To: Should Salary Information Be Confidential?

Lynn Pettis wrote:
x wrote:
Lynn Pettis wrote:
x wrote:
Lynn Pettis wrote:
x wrote:
Jeff Moden wrote:
Eric M Russell wrote:
If you are an employee of the US federal government, then your salary history is public information.
Search Federal Employee Salaries
https://www.fedsdatacenter.com
7,040,119 entries
Heh......
--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)

August 27, 2019 at 9:46 pm

#3674876
Reply To: Should Salary Information Be Confidential?

x wrote:
Jeff Moden wrote:
Eric M Russell wrote:
If you are an employee of the US federal government, then your salary history is public information.
Search Federal Employee Salaries
https://www.fedsdatacenter.com
7,040,119 entries
Heh... just one of the many...
--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)

August 27, 2019 at 7:00 pm

#3674821
Reply To: Deriving covered date ranges for drug Prescription data (without using a cursor)

I'd definitely be interested in how someone might do this to avoid a Cursor and other forms of RBAR.

Even more interesting would be why the requirement to skew data in...
--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)

August 27, 2019 at 6:54 pm

#3674819
Reply To: Tempdb Datafile initial space increasing.

SQL Bandit wrote:
Does the attached screen shot look odd to anyone?
Is the report lying on how much data space is being used?
You're confusing space-used with space_allocated. Also, you're settings appear 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)

August 27, 2019 at 6:47 pm

#3674816
Reply To: Should Salary Information Be Confidential?

Eric M Russell wrote:
If you are an employee of the US federal government, then your salary history is public information.
Search Federal Employee Salaries
https://www.fedsdatacenter.com
7,040,119 entries
Heh... just one of the many reasons 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)

August 27, 2019 at 6:43 pm

#3674815
Reply To: A Self-Tuning Fill Factor Technique for SQL Server – Part 2

Apologies... I posted a reply on the wrong thread and removed it.
--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)

August 27, 2019 at 6:38 pm

#3674814
Reply To: How can I convert %5B and %5D to [ and ] in a string

guerinto wrote:
Thanks Jeff. This appears to be exactly what I am looking for. How would I replace the string with a field name called int_ID now? I don't know what...
--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)

August 27, 2019 at 6:30 pm

#3674808
Reply To: Importing Files in Parallel with SSIS

You're correct in saying that loading a table with a Clustered Index in place does mean that you have to only use a single thread to be able to take...
--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)

August 27, 2019 at 5:23 pm

#3674794
Reply To: Importing Files in Parallel with SSIS

Some of the details may be irrelevant to parallel processing but, in my mind anyway, parallel processing during the initial load is just one part of the equation. As you...
--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)

August 26, 2019 at 11:55 am

#3674351
Reply To: Importing Files in Parallel with SSIS

@iposner ,
I'm curious... Did all 10,000 files have precisely the same format? And what was that format? CSV? TSV? Fixed Width Fields? And can you make a guess as 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)

August 25, 2019 at 6:11 pm

#3674264

Viewing 15 posts - 8,746 through 8,760 (of 59,067 total)