Jeff Moden

Forum Replies Created

Viewing 15 posts - 19,786 through 19,800 (of 59,072 total)

RE: Why Use Version Control?

Version control for database is totally useless... right up until the time that you actually need it to undo a mistake without having to call for a backup tape to...
--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)

August 23, 2015 at 12:42 pm

#1821867
RE: sp_cursorprepexec slows down and down through the night

You talked about each cursor being prepared and executed. Have you verified that each one is being closed when completed?
Also, I'd like to recommend that you change these calls...
--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)

August 23, 2015 at 11:47 am

#1821865
RE: What are your five most common T-SQL commands

To be honest, there's only one thing that I type very much and that's BEGIN TRANSACTION. As a DBA, I have pretty much everything else automated. I've even...
--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)

August 22, 2015 at 10:19 pm

#1821851
RE: Fine tuning Queries

ScottPletcher (8/22/2015)
Jeff Moden (8/21/2015)
For too many reasons to explain here, SQL Server really, really likes NOT NULL, UNIQUE, ever increasing, narrow clustered indexes. A date time column can be...
--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)

August 22, 2015 at 12:08 pm

#1821842
RE: Fine tuning Queries

Ed Wagner (8/21/2015)
If you haven't downloaded Grant's book on execution plans, I would do it. It's an excellent book that explains a lot of things and it would give...
--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)

August 22, 2015 at 1:18 am

#1821827
RE: Annual Security Compliance Training

Ed Wagner (8/21/2015)
It's really too bad if the security training is more about legal garbage than about teaching people how to do things properly. Maybe, just maybe, if 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)

August 22, 2015 at 1:11 am

#1821826
RE: Rendering PDFs Natively in SQL

David Rueter (5/9/2013)
I'm always amazed at the number of people that blindly cry "scalability" as some sort of a trump card without understanding the requirements first. Scalability is only one...
--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)

August 21, 2015 at 5:18 pm

#1821815
RE: Nope to NoOps, No way to NoDBA

GoofyGuy (8/21/2015)
The DBA gets to torture and embarrass the app developer. Nothing, but nothing, pleases a DBA more than this.
Not for me. I absolutely love it when code does...
--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)

August 21, 2015 at 5:05 pm

#1821811
RE: Update Statistics & Rebuild index (MaintenancePlan)

lgluna20 (8/21/2015)
Hello
Thanks you very much for your answer
Sorry in case of the questions number 3 I was not clear about it.
Basically as you know SQL Server include Maintenance...
--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)

August 21, 2015 at 4:55 pm

#1821810
RE: Fine tuning Queries

For too many reasons to explain here, SQL Server really, really likes NOT NULL, UNIQUE, ever increasing, narrow clustered indexes. A date time column can be very good 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)

August 21, 2015 at 4:50 pm

#1821809
RE: The Road to Success

Steve Jones - SSC Editor (8/21/2015)
This is why I am pushing unit testing. The things that Tom mentions are true. We don't have huge verification budgets, nor time, and mistakes...
--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)

August 21, 2015 at 10:05 am

#1821756
RE: Annual Security Compliance Training

I agree with THAT kind of training. THAT would be very useful. Since I'm a DBA, I'm considered to fall into 5 different training tracks for my company...
--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)

August 21, 2015 at 7:11 am

#1821674
RE: Annual Security Compliance Training

The "training" is ridiculous for some of us. There needs to be two versions... one for people that don't work with security every day and a MUCH shorter version...
--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)

August 21, 2015 at 7:03 am

#1821669
RE: handling odd date format

Good guess.
--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)

August 21, 2015 at 6:57 am

#1821667
RE: The Road to Success

I'll admit that there are mistakes that make it through to production where I work but they are very few, far between, and usually nearly trivial in nature because we...
--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)

August 20, 2015 at 6:16 pm

#1821569

Viewing 15 posts - 19,786 through 19,800 (of 59,072 total)