Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,176 through 11,190 (of 59,099 total)

RE: Delete Performance: Disable vs Drop constraints

In that case, that's only a little more 600,000 rows per month. Perhaps partitioning by month would help in that you could simply and nearly instantly SWITCH out the oldest...
--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)

September 20, 2018 at 12:22 pm

#2006471
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, September 20, 2018 11:02 AM
She just asked me a very relevant question, what would be her focus...
--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)

September 20, 2018 at 12:08 pm

#2006468
RE: Optimal values for certain metrics

The production does have documentation. Here's the link...
https://library.nagios.com/#_ga=2.8857777.504434982.1537451559-493762336.1537451559&_gac=1.212987168.1537451559.EAIaIQobChMInPrfnd3J3QIVmUsNCh1nMwjfEAAYASAAEgL7IvD_BwE
--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)

September 20, 2018 at 7:55 am

#2006425
RE: Buffer Cache Hit Ratio - PLE

Arsh - Thursday, September 20, 2018 7:20 AM
Grant Fritchey - Thursday, September 20, 2018 5:07 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)

September 20, 2018 at 7:43 am

#2006420
RE: Are the posted questions getting worse?

jonathan.crawford - Wednesday, September 19, 2018 11:27 AM
Eirikur Eiriksson - Wednesday, September 19, 2018 11:26 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)

September 19, 2018 at 5:02 pm

#2006372
RE: Has anyone seen this or have a link about it? (DBCC CHECKIDENT anomaly)

Eirikur Eiriksson - Wednesday, September 19, 2018 10:29 AM
Jeff Moden - Wednesday, September 19, 2018 9:14 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)

September 19, 2018 at 11:08 am

#2006310
RE: Audit In SQL Server

Jeff Moden - Tuesday, September 18, 2018 3:47 PM
Admingod - Monday, September 17, 2018 10:07 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)

September 18, 2018 at 4:05 pm

#2006210
RE: Audit In SQL Server

Admingod - Monday, September 17, 2018 10:07 AM
We don't want to implement this using triggers. This could impact performance.There are lot of...
--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)

September 18, 2018 at 3:47 pm

#2006207
RE: Delete Performance: Disable vs Drop constraints

Lidou123 - Monday, September 17, 2018 11:42 PM
Hello
I'm doing a huge task of deleting data in a large table of 300...
--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)

September 18, 2018 at 3:43 pm

#2006205
RE: Is there a better way to write a simple query?

sgmunson - Monday, September 17, 2018 1:40 PM
thelenj - Monday, September 17, 2018 1:21 PM
--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)

September 18, 2018 at 9:42 am

#2006157
RE: Are the posted questions getting worse?

Eirikur Eiriksson - Tuesday, September 18, 2018 6:33 AM
Grant Fritchey - Tuesday, September 18, 2018 6:04 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)

September 18, 2018 at 7:16 am

#2006114
RE: Can db_ddladmin role permissions be limited to specific tables on a schema?

HookSqlDba7 - Sunday, September 16, 2018 7:53 PM
We are running SQL Server 2012 SP3 on Windows 2008 Server. Members of the db_ddladmin fixed database role...
--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)

September 17, 2018 at 9:36 am

#2005976
RE: Unused Indexes

Arsh - Monday, September 17, 2018 1:53 AM
Jeff Moden - Sunday, September 16, 2018 9: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)

September 17, 2018 at 9:17 am

#2005967
RE: Cost Threshold For Parallelism - Your opinion

coolchaitu - Tuesday, September 11, 2018 7:59 AM
NicHopper - Tuesday, September 11, 2018 7:49 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)

September 16, 2018 at 10:29 pm

#2005911
RE: Dissertation theme in MS SQL Server for a DBA

TomThomson - Sunday, September 16, 2018 4:07 PM
Jeff Moden - Thursday, September 13, 2018 11:44 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)

September 16, 2018 at 10:27 pm

#2005910

Viewing 15 posts - 11,176 through 11,190 (of 59,099 total)