Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,601 through 3,615 (of 59,098 total)

Reply To: sql sleeping sessions with old open transactions

It sounds like a "connection leak" built in. Either that or connection pooling on steroids that has gotten a bit out of hand and forgetting to deallocate a cursor 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)

April 27, 2022 at 5:06 pm

#4023183
Reply To: Unicode Compression

BWAAA-HAAA-HAAA! 😀 NCHAR(MAX). I wonder if anyone will bite 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)

April 27, 2022 at 12:30 am

#4022750
Reply To: Regarding Heterogeneous Database Replication

I don't know and I actually try to avoid all forms of "replication" but posting your question to Google came up with this. They have a link at the bottom...
--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)

April 27, 2022 at 12:12 am

#4022748
Reply To: My calculation with a CASE statement isn\'t working
Are you just trying to LPAD zeros for a total length of 5? If so, this will make your life easier...
```
DECLARE @SomeInt INT = 22;
 SELECT RIGHT(CONCAT('00000',@SomeInt),5)
;
```
Note...
--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)
April 27, 2022 at 12:05 am

#4022746
Reply To: SQL Server Memory Exhaustion

Doesn't matter... sounds like you need more RAM for whatever you having the server do either way.
--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)

April 26, 2022 at 7:03 pm

#4022663
Reply To: What is the best way to execute ~100 I/O bound scripts?

What do the scripts actually do? The reason why I ask is that if there's contention, you could end up with quite a bit of blocking that would make this...
--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)

April 26, 2022 at 6:28 pm

#4022631
Reply To: The most basic SQL question ever...

There are some brilliant methods to be had here and are especially necessary because most people's spreadsheets don't actually look like a table.
They also take a special tool and some...
Attachments:
You must be logged in to view attached files.
--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)

April 26, 2022 at 6:13 pm

#4022627
Reply To: Default Trace

Like I said at one of your previous posts ( https://www.sqlservercentral.com/forums/topic/transaction-log-growth-index-manintenance-jobs-database-functional-jobs#post-4021517 ), there's not much use of it on a busy system because the life=time expectancy of data in 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)

April 26, 2022 at 5:59 pm

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

Grant Fritchey wrote:
Jeff Moden wrote:
I've always been concerned but, as I get older, I seriously worry about the medical world and hospitals and the people in them when I see things like...
--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)

April 26, 2022 at 5:50 pm

#4022623
Reply To: Testing BB Formatting here...

"Style" wasn't in the list of BBCodes but tried it in the first post above just to make sure. Agreed... it doesn't work.
--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)

April 25, 2022 at 6:32 pm

#4021997
Reply To: Using T-SQL over PoSh

ZZartin wrote:
Jeff Moden wrote:
Except for the errors they still have and the missing functionality it still has, it does the same thing as BULK INSERT except slower.
It amazing how many people...
--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)

April 25, 2022 at 6:27 pm

#4021992
Reply To: Pre allocating free space to db growth

That's a good idea but I don't believe that will reduce the impact on the log file when you use REORGANIZE.
--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)

April 25, 2022 at 6:25 pm

#4021991
Reply To: How to add background color of row based to existing SP/query

Thank you for the feedback.
--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)

April 25, 2022 at 6:21 pm

#4021990
Reply To: Transaction log growth - Index Manintenance jobs & Database functional jobs

Ah... careful now... you can't rely on the default trace on a busy system for things like this. The lifetime expectancy of any row in our default trace is 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)

April 25, 2022 at 12:46 am

#4021517
Reply To: Using T-SQL over PoSh
skeleton567 wrote:
Jeff Moden wrote:
My two favorite questions are becoming...
Is there a reason why this MUST be done in PowerShell?
Is there a reason why this MUST be done in Python?
My...
--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)
April 25, 2022 at 12:01 am

#4021512

Viewing 15 posts - 3,601 through 3,615 (of 59,098 total)

Jeff Moden

Forum Replies Created

Attachments: