Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,256 through 9,270 (of 59,091 total)

Reply To: The Datatimeoffset Value

Ya know... this finally eliminated the confusion I had with this function (mostly because I don't use it but might have better reason to now). Thanks Steve.
--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)

May 21, 2019 at 3:13 am

#3645600
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

Was it actually due to the partitioning itself or was it because of the preparations (and related indexes) that were actually the key? I'm asking because in that thread I...
--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)

May 20, 2019 at 10:09 pm

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

Grant Fritchey wrote:
Jeff Moden wrote:
You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will...
--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)

May 20, 2019 at 6:48 pm

#3645508
Reply To: Why Tools Can Help You Do Your Job

Kathi Kellenberger wrote:
If you don't use the tools correctly, then there is probably not much chance you are working correctly without them either, I guess.
The problem is that a whole lot...
--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)

May 20, 2019 at 3:06 pm

#3645420
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

If I'm reading you correctly, I totally agree. SWITCH is a great reason to partition. That's not the "performance" thing that most folks talk about and that I tend to...
--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)

May 20, 2019 at 2:07 pm

#3645380
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

That pretty much supports what I've found. It's actually people finally paying attention to the data and doing some decent indexing that makes the code run faster. Because they're finally...
--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)

May 20, 2019 at 1:52 pm

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

Brandie Tarvin wrote:
And posting powerpoint slides is kinda worthless if one subscribes to the belief that powerpoint should supplement the presentation, not contain the presentation.
I subscribe to "It Depends". If it'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)

May 20, 2019 at 12:26 pm

#3645333
Reply To: Restore DB

Then, restore all the main BAK and all the existing TRN files to the new server but make sure that ALL of those restores, including the last one, ALL use...
--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)

May 20, 2019 at 12:21 pm

#3645332
Reply To: Sorting out .NDF files

Hold the phone a minute. Have you determined WHY the NDF files exist? If they're associated with partitioning, you absolutely DO NOT WANT TO MAKE THEM THE SAME SIZE. 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)

May 20, 2019 at 12:14 pm

#3645326
Reply To: Converting Substring to DateTime - extra eyes please

Brandie Tarvin wrote:
What is msdb.dbo.agent_datetime? There is no such table in my environment.
It's the function MS built into the system to convert the integer dates and times that are listed 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)

May 20, 2019 at 12:03 pm

#3645319
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

Soooo.... it wasn't actually the partitioning but column store that made the improvement?
--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)

May 20, 2019 at 12:00 pm

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

You've been given a gift... when most folks write a presentation, they practice it at say 20 minutes but they've included so much good stuff that it will actually take...
--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)

May 20, 2019 at 11:53 am

#3645292
Reply To: Why Tools Can Help You Do Your Job

I have mixed reactions when it come to 3rd party tools. They're a great thing to have but I find they make people a fair bit lazy about learning unless...
--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)

May 20, 2019 at 2:52 am

#3645207
Reply To: Migrating from (mostly) 2K8 to 2016

Since this is a huge subject and you don't yet know the lay of the land, see the following. You should read it (especially about the migration assistant) even before...
--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)

May 19, 2019 at 3:13 pm

#3645128
Reply To: DML performance : Unpartioned Table with Index vs Partitioned table with Index

I may be an exception because of my limited use of partitioning (couple of serious tests for a couple of forum posts a long time ago and a 1TB call...
--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)

May 19, 2019 at 2:56 pm

#3645127

Viewing 15 posts - 9,256 through 9,270 (of 59,091 total)