Viewing 15 posts - 1,906 through 1,920 (of 22,227 total)
we are looking for a list of databases where there is one objects in common, Is there DB script ?
Thanks
So any object in common or a specific object in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 2, 2020 at 8:30 am
I'd look into the Activity Logs then. That's going to be the best bet from what I can see.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 28, 2020 at 6:22 pm
Honestly, I don't know that I'd be knocking down the door today to move from 2017 to 2019. Mostly, 2017 is just working great. Mostly, 2019 is an awesome upgrade,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2020 at 1:44 pm
I was looking at native option. So you saying using sql server native method data masking can be done from SQL server 2016 onwards?
When you say "mask the data"...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2020 at 1:37 pm
Personally, I'd put powershell to work. Make a list of your servers. Provide that list to Powershell. Run a query against every server to get the list of databases. Done....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2020 at 1:31 pm
Yeah, give the permission of a given role to a given schema and be done. Sounds like you're trying to dig a hole.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2020 at 1:26 pm
There is no single switch you can throw to make DBCC faster. None. It's going to take the time it takes. If you're seeing 95% CPU when you run it...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 27, 2020 at 1:25 pm
I have to admit that I foolishly used the MSDB method (i'm no ssis expert, but i'm the best we have at our company) and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 26, 2020 at 4:16 pm
Thanks! Appreciate the kind words.
I think it's a fine thing that you have to justify the move. I suffer from "new shiny" syndrome and would be upgrading constantly if someone...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 26, 2020 at 4:12 pm
Why go with triggers? Use Extended Events. I don't have a blog post on tracking creation of logins using Extended Events available. Here's one on auditing database changes. You...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 26, 2020 at 12:09 pm
How about positive changes to our Recovery Time Objective? That alone would do it for me when you add in all the other improvements that have occurred since...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 26, 2020 at 12:04 pm
Grant/Jeff - won't any find/replace, in source control, via synonym or otherwise, have the same issues if the columns also changed? The only real method to make sure this...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2020 at 4:31 pm
This doesn't sound like an indexing problem, unless we see an execution plan showing scans. Instead, it sounds like an I/O problem caused by the varbinary(MAX). However, I'd want some...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2020 at 1:13 pm
One thing I would add, I was really tempted to drop databases after the restore. but the number of times a developer needed to get some data back because...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2020 at 1:09 pm
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 25, 2020 at 1:07 pm
Viewing 15 posts - 1,906 through 1,920 (of 22,227 total)