Jeff Moden

Forum Replies Created

Viewing 15 posts - 9,991 through 10,005 (of 59,093 total)

RE: very slow select

Jonathan AC Roberts - Monday, January 21, 2019 8:19 AM
It would be good it you could have a clustered index on STATUS_ID, PROPERTY_ID, SOURCE_ID.
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)

January 22, 2019 at 12:04 am

#2019593
RE: Fuzzy match based on T-SQL only

The "Levenshtein Distance Algorithm" seems to be one of the most accurate. Here's one link and, of course, Google is loaded for bear on this subject.
https://www.red-gate.com/simple-talk/sql/t-sql-programming/fuzzy-searches-sql-server/
--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)

January 21, 2019 at 11:36 pm

#2019592
RE: Is sp_send_dbmail Asynchronous?

Sue_H - Monday, January 21, 2019 11:55 AM
pietlinden - Monday, January 21, 2019 11:28 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)

January 21, 2019 at 11:23 pm

#2019591
RE: The SQL Server LAG Function

Thanks for taking the time to write a nice simple article on the subject of LAG.
Shifting gears as a bit of a suggestion...
While a graphical representation of...
--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)

January 21, 2019 at 11:17 pm

#2019590
RE: View timeout problem

Bruce-12445 - Thursday, January 17, 2019 4:49 PM
I have a fairly complex sql view that times out most of the time. I...
--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)

January 21, 2019 at 11:10 pm

#2019588
RE: Update trigger

jkramprakash - Sunday, January 20, 2019 9:56 AM
view will be faster then table?.Please suggest.so that i can avoid second table.
No. It's not...
--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)

January 21, 2019 at 11:05 pm

#2019587
RE: Bulk Insert how to skip column using format file

While you may consider it to be an extra step (and it is), I never import directly into a final table anyway. I always import into a staging table 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)

January 21, 2019 at 11:02 pm

#2019586
RE: Are the posted questions getting worse?

My favorite job description in an actual ad was one that I found in a newspaper right around 2003. It was short, sweet, and to the point.
"SQL Wanted:...
--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)

January 21, 2019 at 3:21 pm

#2019567
RE: Versatile or Jack of all trades

ktipton - Monday, January 21, 2019 9:38 AM
djackson 22568 - Monday, January 21, 2019 7:41 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)

January 21, 2019 at 3:09 pm

#2019566
RE: Prevent Logon Triggers

I agree with Sue. You need to fix the permissions on the users of those machines so that can't do such a thing.
--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)

January 21, 2019 at 11:47 am

#2019547
RE: Date functions..

Lynn Pettis - Sunday, January 20, 2019 1:48 PM
Jeff Moden - Sunday, January 20, 2019 12:17 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)

January 20, 2019 at 3:07 pm

#2019485
RE: Date functions..

Jeffrey Williams 3188 - Sunday, January 20, 2019 10:20 AM
Jeff Moden - Saturday, January 19, 2019 5:24...
--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)

January 20, 2019 at 12:17 pm

#2019482
RE: Remove DATE ONLY from datetime column

Lempster - Sunday, January 20, 2019 2:31 AM
Jeff Moden - Saturday, January 19, 2019 3:02 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)

January 20, 2019 at 8:02 am

#2019473
RE: Performance Issue with Simple Query /Big Tables

polkadot - Friday, January 18, 2019 8:56 PM
Jeff Moden regarding the "NCI_CHUB_S_CONTACT_01"...
--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)

January 20, 2019 at 7:50 am

#2019472
RE: Understanding the datetime2 data type and precision

michael.leach2015 - Saturday, January 19, 2019 5:47 PM
Jeff Moden - Saturday, January 19, 2019 4:57 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)

January 19, 2019 at 7:00 pm

#2019459

Viewing 15 posts - 9,991 through 10,005 (of 59,093 total)