Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 59,072 total)

Reply To: prevent certain characters being inserted into table

My apologies... I flat out forgot that this is a VENDOR supplied table. I absolutely agree with the others but will take it one step further... unless you get written...
--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)

May 15, 2021 at 11:06 pm

#3883899
Reply To: Limit database restores to specific drive locations

I don't suppose removing privs from users and forcing them to use a stored procedure to do restores is an option?
--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)

May 15, 2021 at 12:28 am

#3883646
Reply To: prevent certain characters being inserted into table

The "best" way would be to have an "INSTEAD OF" trigger that checks the entry. You could also do it after the fact with a normal "after" trigger that would...
--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)

May 15, 2021 at 12:06 am

#3883644
Reply To: prevent certain characters being inserted into table

What are you saying you want done if an attempted entry contains one of the taboo characters? Do you want to silently reject the entire entry or just remove 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)

May 15, 2021 at 12:00 am

#3883641
Reply To: Loading a csv file into sql server table

I avoid SSIS like the plague and so I'm not sure but it looks to me like SSIS isn't able to access the file. Have you checked to make sure...
--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)

May 14, 2021 at 11:42 pm

#3883639
Reply To: How to rebuild index on Internal Table?

Please read the second paragraph from the article at the following URL for the answer to that...
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-internal-tables-transact-sql?view=sql-server-ver15
--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)

May 14, 2021 at 11:28 pm

#3883630
Reply To: Monitor SQL Server Agent Jobs No Longer Executed

If you stop and think about it, all the supposed light-weight things you propose are just another way of capturing history except they are more heavy weight.
--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)

May 14, 2021 at 11:22 pm

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

The other part about the documentation on index maintenance is that it's spread all over hell's little half acre. This IS a spot that actually describes what REORGANIZE does 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)

May 13, 2021 at 6:51 pm

#3883139
Reply To: Are the posted questions getting worse?
Steve Jones - SSC Editor wrote:
Thoughts this crew might like this:
"Do not assume that index maintenance will always noticeably improve your workload."
https://docs.microsoft.com/en-us/sql/relational-databases/indexes/reorganize-and-rebuild-indexes?view=sql-server-ver15#index-maintenance-strategy
Steve Jones - SSC Editor wrote:
Thoughts this crew might like this:
"Do not assume...
--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)
May 13, 2021 at 6:45 pm

#3883134
Reply To: SQL 2012 Standard - Index highly fragmented

mjbc wrote:
I can say that some indexes rebuild from a 98% frag..... rebuild will take it down to less than 1%, give it an hour and that save index...
--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)

May 13, 2021 at 5:17 pm

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

You can get it from the following SQL Friday link, Lynn.
https://sqlfriday.net/past-sql-friday-sessions/sql-friday-17-jeff-moden-on-the-secret-to-high-performance-code-high-performance-test-data/
--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)

May 13, 2021 at 3:23 am

#3882846
Reply To: high CPU

Jeffrey Williams wrote:
For those recommending modifying the code - this is 3rd party vendor code and modifying that code without the vendors permission could invalidate the contract. Some vendors will...
--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)

May 12, 2021 at 7:46 pm

#3882696
Reply To: Non-Stop Learning

The new CE thing killed us. We had to turn it off.
With that in mind, Adaptive Joins has me scared to death.
I won't get into the other stuff on that...
--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)

May 12, 2021 at 6:54 pm

#3882473
Reply To: high CPU

sqlguru wrote:
So would you recommend to run update statistics with full scan for the whole database weekly instead of normal update statistics? One thing I noticed when I compared...
--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)

May 12, 2021 at 6:47 pm

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

Luis Cazares wrote:
Ed Wagner wrote:
Luis Cazares wrote:
David Burrows wrote:
Jeff Moden wrote:
I normally don't do self-advertisement but I'm giving a presentation tonight at 6PM EDST online on an interesting subject. Here'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)

May 12, 2021 at 6:33 pm

#3882460

Viewing 15 posts - 5,251 through 5,265 (of 59,072 total)