Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,801 through 7,815 (of 59,098 total)

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
Reply To: SpinOff: Recruitment Question

Jeffery Williams wrote:

oogibah You have GOT to be kidding me.

Are you saying that you ran into a SQL dev that could not produce the current date/time let alone datepart?

#Scary

AND A DBA...

--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:34 pm

#3723133
Reply To: Bulk loading data using For Loop container with variable number

JimReeves71 wrote:

Hi there

I am developing an SSIS package to bulk load data. Now the data can be high in volume (300,000 to 2 million records)

What i want to design 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)

February 4, 2020 at 11:31 pm

#3723132
Reply To: Conversion Error When Using CASE Statement

It'll also say that ',,,,,,,,,,,' is a valid numeric. And the cool part about converting to MONEY during imports (if you don't need more than 4 decimal places) is that...

--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:13 pm

#3723128
Reply To: Scientific number in varchar column

MVDBA (Mike Vessey) wrote:

x wrote:

MVDBA (Mike Vessey) wrote:

Phil Parkin wrote:

MVDBA (Mike Vessey) wrote:

JEFF Do NOT go all SSIS on me 🙂 we all know it's Bulk insert with a formatfile or openrowset

Jeff's blood pressure just went up...

--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 2:41 am

#3722805
Reply To: SQL Account cannot see the user database

Ed7 wrote:

I have inheritance SQL Server environment where the Server team, etc wanted to be System Admin on the SQL Server.

They might perform some upgrade.

And, I found the work-around.

https://support.microsoft.com/en-us/help/2163980/fix-the-sql-server-service-cannot-start-after-you-install-cumulative-u

That link...

--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 2:30 am

#3722804
Reply To: Scientific number in varchar column

GrassHopper wrote:

Jeff, that would be the best case scenario, but we get many clients that give to us as is and don't want to do more. It is in excel...

--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 2:25 am

#3722803
Reply To: Very large t-log with backups

Wow. Just WOW! Thanks for the feedback on what you found, Greg.

--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 2:16 am

#3722802
Reply To: SQL Account cannot see the user database

Ed7 wrote:

Someone create a SQL Login and grant DBO permission to a user database "AppDB1".

I apologize for asking such an obvious question but have you actually verified that happened correctly? ...

--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 3, 2020 at 3:08 pm

#3722632

Viewing 15 posts - 7,801 through 7,815 (of 59,098 total)