Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,221 through 11,235 (of 59,102 total)

RE: Why such a big log size?

To add to what Lynn correctly stated, there's a hidden overhead that most people don't even know about and those are the effects of "Bad" page splits on the log...
--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 13, 2018 at 8:40 am

#2005609
RE: Are the posted questions getting worse?

Shifting gears to TRY/CATCH, I think that the way a lot of people use it is wrong, especially in the presence of SET XACT_ABORT ON. Might be worth an article...
--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 13, 2018 at 8:23 am

#2005602
RE: Are the posted questions getting worse?

Understood on all of that but it is a tool and if you ever need it, you would like it to be available.
I will admit that I've...
--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 13, 2018 at 8:21 am

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

Grant Fritchey - Thursday, September 13, 2018 6:10 AM
I'd suggest focusing primarily in the area of DevOps. Automation as administration or administration...
--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 13, 2018 at 7:04 am

#2005578
RE: How do I write a record for each day in a date range???

andycadley - Thursday, September 13, 2018 12:47 AM
I just wish they'd sort the performance differential between the new and old types,...
--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 13, 2018 at 6:59 am

#2005576
RE: Are the posted questions getting worse?

andycadley - Thursday, September 13, 2018 12:53 AM
Lynn Pettis - Wednesday, September 12, 2018 3:56 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 13, 2018 at 6:50 am

#2005573
RE: Coming down on bad users - WWYD ?

JaybeeSQL - Wednesday, September 12, 2018 1:04 PM
Well you yelled first, so there, na-na-na !! 🙂
But...
--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 12, 2018 at 2:05 pm

#2005501
RE: Coming down on bad users - WWYD ?

logitestus - Wednesday, September 12, 2018 8:19 AM
Jeff Moden - Wednesday, September 12, 2018 7:51 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 12, 2018 at 2:04 pm

#2005500
RE: Hide schema from all users (except people with SA access)

richardmgreen1 - Wednesday, September 12, 2018 7:41 AM
Jeff Moden - Wednesday, September 12, 2018 7:36 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 12, 2018 at 8:18 am

#2005429
RE: Dynamic creating indexes

Sababa - Tuesday, September 11, 2018 9:26 AM
You're completely right, but it's not under our control.
Unfortunately, we have a common...
--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 12, 2018 at 8:06 am

#2005428
RE: Coming down on bad users - WWYD ?

xsevensinzx - Wednesday, September 12, 2018 6:17 AM
What would I do? I mean, if I'm truly accountable, I likely would educate them...
--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 12, 2018 at 7:51 am

#2005419
RE: Hide schema from all users (except people with SA access)

Just to understand here, the purpose of the schema you're trying to hide is so you can export data to files? Is that correct?
--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 12, 2018 at 7:36 am

#2005410
RE: How do I write a record for each day in a date range???

Steve Jones - SSC Editor - Tuesday, September 11, 2018 12:05 PM
Thom A - Monday, September 10,...
--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 11, 2018 at 9:30 pm

#2005357
RE: Easiest way to create a copy of a database with partitioned tables

Marius.D - Tuesday, September 11, 2018 9:56 AM
Hello, I was wondering, is restoring AS new database from a backup the easiest/ fastest...
--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 11, 2018 at 10:21 am

#2005267
RE: Allowing developers ability to administer SQL Agent jobs in production

TomThomson - Monday, September 10, 2018 3:05 PM
Jeff Moden - Sunday, September 9, 2018 10:03 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 11, 2018 at 9:10 am

#2005257

Viewing 15 posts - 11,221 through 11,235 (of 59,102 total)