Jeff Moden

Forum Replies Created

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

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
RE: Do you use custom schemas?

fahey.jonathan - Monday, November 19, 2018 4:29 PM
Jeff's earlier message said, "If you're talking about 3 and 4 part naming in any...
--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 7:43 pm

#2014059
RE: How to alter a table with PRIMARY KEY CLUSTERED

If there is no Clustered Index on the table, then this will work...
ALTER TABLE dbo.SomeTable ADD CONSTRAINT PK_SomeTable PRIMARY KEY CLUSTERED (ID)
--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 7:39 pm

#2014058
RE: DT_BYTE to DT_DBDATE

Or... you could do it in T-SQL and not have to worry about SSIS or C#. 😉 Maybe even a persisted computed column on the table might work, eh?
--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 7:18 pm

#2014056
RE: DT_BYTE to DT_DBDATE

sgmunson - Monday, November 19, 2018 12:14 PM
David Burrows - Thursday, November 15, 2018 2:00 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 19, 2018 at 4:12 pm

#2014045

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