Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,546 through 10,560 (of 59,099 total)

RE: Inner joins

drew.allen - Wednesday, November 21, 2018 11:33 AM
Jeff Moden - Wednesday, November 21, 2018 9:06 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 21, 2018 at 1:03 pm

#2014285
RE: Getting the main course right

Heh... STUFFing on steroids!
For those in the U.S.A, have a great Thanks Giving! Everyone else... have a great weekend when it starts.
And, Steve, thanks 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 21, 2018 at 10:47 am

#2014270
RE: Cursors are not supported on a table which has a clustered columnstore index

Michael L John - Wednesday, November 21, 2018 9:01 AM
irehman - Wednesday, November 21, 2018 8:57 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 21, 2018 at 10:41 am

#2014269
RE: Index and Search help

ScottPletcher - Wednesday, November 21, 2018 10:05 AM
Jonathan AC Roberts - Wednesday, November 21, 2018 8:32 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 21, 2018 at 10:31 am

#2014268
RE: Inner joins

ScottPletcher - Monday, November 19, 2018 11:57 AM
MS will probably get rid of the old-style joins at some point, but it will...
--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 21, 2018 at 9:06 am

#2014243
RE: How to study the layout of a database?

patrickmcginnis59 10839 - Wednesday, November 21, 2018 6:47 AM
frederico_fonseca - Tuesday, November 20, 2018 12:43 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 21, 2018 at 8:35 am

#2014229
RE: Index and Search help

Jonathan AC Roberts - Wednesday, November 21, 2018 6:32 AM
Jeff Moden - Tuesday, November 20, 2018 9:00...
--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 21, 2018 at 8:00 am

#2014223
RE: Another Reason to Care About Security

From the article:
I also know that consumers can be emotional and look to leave a service, like a mobile phone provider, after a breach, to move 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)

November 20, 2018 at 9:37 pm

#2014177
RE: Natural Sort Order

Jason A. Long - Tuesday, November 20, 2018 1:16 PM
Jeff Moden - Tuesday, November 20, 2018 7:31...
--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 20, 2018 at 9:19 pm

#2014176
RE: Index and Search help

In order to keep the searches for the other columns nasty fast, you should set the table option (using sp_tableoption) to store the LOBs (description column) out of row.
As...
--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 20, 2018 at 9:00 pm

#2014175
RE: How to study the layout of a database?

jcelko212 32090 - Tuesday, November 20, 2018 10:28 AM
ben.brugman - Tuesday, November 20, 2018 5:26 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 20, 2018 at 10:39 am

#2014119
RE: Exif data into a database.

ben.brugman - Tuesday, November 20, 2018 7:41 AM
Hello All,
With the ExifTool by Phil Harvey I make a number of .CSV files from...
--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 20, 2018 at 8:10 am

#2014101
RE: Natural Sort Order

Jason A. Long - Monday, November 19, 2018 11:09 PM
Jeff Moden - Monday, November 19, 2018 8:44...
--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 20, 2018 at 7:31 am

#2014095
RE: Natural Sort Order

Have a look at the functions that was a team effort at the following link.
http://www.sqlservercentral.com/scripts/String+Function/141686/
The "DigitsOnlyEE" function was actually developed on a different thread. Big...
--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 19, 2018 at 8:44 pm

#2014063
RE: Natural Sort Order

peter.aylett - Monday, November 19, 2018 4:10 PM
Microsoft have said over here on the Azure feedback portal that they'll add...
--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 19, 2018 at 8:20 pm

#2014061

Viewing 15 posts - 10,546 through 10,560 (of 59,099 total)