Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,141 through 4,155 (of 59,087 total)

Reply To: My New Resolution

Rune Bivrin wrote:
Easy enough. But I would personally assign whoever created that table with DATETIME instead of DATE to toilet cleaing duty for a week...
"It Depends". I can see someone designing...
--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)

January 3, 2022 at 11:57 pm

#3969483
Reply To: Multiple Date rows into One single Date row(date range)

Getting back to your second output, what exactly is it that determines if the entries are contiguous? Does a contiguous period always start with a comp code of 301? 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)

January 3, 2022 at 5:06 pm

#3969388
Reply To: Multiple Date rows into One single Date row(date range)

The pictures are very helpful for understanding but it would also be extremely helpful if you included readily consumable data. Please see the first link in my signature line below...
--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)

January 3, 2022 at 4:56 pm

#3969381
Reply To: Get Data from Internet Directly into SQL Server

pietlinden wrote:
It looks like you can now use PowerQuery as a source in SSIS. The nice thing is that Excel can write PowerQuery for you - all you have 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)

January 3, 2022 at 4:48 pm

#3969379
Reply To: My New Resolution

Heh.. I get an "Error: This question has no body." when I click on the link in the post above. Was the resolution to not post any more QOD's? 😀
--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)

January 3, 2022 at 1:47 am

#3969157
Reply To: Best Option for Working with Files in SSIS

It's a direct quote from here...
https://docs.microsoft.com/en-us/sql/integration-services/ssis-how-to-create-an-etl-package?view=sql-server-ver15#what-is-sql-server-integration-services-ssis
Must be a spammer setting 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)

January 1, 2022 at 5:54 pm

#3968925
Reply To: How to write loop below with best practice performance ?

x wrote:
Jeff Moden wrote:
Hold the phone here... inserting 5000, 10000, 15000 rows isn't a large, time consuming task for SQL Server. Why do you think you need to "chunk" the data...
--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)

January 1, 2022 at 3:41 am

#3968855
Reply To: BCP adding carriage return/new line every 2034 characters

timbroadaway wrote:
Thanks for the reply. I do use -c. However, that is what is interesting. When I run the query manually in SSMS, the output is all on one single...
--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)

December 31, 2021 at 4:05 am

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

Lordy... CodeProject just published a very interesting AI incident. Here's the link they published. Pretty spooky and seriously concerning stuff, IMHO. Watch your kids, folks.
https://www.bbc.com/news/technology-59810383

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

December 30, 2021 at 1:30 am

#3968287
Reply To: Encrypting SQL 2012

Heh... smells like another prelude to SPAM. For example, why would anyone in their right mind migrate a decade old version of SQL Server to brand new hardware?
--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)

December 28, 2021 at 6:32 pm

#3967922
Reply To: Managed Instance disaster recovery

Heh... <sarcasm = on> It's a "managed instance"... there shouldn't be any disasters, right? <sarcasm = off>
Considering the differences of the cloud providers and the different plans they all have,...
--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)

December 28, 2021 at 5:36 pm

#3967903
Reply To: can i use any function or another thing instead of stuff ?

I want to know why you want to avoid STUFF. What is the reason for such avoidance?
And as several have stated, STRING_AGG() didn't come out until 2017. If you really...
--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)

December 28, 2021 at 6:28 am

#3967712
Reply To: How do I stop websites listing my mobile phone number?

Yeah... that "Do Not Call" registry doesn't work. People and companies basically ignore 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)

December 27, 2021 at 9:03 pm

#3967606
Reply To: Loading x number of CSV files into x number of unique tables of a database

I sent you a PM here on the SSC site. YOU NEED TO READ IT NOW!
--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)

December 27, 2021 at 8:55 pm

#3967601
Reply To: Amazon Redshift

Heh... one of the companies I do work for insisted that they wanted to move their heavy import, validation, and distribution system to Red Shift. I asked "Why"? They said...
--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)

December 27, 2021 at 5:30 am

#3967399

Viewing 15 posts - 4,141 through 4,155 (of 59,087 total)