Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,786 through 7,800 (of 59,091 total)

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

Abrar Ahmad_ wrote:
Yes, a Deep Dive thread!
Do you can also comment of PAD_INDEX settings in this all POC discussion? Currently in either fill factor settings your script is setting PAD_INDEX=OFF .
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)

February 10, 2020 at 1:44 pm

#3724360
Reply To: Calling a SQL Server Agent job

I'm thinking that it should be the other way around... an SQL Server Agent job should be calling the PowerShell.
--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)

February 9, 2020 at 8:46 pm

#3724240
Reply To: Copy latest sql full backup file from one server to another

p.s. Remember that the COPY command does NOT require you to provide a file name for the target. You only need to provide it with a directory name and 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)

February 7, 2020 at 8:04 pm

#3724046
Reply To: Copy latest sql full backup file from one server to another

With the understanding that I kept it super simple for understanding and haven't parameterized some of the things that could/should be, here's how to pull the full path name for...
--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)

February 7, 2020 at 7:58 pm

#3724040
Reply To: Modify Data to Add a Letter Before Numbers

uknites wrote:
I was trying to copy the data from one column to another and then add X in front of it
Thanks a lot 🙂
I managed to do it with your...
--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)

February 7, 2020 at 7:11 pm

#3724036
Reply To: Help with query

Yes, the OP should be doing that but you also presumed that the OP knows how to convert the data to a normalized form. In order for the OP 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)

February 7, 2020 at 4:31 pm

#3723991
Reply To: Parallel Load thousands csv Files

Ah... finally found this post again. Like I said on my last, is there any chance at of of you attaching the first 10 or so line of one of...
--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)

February 7, 2020 at 6:45 am

#3723837
Reply To: Help with query

jcelko212 32090 wrote:
>>
SELECT rm_id FROM Foobar
EXCEPT
SELECT rm_id FROM Vague_Relationships;
Since I DID provide the DDL and a substantial amount of readily-consumable data for anyone (including you) to test with, you should get...
--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)

February 7, 2020 at 5:54 am

#3723827
Reply To: Help with query

Here's some test data... You'll need to build the fnTally function that I have a link for in my signature line below unless you already have one of your own.
--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)

February 6, 2020 at 5:25 am

#3723491
Reply To: bcp error on NULL: "Unexpected EOF encountered in BCP data-file"

You BCP format file says that the delimiter for the end of the 1st field should start with a pipe and end with a quote. It doesn't for the 2nd...

--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)

February 6, 2020 at 12:39 am

#3723481
Reply To: STUFF Function use

Steve Collins wrote:

Ha it's the exact same query.

I left out "TYPE" because it was guaranteed to be integer digits and "TYPE" makes things a bit slower over the long haul but,...

--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)

February 5, 2020 at 7:39 pm

#3723428
Reply To: How can we ensure whether database is migrated successfull from DBA Side

To the best of my knowledge, no such scripts exist.

--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)

February 5, 2020 at 2:11 pm

#3723294
Reply To: High CPU utilization due to too much idle sessions on DB instance.

Check to see if the connections being made are using M.A.R.S (Multiple Active Result Sets). Connections are supposed to default to this being off but several of us have found...

--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)

February 5, 2020 at 2:09 pm

#3723293
Reply To: STUFF Function use

Please help us help you... in the future, please post readily consumable data. Please Read'n'Heed the article at the first link for how to help us help you more quickly...

--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)

February 5, 2020 at 2:04 pm

#3723292
Reply To: Conversion Error When Using CASE Statement

Jason A. Long wrote:

Jeffrey Williams wrote:

You should add the money data type to this - it shows that ISNUMERIC recognizes money formats and will convert those correctly.

I did. The 3rd value has a...

--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)

February 4, 2020 at 11:47 pm

#3723135

Viewing 15 posts - 7,786 through 7,800 (of 59,091 total)