Jeff Moden

Forum Replies Created

Viewing 15 posts - 7,891 through 7,905 (of 59,072 total)

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
Reply To: Pivot: Rows to Column and Values as rows

There's nothing in the original data you've posted to preserve the required order of the data to do this. Your addition of a calculated row number doesn't cut it for...
--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:18 pm

#3714922
Reply To:

To answer your question at the end of your original post, yes... there are other ETL tools... and, they're quite expensive and they have steep learning curves and are subject...
--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:10 pm

#3714921
Reply To: Blocking by select against sys.dm_db_index_physical_stats

It probably is the "Insert Bulk" things happening. MS tried to make code faster faster with an "improvement" called "Fast Inserts", which came about in SQL Server 2016. It allocates...
--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 12, 2020 at 8:28 pm

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

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 might help
Yeah,...
--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 12, 2020 at 7:42 pm

#3714768

Viewing 15 posts - 7,891 through 7,905 (of 59,072 total)