Jeff Moden

Forum Replies Created

Viewing 15 posts - 8,431 through 8,445 (of 59,098 total)

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

peter.row wrote:
We will soon be able to drop support for SQL 2008R2 from our product making SQL 2014 the minimum...
I strongly recommend that you upgrade that to the latest 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 1:24 pm

#3694296
Reply To: The Top Ten Percent

I wonder why you specifically mentioned 2017. It works the same in all versions from 2005 and 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)

November 4, 2019 at 4:19 am

#3694182
Reply To: SQL Compression

GrassHopper wrote:
I have a database with no compression on the tables(source). I want to create a blank database(destination) where I can create the tables with "data_compression = Page" and then...
--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:37 am

#3694177
Reply To: Jr vs Sr Developer

CoolKid40 wrote:
Whats diff of job tasks between junior developer and senior sql developer u all would say? Thanks
Thom is mostly right in that "It Depends" on the company but let...
--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 3, 2019 at 5:56 pm

#3694151

Viewing 15 posts - 8,431 through 8,445 (of 59,098 total)