Jeff Moden

Forum Replies Created

Viewing 15 posts - 3,571 through 3,585 (of 59,067 total)

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
Reply To: Using T-SQL over PoSh
My two favorite questions are becoming...
1. Is there a reason why this MUST be done in PowerShell?
2. Is there a reason why this MUST be done in Python?
The answer both...
--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 24, 2022 at 5:23 pm

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

SQLisAwe5oMe wrote:
Hi Jeff - just checking to see if you got a chance to test it.
Ok. I don't actually have any mirrored databases anywhere but I tested this the best...
--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 24, 2022 at 4:18 am

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

ratbak wrote:
Advantages of pre-allocation: Queries don't die when you suddenly run out of room in the middle of a transaction. No need to wait for file growth. No risk 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)

April 23, 2022 at 10:26 pm

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

Step 1 would be to stop using REORGANIZE unless you actually know what it does on each and every index you have and, to be brutally honest, most people 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)

April 23, 2022 at 10:11 pm

#4021149
Reply To: Backup verify with third party tools

ramana3327 wrote:
Thank you. What will happen if the backup verify fail in one of the database? It will start again taking the backup or just tell us the verify option...
--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 23, 2022 at 9:42 pm

#4021126
Reply To: Pre allocating free space to db growth
ramana3327 wrote:
I am thinking about the negative consequences of provisioning free space drastically high.
1. How much difference it will be in backup size and backup time
2. Restoring to the test...
--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 23, 2022 at 9:22 pm

#4021124

Viewing 15 posts - 3,571 through 3,585 (of 59,067 total)

Jeff Moden

Forum Replies Created

Attachments: