Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,981 through 13,995 (of 59,101 total)

RE: Parameter Sniffing In Action

I like short "spackle" articles like this. Good job.
My only suggestion is that people like to run the code you've included in your article. Instead of using...
--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)

October 23, 2017 at 10:01 pm

#1964898
RE: backup to MSSQL 2012 from mssql 2016

Edvard KorsbÃ¦k - Monday, October 23, 2017 1:00 PM
T H A N K S!
It's horribly slow because every row is a single...
--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)

October 23, 2017 at 8:17 pm

#1964893
RE: How Long Before Your Database Runs Out of Space?

And, yes, I realize this article is from last year but it's new to me. Nice job, John.
--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)

October 23, 2017 at 8:10 pm

#1964892
RE: How Long Before Your Database Runs Out of Space?

Joe O'Connor - Friday, May 12, 2017 5:53 AM
SQLBlimp - Wednesday, June 8, 2016 10:23 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)

October 23, 2017 at 8:07 pm

#1964891
RE: How Long Before Your Database Runs Out of Space?

robert.nimstroem - Thursday, June 9, 2016 12:26 AM
Nice.But you should also inform people looking at this that the user running this script...
--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)

October 23, 2017 at 8:05 pm

#1964890
RE: Database design to handle Millions of records

ScottPletcher - Monday, October 23, 2017 4:19 PM
TheSQLGuru - Monday, October 23, 2017 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)

October 23, 2017 at 5:58 pm

#1964888
RE: Making Indexes Invisble to the Optimiser

p.s. And I absolutely understand your stance and reasoning when it comes to the absolute dribble that some call "code". 😉
--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)

October 23, 2017 at 5:49 pm

#1964887
RE: Making Indexes Invisble to the Optimiser

For what it's worth, I absolutely agree that the use of index hints should generally be an absolute last resort and then you should still go back and see what...
--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)

October 23, 2017 at 5:45 pm

#1964886
RE: Database design to handle Millions of records

ScottPletcher - Monday, October 23, 2017 8:02 AM
sgmunson - Monday, October 23, 2017 7:56 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)

October 23, 2017 at 4:14 pm

#1964874
RE: Session Scope with Temporary Tables and Dynamic SQL

souLTower - Monday, October 23, 2017 11:07 AM
Actually, I don't need the global temp tables because I want them to be specific...
--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)

October 23, 2017 at 3:24 pm

#1964870
RE: Challenging string handling in T-SQL

drew.allen - Monday, October 23, 2017 9:11 AM
T-SQL is horrible at string manipulation. Your best option is to use SQLCLR.
You also need...
--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)

October 23, 2017 at 3:17 pm

#1964867
RE: Challenging string handling in T-SQL

Naveen J V - Monday, October 23, 2017 12:03 AM
Hello Experts,
I have a data in a table as shown in the...
--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)

October 23, 2017 at 3:16 pm

#1964865
RE: Trying to speed up this 'GetWorkingDays' function.

Jason A. Long - Sunday, October 22, 2017 2:17 PM
Ahhhhhh you're killing me!!! I was really hoping you'd hold off until...
--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)

October 23, 2017 at 8:28 am

#1964791
RE: Database design to handle Millions of records

It always comes to that. "and worry about performance later". While I whole heartedly agree that the logical model must come first, I find that the only time that many...
--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)

October 22, 2017 at 9:48 pm

#1964726
RE: tsql help

Alan.B - Wednesday, October 4, 2017 11:37 PM
sgmunson - Wednesday, October 4, 2017 6:19 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)

October 22, 2017 at 9:30 pm

#1964725

Viewing 15 posts - 13,981 through 13,995 (of 59,101 total)