Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,401 through 8,415 (of 59,072 total)

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
Reply To: Using OFFSET for Paging

rick-1071254 wrote:
Jeff -
There are other options out there. Databases that use multi-version read consistency do exactly what you are asking - present an accurate picture of the state of 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)

November 4, 2019 at 3:14 pm

#3694349
Reply To: Using OFFSET for Paging

I know this sounds obvious, so apologies if it is for whomever reads this. I just wanted to say it out loud if it's not obvious...
This reminds me of 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)

November 4, 2019 at 2:38 pm

#3694338
Reply To: Jr vs Sr Developer

ben.brugman wrote:
**) Management can often have unsolvable request, 'like draw seven perpendicular lines'. A senior should be able to stand up 'against' management for this type of request.
I love 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)

November 4, 2019 at 1:39 pm

#3694305
Reply To: Replicating to a Temporal Table

richard.gardner87 wrote:
Our problem is that our ERP is ancient, there is no primary key between the sales header and line tables, there is no timestamp on the sales line table,...
--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 1:29 pm

#3694298

Viewing 15 posts - 8,401 through 8,415 (of 59,072 total)