Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 59,086 total)

Reply To: Query Tuning, Why Bother?

Grant Fritchey wrote:
Grant Fritchey wrote:
Jeff Moden wrote:
Grant Fritchey wrote:
Thanks for all the feedback everyone. Appreciated.
Me, I love tuning queries.
Yes Jeff, working on the new book. Chapter 20 right now, Graph data.
@Grant ,
Awesome... I don't...
--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 4:24 pm

#4075809
Reply To: Consistent Time

Having just written an article about UNIX TimeStamps, I'd done a whole lot of research on them and was just having a bit of fun here because it was fresh...
--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 4:23 pm

#4075808
Reply To: Data Flow Formatters - Flatten, Parse and Stringify in Azure Data Factory

Really nice article for those that need to use such a thing. With that being said, PLEASE don't take the following rant as any kind of demeaning of your fine...
--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 2:20 am

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

Viewing 15 posts - 3,001 through 3,015 (of 59,086 total)