Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,831 through 7,845 (of 59,072 total)

Reply To: Cranky Curmudgeons

skeleton567 wrote:
Jeff, tell us how you REALLY feel! You are hilarious. With that, I have get off here and go share a glass of wine with my sweetheart of 40...
--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 23, 2020 at 11:44 pm

#3717948
Reply To: Cranky Curmudgeons

skeleton567 wrote:
Well, here is an interesting sidelight to all of this. I've been sitting here today listening and agreeing that I truly am a full-fledged CC. Conversely, in my last...
--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 23, 2020 at 10:47 pm

#3717932
Reply To: Cranky Curmudgeons

Look at the changes they did in 2016... they made it so that all files in Temp DB suffer the equivalent of TF 1117 to force all files to grow...
--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 23, 2020 at 10:31 pm

#3717924
Reply To: Cranky Curmudgeons

Grant Fritchey wrote:
Jeff Moden wrote:
wayne Freeman-369096 wrote:
Congrats on the license upgrade. one more level to go.
We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better...
--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 23, 2020 at 9:37 pm

#3717920
Reply To: Error converting data type varchar to float
Jeffrey Williams wrote:
If it is an issue of trailing control characters - you could also use SUBSTRING or LEFT to truncate the string and convert:
```
SELECT cast(substring('16.3%'+CHAR(10), 1, charindex('%',...
```
--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 23, 2020 at 9:19 pm

#3717912
Reply To: Error converting data type varchar to float

Ah... one more thing... REPLACE can make sucking sounds for performance even if the default collation is used. It's performance can usually be increased by quite a bit when you're...
--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 23, 2020 at 3:32 pm

#3717803
Reply To: Error converting data type varchar to float
First of all, the LTRIM/RTRIM thing might just be a waste of clock cycles... the following works just fine.
```
 SELECT CAST(ISNULL(REPLACE(SPACE(10)+'16.3%'+SPACE(10), '%', ''), 0) as FLOAT);
```
I suspect...
--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 23, 2020 at 3:02 pm

#3717795
Reply To: Cranky Curmudgeons

wayne Freeman-369096 wrote:
Congrats on the license upgrade. one more level to go.
We aren't Cranky, it's just hard to get people to understand that everything that's new isn't always better or cheaper...
--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 23, 2020 at 2:33 pm

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

On a different note, here's one of the many reasons I fear both the cloud and any automatic performance metrics collected by any company...
https://mspoweruser.com/microsoft-accidentally-exposes-250-million-customer-support-records-online/
This has gotten to be a totally...
--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 23, 2020 at 2:27 pm

#3717778
Reply To: What could cause MS Access app as a front-end to SQL, periodically run slow?

Have you checked to see if a virus scan is running and maybe picking up on the Access files?
--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 23, 2020 at 3:39 am

#3717626
Reply To: Error converting data type varchar to float

Mark Eckeard wrote:
I've trimmed the values, removed the '%' and I still cannot convert or cast these values. Since I can't change the table structure, I am stuck doing this in...
--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 23, 2020 at 2:31 am

#3717623
Reply To: Establishing SQL server tables Relationships without knowledge of DB and tables

IF there are any stored procedures, the joins in those store procedures can provide some important clues. I suspect that, because of the lack of keys, there probably aren't many...
--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, 2020 at 1:17 pm

#3717358
Reply To: Require Recommendations | Index Rebuild

JigarShah wrote:
Hi All,
The DBA who was before me had used the Ola's code in the sql job. But as i found out, it did not removed fragmentation. So i tried...
--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, 2020 at 12:45 pm

#3717347
Reply To: Pivot: Rows to Column and Values as rows

It would be nice if you told us what column you added and what it contains. It would also be nice if you posted readily consumable data so we can...
--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, 2020 at 3:27 pm

#3717070
Reply To: how about explaining your RegEx logic?

I'm not sure whether or not you meant this to be a separate post or a post on some other thread, but I absolutely agree.
I'll also state that RegEx, especially...
--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, 2020 at 7:09 pm

#3716634

Viewing 15 posts - 7,831 through 7,845 (of 59,072 total)