Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,201 through 10,215 (of 59,099 total)

RE: steps for performance tuning of a sql server

Eirikur Eiriksson - Monday, December 31, 2018 7:13 AM
Few years back, a batch job was taking 17 hours and beefing 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)

December 31, 2018 at 8:32 am

#2017651
RE: Set a Variable Inside a Case Statement

harini_vaidyanath - Monday, December 31, 2018 1:01 AM
Hello Jason and Kingston,
I am working on a similar problem and am looking for your...
--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)

December 31, 2018 at 8:29 am

#2017650
RE: Shrink database only x gig a week.

Eirikur Eiriksson - Monday, December 31, 2018 7:23 AM
Jeff Moden - Monday, December 31, 2018 7:12 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)

December 31, 2018 at 8:23 am

#2017649
RE: WMI connection error using Invoke-Sqlcmd

Sue_H - Friday, December 28, 2018 9:46 AM
Could also be related to the issue in this article - worth taking 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)

December 31, 2018 at 7:55 am

#2017648
RE: Shrink database only x gig a week.

frederico_fonseca - Friday, December 28, 2018 12:40 PM
have a look at my post on https://www.sqlservercentral.com/Forums/1866405/dbcc-shrinkfile?PageIndex=1
by setting @shrink_target to your desired value 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)

December 31, 2018 at 7:12 am

#2017645
RE: steps for performance tuning of a sql server

Steve Jones - SSC Editor - Friday, December 28, 2018 8:26 AM
A poorly performing database will always look like hardware and more...
--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)

December 31, 2018 at 6:57 am

#2017643
RE: Cloning SQL Server Instances with Containers

Great introduction to containers. Thanks for taking the time to post it.
The thing that I don't understand is, considering that it starts out with a restore of 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)

December 31, 2018 at 6:13 am

#2017642
RE: trigger blues no primary key

jcelko212 32090 - Sunday, December 30, 2018 3:59 PM
fizzleme - Thursday, December 27, 2018 11:12 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)

December 31, 2018 at 5:35 am

#2017639
RE: Primary keys for an OLTP database

Eirikur Eiriksson - Sunday, December 30, 2018 10:53 AM
Jeff Moden - Sunday, December 30, 2018 9:45 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)

December 30, 2018 at 1:03 pm

#2017619
RE: Primary keys for an OLTP database

Eirikur Eiriksson - Saturday, December 29, 2018 8:08 AM
My i5-4310U 4 Logical Cores @ 2.00GHz system, 512GB SSD, Microsoft SQL Server...
--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)

December 30, 2018 at 9:45 am

#2017616
RE: Primary keys for an OLTP database

xsevensinzx - Saturday, December 29, 2018 7:11 AM
Jeff Moden - Friday, December 28, 2018 9:24 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)

December 30, 2018 at 9:33 am

#2017615
RE: Primary keys for an OLTP database

Lynn Pettis - Friday, December 28, 2018 2:52 PM
Jeff Moden - Friday, December 28, 2018 9:41 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)

December 28, 2018 at 4:05 pm

#2017568
RE: Suggestions on How to Improve Delete

RGP - Friday, December 28, 2018 8:49 AM
Jeff Moden - Friday, December 28, 2018 7:17 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)

December 28, 2018 at 3:32 pm

#2017564
RE: Primary keys for an OLTP database

steve.homer@gmail.com - Friday, December 28, 2018 6:30 AM
Jeff Moden - Thursday, December 27, 2018 8: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)

December 28, 2018 at 9:41 am

#2017533
RE: Primary keys for an OLTP database

xsevensinzx - Friday, December 28, 2018 8:08 AM
Jeff Moden - Friday, December 28, 2018 7:54 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)

December 28, 2018 at 9:24 am

#2017528

Viewing 15 posts - 10,201 through 10,215 (of 59,099 total)