Jeff Moden

Forum Replies Created

Viewing 15 posts - 6,601 through 6,615 (of 59,072 total)

Reply To: How to compare strings by letters in certain places
Jason A. Long wrote:
Take this for a spin...
```
DECLARE
@array_6 varchar(MAX) = 'hurrah, buzzed, Bertha, patter, mettle, holler, collie, yuppie, rabble, tallow, brooks, tassel, meddle, callus, peddle, sobbed, kneels, getter, brooms,...
```
--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)
August 15, 2020 at 5:12 am

#3780662
Reply To: How to compare strings by letters in certain places

BOR15K wrote:
Thank you, Steve
Sadly none of your examples works for me from the Studio - getting various error messages.
The code probably worked just fine for Steve. When you get such...
--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)

August 15, 2020 at 2:09 am

#3780651
Reply To: How to compare strings by letters in certain places

BOR15K wrote:
I need some basic help, which I will then try to extend, please.
Since very few people ever come back to tell us, I'll make you a deal... Tell...
--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)

August 15, 2020 at 2:07 am

#3780650
Reply To: Job that runs slow how to use more CPU

I'll never understand why people do this to themselves. You're talking about a batch job but you're processing using RBAR on steroids that's highly dependent on successful network traffic 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)

August 14, 2020 at 4:45 pm

#3780548
Reply To: Are the posted questions getting worse?

jonathan.crawford wrote:
Jeff Moden wrote:
Eirikur Eiriksson wrote:
Did you run into those in your youth, the year looks about right 😉
Heh... I remember it well. 😀
'twas the year of Y1.9K, when all the shopkeeper'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)

August 14, 2020 at 1:20 am

#3780376
Reply To: Are the posted questions getting worse?

Eirikur Eiriksson wrote:
Did you run into those in your youth, the year looks about right 😉
Heh... I remember it well. 😀
--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)

August 13, 2020 at 4:37 pm

#3780310
Reply To: Desktop or Laptop for Remote Work

Aaron N. Cutshall wrote:
Jonathan Gennick wrote:
For the road I have a small-form-factor laptop that fits nicely on an airline tray table.
Yeah, until the yahoo in the seat in front of you decides 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)

August 13, 2020 at 4:28 pm

#3780307
Reply To: The Hidden Trigger

Chris Wooding wrote:
It would be nice if the object explorer in SSMS had a node under each database for triggers so that you could see them all in one place.
Agreed 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)

August 13, 2020 at 4:02 pm

#3780304
Reply To: Are the posted questions getting worse?

Lynn Pettis wrote:
Phil Parkin wrote:
Lynn Pettis wrote:
IIRC, there is also a difference in the dates in Excel and SQL Server. Only problem is that I don't quite remember what the problem, had 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)

August 13, 2020 at 2:30 am

#3780068
Reply To: Change dbowner

ramyours2003 wrote:
As we renamed sa login to anothet name and want to change the dbowners of all databases but later versions like 2o12 onwards dbowner of sys databases are changed...
--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)

August 12, 2020 at 4:06 pm

#3779315
Reply To: Change dbowner

ramyours2003 wrote:
Can we change the dbowner to system databses ? if yes how can we proceed?
First, see Grant's reply.
Second, I have to ask... why would you want to/need to do...
--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)

August 12, 2020 at 1:57 pm

#3779264
Reply To: Desktop or Laptop for Remote Work

donald.parish wrote:
My main machine is my desktop. Fast connections to internet and databases. I use a laptop almost always to Remote Desktop Connection to my main desktop. Can use mouse,...
--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)

August 12, 2020 at 1:36 pm

#3779260
Reply To: Desktop or Laptop for Remote Work

Interesting article, Steve. Thanks.
I finally bought a new laptop about 8 months ago (it's only my second one in more than a decade after my first one, which still works). ...
--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)

August 12, 2020 at 4:21 am

#3779154
Reply To: slow query on a partitioned table

ghostman wrote:
I have a huge table with 3B of rows containing around 6 months of data running on Microsoft SQL server 2017 (RTM), which is partitioned day by day on...
--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)

August 12, 2020 at 3:36 am

#3779150
Reply To: slow query on a partitioned table

Adi Cohn wrote:
Unfortunately there is an old bug that for some reason Microsoft is not fixing. When using top clause or min or max aggregation functions on a partitioned table, SQL...
--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)

August 12, 2020 at 3:19 am

#3779145

Viewing 15 posts - 6,601 through 6,615 (of 59,072 total)