Viewing 15 posts - 1 through 15 (of 247 total)
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
hi
in case of Managed Instance (Azure SQL DB) you have no control over the underlying instance.
All you can do is to get understanding how big tempdb can be according to...
November 12, 2019 at 4:27 pm
Viewing 15 posts - 1 through 15 (of 247 total)