Jeff Moden

Forum Replies Created

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

RE: How To Truncate Log with Transaction Replication

ken 16613 - Thursday, November 8, 2018 10:06 PM
Thanks @jeff. I didn't receive a notification from your reply for some reason.
For clarification,...
--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 10, 2018 at 7:52 am

#2013065
RE: [N]Varchar(4000) and Performance

p.s. You should write an article on 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)

November 10, 2018 at 7:48 am

#2013064
RE: [N]Varchar(4000) and Performance

Very cool stuff, Eddie. Added that to my briefcase. Thanks for taking the time to do the experiment and post the results and the explanation!
--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 10, 2018 at 7:48 am

#2013063
RE: The Cost of Switching

Steve Jones - SSC Editor - Monday, February 2, 2015 8:27 AM
David.Poole (1/31/2015)
Real DBAs script things because their tasks have to 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)

November 10, 2018 at 7:26 am

#2013062
RE: Error while restoring a database from a backup

1. If you're trying to do a restore over an existing database, you need to use the REPLACE option. Remember that this will overwrite the existing database and, if...
--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 10, 2018 at 7:10 am

#2013061
RE: Are the posted questions getting worse?

WayneS - Friday, November 9, 2018 11:50 PM
Lynn Pettis - Friday, November 9, 2018 3:19 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 10, 2018 at 7:05 am

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

Eirikur Eiriksson - Saturday, November 10, 2018 12:28 AM
jay-h - Thursday, November 8, 2018 12:49 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 10, 2018 at 7:01 am

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

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