Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,811 through 12,825 (of 59,095 total)

RE: How would you lock down a SQL DBA to have local admin on the SQL box

Perry Whittle - Wednesday, February 28, 2018 7:58 AM
Jeff Moden - Wednesday, February 21, 2018 6:55 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)

February 28, 2018 at 2:36 pm

#1981557
RE: How does SQL Server handle concurrent operations?

It's a 9 year old document but still VERY appropriate for high performance data loads. Please see the following article.
https://technet.microsoft.com/en-us/library/dd425070(v=sql.100).aspx
--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)

February 28, 2018 at 1:40 pm

#1981550
RE: Index Framentation

Perry Whittle - Wednesday, February 28, 2018 6:45 AM
tmmutsetse - Monday, February 5, 2018 6:16 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)

February 28, 2018 at 7:59 am

#1981465
RE: Add Group ID value for set of sequential rows

patrickmcginnis59 10839 - Wednesday, February 28, 2018 6:46 AM
Jeff Moden - Tuesday, February 27, 2018 5:55 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)

February 28, 2018 at 7:48 am

#1981460
RE: Delete 5 lac records from table

VSSGeorge - Saturday, February 24, 2018 10:57 PM
GilaMonster - Friday, February 9, 2018 5:29 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)

February 27, 2018 at 8:10 pm

#1981405
RE: What Counts for a DBA – Inspirations

Part of the reason why I stay in this "business" is the community at large. You and Brent, along with many others both well known and not so well known...
--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)

February 27, 2018 at 8:03 pm

#1981404
RE: sql query to get code with max rank

dk98681 - Tuesday, February 27, 2018 10:36 AM
Any help to figure out this query is highly appreciated.
I have three tables. (Scripts...
--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)

February 27, 2018 at 6:34 pm

#1981392
RE: How does SQL Server handle concurrent operations?

junk.mail291276 - Tuesday, February 27, 2018 4:52 PM
Hello,
We are having an issue which I suspect is database related. We have a web...
--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)

February 27, 2018 at 6:24 pm

#1981391
RE: Add Group ID value for set of sequential rows

drew.allen - Tuesday, February 27, 2018 11:12 AM
Phil Parkin - Tuesday, February 27, 2018 10: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)

February 27, 2018 at 5:55 pm

#1981389
RE: Candidate for partitioned table?

patreddy - Tuesday, February 27, 2018 1:08 PM
I have a table that contains about 8 billion rows. The table has a FK...
--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)

February 27, 2018 at 3:33 pm

#1981382
RE: Are the posted questions getting worse?

jasona.work - Tuesday, February 27, 2018 10:11 AM
GilaMonster - Tuesday, February 27, 2018 9:34 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)

February 27, 2018 at 3:09 pm

#1981378
RE: Audit systems: a good idea or a mess to maintain?

William Rayer - Tuesday, February 27, 2018 4:20 AM
I use a simple approach which works well:
1. Each table being audited should have...
--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)

February 27, 2018 at 7:45 am

#1981284
RE: Max degree of parallelism - Query costs

Although the COST of the query is a decent indicator during troubleshooting, it is just an estimate. The only way to tell if there's really been a change for...
--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)

February 27, 2018 at 7:43 am

#1981283
RE: Need Tutorial on Differential Backup

GilaMonster - Tuesday, February 27, 2018 1:02 AM
Jeff Moden - Monday, February 26, 2018 4:07 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)

February 27, 2018 at 6:52 am

#1981274
RE: What are SHOWPLAN security risks? Should a query optimizer person (not DBA) have access to it?

peter_parker - Monday, February 26, 2018 2:01 PM
Thanks for the replies both. They are both pretty useful and generally my thought process.
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)

February 26, 2018 at 4:13 pm

#1981210

Viewing 15 posts - 12,811 through 12,825 (of 59,095 total)