Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,846 through 7,860 (of 59,091 total)

Reply To: Master database is "cleanly shutdown"

I've never seen such a thing. I have to admit, though, I've never thought to look for such a thing simply because I'd never have thought such a thing was...
--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 25, 2020 at 4:49 pm

#3720388
Reply To: RTO 15 minutes with differential backups

You have come across one of the primary reasons why I hate certification courses, exams, and the related books/articles. They're a possibly decent starting point but, oh my...
IMHO, it 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)

January 25, 2020 at 3:58 pm

#3720385
Reply To: How to handle date on temp table when is null or not ?

There is no way to automatically distinguish differences between dd/mm/yyyy and mm/dd/yyyy for values of mm and dd that are less than 13 and so there is no way 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 25, 2020 at 3:20 pm

#3720384
Reply To: Recruitment question

Yes... post a couple of links that point to your specific posts on the job posting sites and let us have a look.
I can also tell you that, based 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)

January 25, 2020 at 12:21 am

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

Viewing 15 posts - 7,846 through 7,860 (of 59,091 total)