Jeff Moden

Forum Replies Created

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

RE: Year By Months -Columns

Please don't use EOMonth. If you're trying to write criteria to isolate a month in your queries, use the standard of "SomeDate >= FirstOfMonth and SomeDate < FirstOfNextMonth". It'll work...
--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 6:48 pm

#2019763
RE: Date functions..

Sean Lange - Monday, January 21, 2019 2:49 PM
I could easily put together a test in a VS project but it...
--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 11:52 am

#2019701
RE: View timeout problem

Bruce-12445 - Monday, January 21, 2019 11:16 PM
thanks Jeff the OPENQUERY solution solved all discrepancies.
Thanks for the feedback, Bruce.
--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 11:03 am

#2019690
RE: Versatile or Jack of all trades

djackson 22568 - Tuesday, January 22, 2019 7:48 AM
Jeff Moden - Monday, January 21, 2019 3:09 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 22, 2019 at 11:02 am

#2019688
RE: very slow select

ScottPletcher - Tuesday, January 22, 2019 10:02 AM
You wouldn't typically want to cluster on status, since it tends to change.
However, you'd almost...
--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 10:57 am

#2019687
RE: Ways to search Faster In Ms SQL Server

First, learn how to use all of the built-in functions of SQL Server/T-SQL because, as with any language, that's where a lot of the performance is.
Second, read and...
--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:19 am

#2019594
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

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