Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,016 through 3,030 (of 59,098 total)

Reply To: Why transaction log cannot be trucnated during full backup

Tadas wrote:
@Jeffrey - we have shared infrastructure with thousands of sql servers, backups have dedicated network, but backups are throttled not to overutilize network and storage as backups run 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)

August 12, 2022 at 1:55 am

#4075433
Reply To: Shrinking TempDb files or adding more files to TempDB?
Johan Bijnens wrote:
You have to investigate what is causing that much tempdb consumption.
- #(#)temptb or @temptb
- regular tables created in tempdb ?
- version store (snapshot isolation level)
- queries performing group by,...
--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)
August 11, 2022 at 6:10 pm

#4075330
Reply To: Import csv into MYSQL DB with Windows Powershell

My recommendation would be to start at the following URL...
https://duckduckgo.com/?q=import+csv+into+mysql+workbench
--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)

August 11, 2022 at 6:05 pm

#4075329
Reply To: query

You have all the suggestions written out in your post. Just code to those. Like Granny used to say, "You can only peel one potato at a time". Pick 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)

August 11, 2022 at 6:02 pm

#4075328
Reply To: Best way to learn T-SQL for MS SQL Server?

Annie_Weaver wrote:
Thank you for the advice of great books. Very useful for me. I think https://www.w3schools.com/sql/ is a good guide. I would like to ask where exactly in the programming...
--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)

August 11, 2022 at 5:50 pm

#4075324
Reply To: sys.object
yrstruly wrote:
```
        CREATE FUNCTION [dbo].[fn_GetSummaryReport]  (   @pStartDate     DATE,   @pEndDate  ...
```
--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)
August 11, 2022 at 3:48 am

#4075073
Reply To: Retrieve records added across database (all user table) after a specific date

fafful wrote:
This is resolved. Thanks.
I'm really curious... how did you resolve this, please?
--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)

August 11, 2022 at 3:41 am

#4075071
Reply To: Shrinking TempDb files or adding more files to TempDB?

To be honest, 500GB of TempDB is terribly large for most servers. You'd probably do well to find out the cause.
Whatever happens, don't do a shrink. It's a waste of...
--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)

August 10, 2022 at 7:39 pm

#4074995
Reply To: Any way to scale MS Vulnerability Assessment Tool

It sounds like they're using the "Right click on the database in the object explorer" method.
--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)

August 10, 2022 at 7:36 pm

#4074994
Reply To: Why transaction log cannot be trucnated during full backup

Jeffrey Williams wrote:
FWIW - I backup a 6TB+ database every night in less than 2 hours. That process backs up to a local drive - then copies the file to another...
--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)

August 10, 2022 at 7:34 pm

#4074993
Reply To: CASE statement with multiple conditions (trimming & detecting spaces in between)

On the first item, I'm not grokking what the anomaly is that you speak of.
On the second, lookup the LEN() function and the SUBSTRING function.
--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)

August 10, 2022 at 7:23 pm

#4074991
Reply To: Finding the row before the negative value

p.s. Since ID seems to be a sign of grouping, do you want this done by groups formed by ID or what? Is that why row 6 wasn't returned 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)

August 10, 2022 at 1:31 am

#4074618
Reply To: Finding the row before the negative value

meryemkurs072 wrote:
Thank you.
Under normal conditions, when a row goes negative, the query lists the rows before that row.
However, if a movement has never been negative, it does not bring 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)

August 10, 2022 at 1:23 am

#4074617
Reply To: Help with Copying backup files and capture results in output file with details

I'm no help here but that "password in text" stuff is one of the reasons I hate 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)

August 10, 2022 at 1:10 am

#4074616
Reply To: Consistent Time

Is that with our without Leap Seconds? 😀
--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)

August 10, 2022 at 1:05 am

#4074615

Viewing 15 posts - 3,016 through 3,030 (of 59,098 total)