Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,776 through 8,790 (of 59,099 total)

Reply To: Tempdb Datafile initial space increasing.

Be careful now... if you do any work with SET IDENTITY_INSERT ON, you might want to reconsider especially on later versions where they essentially made Trace Flag 1117 ALWAYS active...
--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 9:38 pm

#3675219
Reply To: Index and fragmentation

Here's a presentation by Paul Randal on the subject. He's the guy that wrote most of the fragmentation related stuff.
https://www.youtube.com/watch?v=p3SXxclj_vg
--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 9:03 pm

#3675204
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

Viewing 15 posts - 8,776 through 8,790 (of 59,099 total)