Jeff Moden

Forum Replies Created

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

Reply To: Are the posted questions getting worse?

jasona.work wrote:
Jeff Moden wrote:
Major congrats on the "term" to "perm" thing. They should rename the "term" position to "Damocles".
As for migrating SSIS packages, I've discovered a sure fire way to not...
--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 9, 2019 at 3:51 pm

#3696482
Reply To: Replication help

jpnorman103 wrote:
Hi all,
I'm fairly new to the dba side of things, and wondered if you could give me some pointers as to a possible solution to an issue that's occurred...
--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 9, 2019 at 3:35 pm

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

Mohamed I. wrote:
Hi
Thank you for your compliment
This will encourage me writing more article 🙂
It's good question about performance in large dataset when using recursive group
It will be nice to make some...
--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 9, 2019 at 3:33 pm

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

p.s. The questions I asked above (and possibly more) would be the kind of questions (obviously not identical because there were no deletes) that I would have asked an interviewer...
--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 9, 2019 at 3:21 pm

#3696479
Reply To: T-SQL query to get the latest available backup chain

ScottPletcher wrote:
Jeff Moden wrote:
Estimating the space requirement for database restores from the backup size can be really misleading. One of the largest problems in this area is that free space in...
--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 8, 2019 at 10:12 pm

#3696411
Reply To: T-SQL query to get the latest available backup chain

This is a nice script and I thank you for taking the time to post it.
Just a couple of thoughts, though. Your article states...
This query can be helpful for knowing...
--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 8, 2019 at 4:13 pm

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

jasona.work wrote:
Well, I'm becoming a happier camper...
Sunday I officially flip from being a "Term" appointment (and thus needing to essentially compete for my job every couple years,) to a "Perm"...
--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:54 pm

#3696134
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

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