Jeff Moden

Forum Replies Created

Viewing 15 posts - 4,021 through 4,035 (of 59,067 total)

Reply To: Suspended session : Job is taking very long time to complete

DBA wrote:
A cte query which joins couple of tables and then updates is in suspended state. Is it possible it is blocking itself?
SP who is active shows NULL in 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 26, 2022 at 9:39 pm

#3977661
Reply To: How to calculate delta in timestamp

ScottPletcher wrote:
It doesn't matter if the 'on' is followed by 'on' or 'off', just add up all the 'on' times.
It actually does matter because two on times without an off...
--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 25, 2022 at 11:39 pm

#3977205
Reply To: Knowing When to Respond

From the Article:
"Without a baseline, every issue encountered could be considered normal and therefore not require any additional intervention."
Another way to look at it is "Without a baseline, every non-issue...
--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 25, 2022 at 7:33 pm

#3977130
Reply To: Too many .ldf

ramyours2003 wrote:
what is the impact of too many .ldf''s in a database?
To be honest, there's no impact other than maybe on your reputation if someone else finds out... that's also...
--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 25, 2022 at 7:18 pm

#3977116
Reply To: Reusing Tools for New Purposes

qbrt wrote:
Jeff Moden wrote:
Such workarounds are absolutely stupid. Not because the workaround itself is stupid but, rather, because Microsoft has made such a workaround NECESSARY. .......
F@#$%NG EPIC!

BWAAAAA-HAAAA!!! At least I know...
--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 25, 2022 at 6:55 pm

#3977105
Reply To: How to reclaim space from a table

Before you go rebuilding the table to recover the space, at least find out why there's so much unused space in the table. Is it due to forwarded rows or...
--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 25, 2022 at 6:46 pm

#3977104
Reply To: SUM(CAST(....

2Tall wrote:
Thanks for your response Jeff. Glad to see you are still going strong. I will have a play. Keep up the great work.
Kind Regards,
Phil.
It's been a while since I've...
--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 25, 2022 at 6:41 pm

#3977101
Reply To: Reusing Tools for New Purposes

below86 wrote:
Jeff Moden wrote:
... Using end of month dates is actually a WORST PRACTICE! ...
I agree with a lot of what you said Jeff, but I can't agree here. I've...
--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 25, 2022 at 6:39 pm

#3977100
Reply To: sql query help

Again... if you post some sample data in a readily consumable format, we can help a whole lot more. See the first link in my signature line below for one...
--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 25, 2022 at 6:34 pm

#3977099
Reply To: sql query help
sqlenthu 89358 wrote:
I have gone through the two parts of Jeff's articles. But I still couldn't figure out the solution. here's my sample data:
```
businessday category itemno value
2022-01-01 xyz...
```
--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 25, 2022 at 1:47 pm

#3976975
Reply To: SUM(CAST(....
2Tall wrote:
Thank you for your replies.
I added: CAST(FileSize AS decimal(35,2)) AS FileSize,
+
WHERE Domain = @Domain AND convert(bigint, Filesize) > 50000
That worked so many thanks.
One last question...
```
--I added
ROUND(SUM(CAST([FileSize]...
```
--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 25, 2022 at 1:23 pm

#3976949
Reply To: Restore is not progressing at all . Please kindly help

WhiteLotus wrote:
Hi All ,
I need to restore database 1.2 TB .. bak files are on network share drive .
the time i run restore .. it shows no progress . Status...
--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 24, 2022 at 11:16 pm

#3976744
Reply To: Reusing Tools for New Purposes

Rod at work wrote:
Steve, why is it that code reuse in T-SQL, in particular refactoring, results in performance penalties? I'm ignorant as to why this is so. Just trying to learn more,...
--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 23, 2022 at 5:44 pm

#3976280
Reply To: How can I execute OLEDB Command without Result Set

Owen White wrote:
Jeff M,
I can't stop laughing at your response. You are correct that I am trying to leverage previous work done in the stored procedures instead of rewriting the logic...
--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 23, 2022 at 5:37 pm

#3976279
Reply To: How to replace stuff with string agg on sql server 2017 ?

And still no answer as the WHY this needs to be done.
--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 23, 2022 at 5:35 pm

#3976278

Viewing 15 posts - 4,021 through 4,035 (of 59,067 total)