Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,586 through 3,600 (of 59,087 total)

Reply To: Is Developer required a writing skills to become a expert?

I'll say, Absolutely. It's a very necessary form of communication no matter what you do in life but especially in the world of IT. And, it's not limited to just...
--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 28, 2022 at 10:47 pm

#4023933
Reply To: The Craziness of Code

I REALLY enjoyed the "Programming Sucks" article you provided a link to, Steve. The funniest part about it is that it's all true! 😀
Shifting gears a bit, thank you for...
--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 28, 2022 at 10:15 pm

#4023932
Reply To: My calculation with a CASE statement isn\'t working

Melanie Peterson wrote:
Oh bless you, Scott Pletcher, this works wonderfully.
I have a question just out of curiosity... what are you going to do with the zeroes once you have the correct...
--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 28, 2022 at 4:16 am

#4023435
Reply To: Which command will using to delete all rows from table truncate or delete ?

There are actually several massive differences between Truncate and Delete. You can read about most of them simply by looking up the commands and reading about them.
One not so well...
--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 28, 2022 at 3:45 am

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

Viewing 15 posts - 3,586 through 3,600 (of 59,087 total)

Jeff Moden

Forum Replies Created

Attachments: