Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,271 through 9,285 (of 59,102 total)

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
Reply To: Unable to stop SQL Server Agent Job showing "In Progress" status

Considering that you posted this in the SQL Server 7/2000 forum and you clearly state that you're using 2014 and an SSIS package (and SSIS didn't even exist in 7/2000),...
--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:12 pm

#3645125
Reply To: Fetching unique record within a stored procedure

Yes. Use a column that has the IDENTITY property and, if you need to know what value the IDENTITY proper assigned during an INSERT of a new row, use 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)

May 19, 2019 at 1:33 pm

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

In place migration or migration to a new server?
Any partitioned tables?
--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 18, 2019 at 1:33 pm

#3644984
Reply To: The SQL Saturday Thread

Ok... first of all, the SQL Saturday in Colorado Springs was a blast and it was absolutely fantastic to finally meet Lynn Pettis. We've been friends and fellow SQL warriors...
--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 17, 2019 at 7:32 pm

#3644774

Viewing 15 posts - 9,271 through 9,285 (of 59,102 total)