Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,906 through 7,920 (of 59,091 total)

Reply To: Autogrowth for data file

If it has zero or negative growth, why are you worried about the precise value of an autogrowth number? Pick a number (for example, 50 or 100MB) and move on.
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)

January 15, 2020 at 1:24 am

#3715474
Reply To: tyring to convert a varchar to a Date

jcelko212 32090 wrote:
Actually, the ANSI/ISO Standards say that it ought to look like "2020-01-04", or maybe "2020-04-01";
Not quite right. The ISO standards state that it can look like that as 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)

January 15, 2020 at 12:58 am

#3715473
Reply To: Require Recommendations | Index Rebuild

frederico_fonseca wrote:
Jeff Moden wrote:
Michael L John wrote:
I agree. Download and run Ola Hallengren's solution. It's far more complete, and is far more flexible, than what you have written.
https://ola.hallengren.com/
Ola's code is, indeed, 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)

January 15, 2020 at 12:51 am

#3715472
Reply To: tyring to convert a varchar to a Date

itmasterw 60042 wrote:
Hi
I have the following code:
in the end, the date should look like 1/4/2020, in a date format. And while this appears to be doing that, it comes back with...
--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 14, 2020 at 6:13 pm

#3715341
Reply To: Can a variable set equal to a query with parameters be used in an OLEDB Source

dndaughtery wrote:
Answered my own question. You cant do it that way. Also, you could use an expression task to replace placeholders in a query as long as the max length...
--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 14, 2020 at 5:58 pm

#3715333
Reply To: Require Recommendations | Index Rebuild

Read my larger post immediately before the short one you responded to. "It Depends" although I recommend that you simply stop using REORGANIZE except for those things I cited.
--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 14, 2020 at 5:50 pm

#3715330
Reply To: Change Log Backup Frequency Automatically

p.s. And stop using REORGANIZE for your index maintenance. It doesn't work the way most people think (actually sets up indexes for perpetual fragmentation) and it's not the tame little...
--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 14, 2020 at 4:43 pm

#3715304
Reply To: Change Log Backup Frequency Automatically

I have my production databases set to be "exposed" to the possibility of a transaction log backup every 15 minutes, but it's stupid to do an actual T-Log backup 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)

January 14, 2020 at 4:34 pm

#3715294
Reply To: Require Recommendations | Index Rebuild

Michael L John wrote:
I agree. Download and run Ola Hallengren's solution. It's far more complete, and is far more flexible, than what you have written.
https://ola.hallengren.com/
Ola's code is, indeed, the "Gold Standard". ...
--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 14, 2020 at 4:28 pm

#3715281
Reply To: Require Recommendations | Index Rebuild

Ola's code is great but it doesn't help you if you use the current "Best Practice" (it's not) of blindly rebuilding indexes after you've exceeded 30% logical fragmentation. Even "Books...
--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 14, 2020 at 4:23 pm

#3715278
Reply To: SQL Query Performance problem

Tony... what is your Cost Threshold of Parallelism set 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 14, 2020 at 3:30 pm

#3715257
Reply To: SQL Query Performance problem

Jonathan AC Roberts wrote:
What you mean by "MAXDOP 1,2,3,4" as it only has one parameter?
I'm thinking that it means that he tried all 4 settings.
--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 14, 2020 at 3:19 pm

#3715255
Reply To: Validating meta data of xls file
Phil Parkin wrote:
Hi Jeff, I've had some trouble getting your demo working on my home PC.
I installed 32- and 64- bit ACE drivers and then ran this:
```
sp_configure 'show...
```
--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 13, 2020 at 5:54 pm

#3715010
Reply To: Does the amount of DB reduces the speed of the server if DBs are not in use?

jbeclapez wrote:
Hello,
I am running a server and I was telling my colleagues that the amount of database has hardly nothing to do with the speed of the server. Basically we...
--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 13, 2020 at 3:33 pm

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

jasona.work wrote:
Jeff Moden wrote:
jasona.work wrote:
Jeff Moden wrote:
MVDBA (Mike Vessey) wrote:
jasona.work wrote:
Steve Jones - SSC Editor wrote:
Good luck with that. Not sure third party tools make this better, but you're welcome to eval SQL Backup from Redgate if 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)

January 13, 2020 at 3:27 pm

#3714925

Viewing 15 posts - 7,906 through 7,920 (of 59,091 total)