Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,661 through 9,675 (of 59,091 total)

RE: shrink databases

vsamantha35 - Friday, March 15, 2019 4:47 AM
ALZDBA - Tuesday, March 12, 2019 4:50 AM
--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)

March 16, 2019 at 11:13 am

#2024701
RE: shrink databases

NorthernSoul - Friday, March 15, 2019 4:53 AM
vsamantha35 - Friday, March 15, 2019 4:47 AM
--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)

March 16, 2019 at 11:08 am

#2024700
RE: shrink databases

ALZDBA - Tuesday, March 12, 2019 4:50 AM
Shrink file is the better choice because of its scope
Keep in mind you need 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)

March 16, 2019 at 11:08 am

#2024699
RE: Recreating sane index not improve the performance

jkramprakash - Saturday, March 16, 2019 12:29 AM
I have five indexes and i dropped the indexes one by one which is 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)

March 16, 2019 at 11:05 am

#2024698
RE: Difference in checksum calculations.

Eirikur Eiriksson - Saturday, March 16, 2019 8:10 AM
Siva Ramasamy - Wednesday, March 13, 2019 11:33 AM
--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)

March 16, 2019 at 10:42 am

#2024696
RE: Removing tempdb files

Steve Jones - SSC Editor - Friday, March 15, 2019 9:36 AM
It's the best answer. Clearing the system of a workload is...
--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)

March 16, 2019 at 10:37 am

#2024695
RE: Dealing with Technical Debt

David.Poole - Saturday, March 16, 2019 4:25 AM
For me technical debt is putting in place something that will be a pain point...
--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)

March 16, 2019 at 9:02 am

#2024694
RE: How Long is Too Long?

David.Poole - Saturday, March 16, 2019 4:08 AM
Many speakers are volunteers. Putting together a quality presentation takes time and effort that is...
--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)

March 16, 2019 at 8:43 am

#2024693
RE: Date Range Consolidation Query

It's an older article but still one of the best ways to do such a thing as you ask. Please see the following...
https://blogs.solidq.com/en/sqlserver/packing-intervals/
--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)

March 15, 2019 at 6:52 pm

#2024673
RE: Dealing with Technical Debt

Steve Jones - SSC Editor - Friday, March 15, 2019 9:39 AM
Jeff Moden - Thursday, March 14,...
--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)

March 15, 2019 at 4:43 pm

#2024671
RE: Dealing with Technical Debt

xsevensinzx - Thursday, March 14, 2019 11:15 PM
It's often hard to do it right the first time. A lot of the large...
--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)

March 15, 2019 at 4:33 pm

#2024670
RE: Sql Query to find invalid SSN Numbers

Lynn Pettis - Friday, March 15, 2019 8:32 AM
roger.plowman - Friday, March 15, 2019 6:50 AM
--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)

March 15, 2019 at 9:35 am

#2024597
RE: How Long is Too Long?

As with all else concerning SQL Server, "It Depends". Some subjects can be adequately covered in a lightning round in only 10 or 15 minutes. Sometimes, even shorter. Other's aren't...
--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)

March 15, 2019 at 7:33 am

#2024563
RE: Removing tempdb files

frederico_fonseca - Friday, March 15, 2019 5:00 AM
Steve does mention the constraint on the answer "Note, if the file is not empty,...
--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)

March 15, 2019 at 6:54 am

#2024555
RE: Removing tempdb files

It'll be interesting to see how people answer this one because the correct answer won't actually work on a busy system because the file will not be empty.
--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)

March 14, 2019 at 11:56 pm

#2024530

Viewing 15 posts - 9,661 through 9,675 (of 59,091 total)