Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,711 through 13,725 (of 59,101 total)

RE: Start Fixing Your DB with Better Code

RonKyle - Thursday, November 16, 2017 7:27 AM
No-one sets out to do a crap job. Most people want to do...
--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)

November 16, 2017 at 7:40 am

#1968351
RE: Start Fixing Your DB with Better Code

cmick 77911 - Thursday, November 16, 2017 7:19 AM
But how do you know if your code is right or wrong when 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)

November 16, 2017 at 7:30 am

#1968345
RE: Interesting Datenames

Jason A. Long - Wednesday, November 15, 2017 4:33 PM
Jeff Moden - Wednesday, November 15, 2017 3:20...
--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)

November 15, 2017 at 11:35 pm

#1968316
RE: Trying to convert a int @variable to a varchar @variable with leading zero.

Jocar26 - Wednesday, November 15, 2017 8:38 PM
I am trying to create a text variable called @varnumber with a leading zero 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)

November 15, 2017 at 10:19 pm

#1968314
RE: Start Fixing Your DB with Better Code

If you know the product you're working with, you will always save some time doing it right the first time. If you don't know the product you're working with VERY...
--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)

November 15, 2017 at 10:12 pm

#1968313
RE: Are the posted questions getting worse?

Sioban Krzywicki - Wednesday, November 15, 2017 1:25 PM
They say it is scalability and rapid development.
I believe it is because someone heard...
--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)

November 15, 2017 at 9:43 pm

#1968312
RE: Should this index be clustered?

Luis Cazares - Tuesday, November 14, 2017 10:51 AM
I have a table that is heavily used which inserts and deletes rows frequently...
--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)

November 15, 2017 at 7:56 pm

#1968310
RE: Interesting Datenames

Jason A. Long - Wednesday, November 15, 2017 1:27 PM
Jeff Moden - Wednesday, November 15, 2017 11:50...
--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)

November 15, 2017 at 3:20 pm

#1968298
RE: Interesting Datenames

Chris Harshman - Wednesday, November 15, 2017 2:13 PM
Jeff Moden - Wednesday, November 15, 2017 11:50 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)

November 15, 2017 at 3:19 pm

#1968296
RE: Are the posted questions getting worse?

Sioban Krzywicki - Wednesday, November 15, 2017 11:41 AM
Hi everyone,
It has been awhile since I posted here and I hope you're all...
--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)

November 15, 2017 at 12:24 pm

#1968257
RE: Interesting Datenames

Mighty - Wednesday, November 15, 2017 11:27 AM
Ed Wagner - Wednesday, November 15, 2017 9:22 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)

November 15, 2017 at 11:50 am

#1968249
RE: A way to restaure backup skipping some filegroups...

@Johan,
Are the filegroups you're talking about part of a "Paritioned Table"?
--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)

November 15, 2017 at 9:09 am

#1968210
RE: What is the best ways of storing unstructured data in sql server 2016, except filestream.

Rather than storing the large data in the database and if you don't want to use filestream, the simply store the directory/path information of where the files are stored on...
--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)

November 15, 2017 at 9:07 am

#1968209
RE: Creating a PDF from a Stored Procedure

jairamkumar01 - Wednesday, November 15, 2017 12:44 AM
I used this procedure it is good, but according to my requirement for text formatting...
--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)

November 15, 2017 at 6:30 am

#1968171
RE: Does Anyone know how you can copy values from a previous row into a null column in SSIS

sgmunson - Tuesday, November 14, 2017 8:52 AM
Jeff Moden - Friday, November 10, 2017 5: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)

November 14, 2017 at 12:51 pm

#1968076

Viewing 15 posts - 13,711 through 13,725 (of 59,101 total)