Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,156 through 4,170 (of 59,098 total)

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
Reply To: Date Calendar

Sean Smith wrote:
ALTER INDEX ALL ON dbo.date_calendar REBUILD;
😉 Happy holidays everyone! 🙂
The other indexes weren't fragmented so no need to rebuild all the indexes. That's expensive even on such a small...
--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 26, 2021 at 12:56 am

#3967220
Reply To: Date Calendar
Here's what everyone seems to forget when downloading and using such code... 😉
```
--===== Check for Fragmentation on the Clustered Index
 SELECT  avg_fragmentation_in_percent
    ...
```
--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 25, 2021 at 12:02 am

#3967098
Reply To: Need help resolving a SET based Query where I have hardcoded values

A lot of the department stores in the U.S. used to have a special "shop" in the store that would do that... sometimes, for free.
--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 24, 2021 at 7:33 pm

#3967076
Reply To: Need help resolving a SET based Query where I have hardcoded values

Glad it helped. You helped a lot by posting readily consumable data. Makes our "job" a whole lot easier and enjoyable.
--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 24, 2021 at 12:37 am

#3966865

Viewing 15 posts - 4,156 through 4,170 (of 59,098 total)