Jeff Moden

Forum Replies Created

Viewing 15 posts - 5,326 through 5,340 (of 59,072 total)

Reply To: Different backup folders (Full, Diff and Log) using ola script

EasyBoy wrote:
We already keep 1 month of backup on drive and anything above that should transfer to shared backup network and that is the requirement of client.
Does that 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)

April 28, 2021 at 3:11 am

#3876640
Reply To: Index rebuild

premkuttan wrote:
I have a DB of size 240 GB and when the rebuild index job runs the log file grows upto 300 GB. I do a online reindex activity....
--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, 2021 at 10:51 pm

#3876576
Reply To: Different backup folders (Full, Diff and Log) using ola script

Yes, but not the way you think. It's a mistake to move only the FULL backups. You have no chance of restoring to a given time without the log 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 27, 2021 at 10:49 pm

#3876575
Reply To: HEAP fragmentation percent is high

juliava wrote:
if i have table not HEAPA and cant mannually rebuild or reorganize,persantage still the same,what else can be done?
How big or small is the table? Some tables are...
--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, 2021 at 10:47 pm

#3876574
Reply To: Finding columns with null values

Yep... I was looking at his code, as well. It appears that the OP wants only columns that contain nothing but nulls.
--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, 2021 at 9:28 pm

#3876547
Reply To: Database gets locked while copying tables from another Server

Agreed... Scott hit the nail on the head on this one, for sure. I've run into the identical problem several times and ended up doing just like Scott posted.

--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, 2021 at 5:33 pm

#3876446
Reply To: Finding columns with null values

I'm with ya on having some good stuff in the Master database. I agree that a lot of people poo-poo such things but it works incredibly well especially if you're...
--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, 2021 at 4:04 pm

#3876384
Reply To: Types of indexes available in SQL Server 2019

Ant-Green wrote:
Good question and well versed given the referenced link
I said 13 as you can create indexes on persisted columns as referenced in a child document, https://docs.microsoft.com/en-gb/sql/relational-databases/indexes/indexes-on-computed-columns?view=sql-server-ver15
It's a real...
--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, 2021 at 3:52 pm

#3876374
Reply To: Finding columns with null values

As a bit of a sidebar, the table I tested it against has, like I said, 147 columns. It's kind of a small table weighing in at only 8.4GB and...
--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, 2021 at 2:08 am

#3876137
Reply To: Finding columns with null values

ScottPletcher wrote:
I asked because many people are happy with code as long as it ultimately does what they need it to do, i.e. "the code's good enough for me." ...
--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, 2021 at 1:45 am

#3876131
Reply To: Finding columns with null values

ScottPletcher wrote:
Jeff Moden wrote:
ScottPletcher wrote:
Btw, why are you using such an inefficient method, checking the column values one by one?
What are you asking why instead of posting 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)

April 27, 2021 at 1:27 am

#3876129
Reply To: Finding columns with null values

ScottPletcher wrote:
Btw, why are you using such an inefficient method, checking the column values one by one?
What are you asking why instead of posting a link to something better?...
--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, 2021 at 9:30 pm

#3876067
Reply To: Finding columns with null values

And let's hope it's not an update to SSMS that's causing the problem. Which edition and version of SQL Server do you have and to which version of SSMS did...
--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, 2021 at 9:13 pm

#3876064
Reply To: Finding columns with null values

astrid 69000 wrote:
Hi,
I get the object id, it stopped working when I updated the management studio, i think it is not the code, but rather a new thing i need...
--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, 2021 at 9:11 pm

#3876062
Reply To: Finding columns with null values

astrid 69000 wrote:
it is a table and it does have null columns.
You code works correctly when I changed that table name to a test table I made specifically for 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)

April 26, 2021 at 9:07 pm

#3876058

Viewing 15 posts - 5,326 through 5,340 (of 59,072 total)