Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,666 through 10,680 (of 59,095 total)

RE: Optimize a LIKE '%text%' query

ralu_k_17 - Friday, November 9, 2018 6:52 AM
Hello!
Is there a way of optimizing(/workaround) the performance of a LIKE '%text%' query, on a...
--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 9, 2018 at 9:01 pm

#2013047
RE: Converting between binary hex and GUID (uniqueidentifier)

Lynn Pettis - Friday, November 9, 2018 8:44 AM
Jeff Moden - Thursday, November 8, 2018 10:05 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 9, 2018 at 8:13 pm

#2013044
RE: Composite indexes; performance

To make the task a bit shorter, you could do the proverbial "Hail Mary" play... disable (not drop) the shorter index and simply see what happens. As they say, "One...
--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 9, 2018 at 8:44 am

#2012976
RE: DT_BYTE to DT_DBDATE

sgmunson - Friday, November 9, 2018 6:48 AM
Doesn't have to actually be that long. Once you have the human readable string, here's...
--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 9, 2018 at 8:40 am

#2012972
RE: Proper Way to Count # of Customers

rob26r - Friday, November 9, 2018 7:29 AM
Correct - MDX. Oops, perhaps I posted this on the wrong forum.
No. MDX code is...
--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 9, 2018 at 8:37 am

#2012971
RE: Splitting a Full Name

p.s. The list of titles is really far from being inclusive especially when it comes to such things as Microsoft and other certifications and awards (like MVP).
--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 9, 2018 at 8:35 am

#2012970
RE: Splitting a Full Name

Chris Wooding - Friday, November 9, 2018 7:39 AM
For anyone in Europe doing this as part of a MiFID II requirement, a...
--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 9, 2018 at 8:32 am

#2012969
RE: Proper Way to Count # of Customers

Thanks, Jason.
--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 9, 2018 at 7:25 am

#2012962
RE: Proper Way to Count # of Customers

I'm not a GUI programmer nor do I use SSAS, SSIS, SSRS, DW, etc, etc, so I have to ask what "language" is this and why haven't you simply used...
--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 9, 2018 at 6:40 am

#2012949
RE: Converting between binary hex and GUID (uniqueidentifier)

jay-h - Thursday, November 8, 2018 12:49 PM
Sounds easy. but I'm trying to connect the [step_uid] field in msdb.dbo.sysjob (uniqueidentifier) to 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 8, 2018 at 10:05 pm

#2012927
RE: Splitting a Full Name

brickpack - Thursday, July 11, 2013 2:54 PM
I'm trying to split a full name column up into First / Middle / Last....but...
--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 8, 2018 at 9:28 pm

#2012926
RE: How to overcome missing 0x for varbinary?

patrickmcginnis59 10839 - Thursday, November 8, 2018 11:59 AM
Jeff Moden - Thursday, November 8, 2018 7:48 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 8, 2018 at 9:09 pm

#2012924
RE: Composite indexes; performance

Jonathan AC Roberts - Thursday, November 8, 2018 10:36 AM
Jeff Moden - Thursday, November 8, 2018 10:25...
--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 8, 2018 at 10:43 am

#2012877
RE: Composite indexes; performance

Jonathan AC Roberts - Thursday, November 8, 2018 10:15 AM
Jeff Moden - Thursday, November 8, 2018 10:12...
--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 8, 2018 at 10:25 am

#2012872
RE: Composite indexes; performance

AER - Thursday, November 8, 2018 10:05 AM
Thanks for all your replies.
I know that is not the simple question; that's why 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)

November 8, 2018 at 10:12 am

#2012867

Viewing 15 posts - 10,666 through 10,680 (of 59,095 total)