Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,416 through 8,430 (of 59,091 total)

Reply To: Error: Cannot insert duplicate key row in... a non-unique index?!

ScottPletcher wrote:
Otoh, why are you specifying a column as a key that needs updated??
Missed this before... + 1 Billion!!!
--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)

November 7, 2019 at 11:40 pm

#3696132
Reply To: Error: Cannot insert duplicate key row in... a non-unique index?!

I ran code that Paul posted on the Azure Feedback. While I understand the angst there and a lot of people will argue with me about it, I would attribute...
--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)

November 7, 2019 at 11:35 pm

#3696131
Reply To: How to Insert million of records into a table?

Kev Wisbey-443237 wrote:
Re Jeffs comment Did the identify any limits or extenuating circumstances?
I was tasked with importing over 15000000 rows of data, first having to delete a massive amount of existing...
--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)

November 7, 2019 at 10:52 pm

#3696117
Reply To: How to Insert million of records into a table?

And... was that all there was to the question? Did they identify the source of the data? Did the identify any limits or extenuating circumstances?
Better than that, did you 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)

November 6, 2019 at 9:40 pm

#3695578
Reply To: Managing Recursive Group on SSRS Reporting Services Reports

Hat's off to you. I don't use SSRS but this looks like a really well thought out article with the correct order of revelation and all the right screen shots.
The...
--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)

November 5, 2019 at 7:44 pm

#3695236
Reply To: Tempdb best configuration

Alejandro Santana wrote:
To add something,
Its recommended to have all the tempdb data files the same size, that's why Microsoft have added a feature in which not only one file but all...
--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)

November 5, 2019 at 7:38 pm

#3695233
Reply To: last day of the month minus 1 day

Agreed on both the addition you made for the bullet proofing and, considering the situation, going incognito. Heh... I dare not go incognito... it would remove some self-imposed limits 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)

November 4, 2019 at 11:30 pm

#3694527
Reply To: Run query across 100\'s of servers in 1 go to set up a process

x wrote:
If you DO actually have 100's of servers you need to do this to, then you actually do need some help because if you do actually land or build...
--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)

November 4, 2019 at 10:57 pm

#3694522
Reply To: last day of the month minus 1 day

below86 wrote:
Jeff Moden wrote:
I guess I don't understand why anyone would write software based on the knowledge of novices. If it's important for a novice to be able to maintain something...
--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)

November 4, 2019 at 9:16 pm

#3694493
Reply To: Performance of table-valued functions

I don't understand why anyone would use a CLR function for such a thing to begin with. Is the CLR getting the ISO data from some URL or 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)

November 4, 2019 at 8:51 pm

#3694484
Reply To: Synchronizing data between 2 databases

hurricaneDBA wrote:
Hi Jeff
So you can do this across different sql versions because we are migrating / upgrading from sql server 2012 (production) to sql server 2016 (new server)?
you can apply...
--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)

November 4, 2019 at 7:05 pm

#3694461
Reply To: Synchronizing data between 2 databases
Here's the way I've done such a thing many times now...
1. Obviously, prep the new box with all that's necessary including DB settings, logins, linked servers, etc, etc.
2. As the...
--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)
November 4, 2019 at 4:35 pm

#3694424
Reply To: Re-attaching database and the case of the disappearing transaction log file
MVDBA (Mike Vessey) wrote:
what happened to good old fashioned command prompt tools
dir /s *.ldf
none of this fancy SQL malarkey 🙂
Heh... I love it! No PoSh required, either.
--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)
November 4, 2019 at 4:18 pm

#3694411
Reply To: How to generate a CSV listing of all objects in a database

I agree that sys.objects is a good source for the brunt of what you're looking for. Unfortunately, it doesn't cover everything. For example, indexes, statistics, and partitions aren't covered by...
--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)

November 4, 2019 at 4:12 pm

#3694409
Reply To: Using OFFSET for Paging

dmbaker wrote:
You're spot-on I think. Paging (or other remote options, sorting, filtering. etc.), however it's accomplished, should not be used without consideration for the issues it brings (especially potential inconsistency,...
--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)

November 4, 2019 at 3:39 pm

#3694393

Viewing 15 posts - 8,416 through 8,430 (of 59,091 total)