Viewing 15 posts - 1 through 15 (of 248 total)
have a look here:
https://www.mssqltips.com/sqlservertip/5659/customize-sql-server-notifications-for-ddl-changes/
September 2, 2022 at 11:26 am
Another thing is a job schedule. It also has owner and it could be the ex-dba account.
September 29, 2020 at 8:02 am
May be a case that you need to run a few log backups to get it to be able to checkpoint and shrink.
it could be replication also ...
if it...
March 16, 2020 at 12:51 pm
Mike, what is log_reuse_wait_desc for this database in sys.databases?
select name, log_reuse_wait_desc from sys.databases where name=N'yoursmalldb'
March 16, 2020 at 12:47 pm
it's worth to check the content of default trace which is enabled by default on all editions of SQL server 2005+
https://www.mssqltips.com/sqlservertip/1739/using-the-default-trace-in-sql-server/
"It Depends". On my main production server,...
December 2, 2019 at 4:08 pm
please, show result of the following from both PROD and TEST:
select name, value_in_use from sys.configurations where name like '%server memory%'
December 2, 2019 at 3:59 pm
Disregard this question, a trigger could complete this request, I need a way to be notify when a new job has been created on my SQL Server. Any ideas,...
December 2, 2019 at 3:23 pm
it's worth to check the content of default trace which is enabled by default on all editions of SQL server 2005+
https://www.mssqltips.com/sqlservertip/1739/using-the-default-trace-in-sql-server/
December 2, 2019 at 3:15 pm
What is the target table?
Heap, indexed, columnstore, etc ?
November 18, 2019 at 3:19 pm
database physical structure (files & related)
database configuration parameters (options & config)
database objects
data itself
imho
November 14, 2019 at 3:07 pm
hi Stefan
I see two options:
November 13, 2019 at 4:43 pm
what would "select @@version" return?
November 13, 2019 at 2:22 pm
Viewing 15 posts - 1 through 15 (of 248 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy