Jeff Moden

Forum Replies Created

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

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
RE: Julian Date again ...sorry

TomThomson - Sunday, September 16, 2018 5:29 PM
jcelko212 32090 - Sunday, September 16, 2018 1:45 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 16, 2018 at 10:08 pm

#2005909
RE: Selecting Min of multiple values, including an operation

Eirikur Eiriksson - Sunday, September 16, 2018 1:12 AM
The Window(ing) functions perform well when applied to sets of relatively moderate cardinality,...
--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 11:14 am

#2005897
RE: Line and Columns combination

erickegea - Saturday, September 15, 2018 12:32 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 16, 2018 at 11:03 am

#2005896

RE: Unused Indexes

Arsh - Sunday, September 16, 2018 4:31 AM

Thank you Sue . Thank you to you too SQLPirate ; and Yes 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)

September 16, 2018 at 9:54 am

#2005893

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