SQL Server – Does the SQL Agent Service Account Must be a SysAdmin?
As of today (5/14/2013) this MSDN article says “SQL Server Agent service startup account must be a member of the SQL Server...
2013-05-14
781 reads
As of today (5/14/2013) this MSDN article says “SQL Server Agent service startup account must be a member of the SQL Server...
2013-05-14
781 reads
One of the Microsoft’s recommendation for optimizing the tempDB performance is to make each tempdb data file the same size. Today,...
2013-05-06
918 reads
Often times I keep checking the error log to make sure if everything is running fine. Here is an undocumented stored...
2013-03-25
389 reads
When an error is raised by the SQL Server Database Engine, we usually see the Severity Level as in the...
2012-11-02
427 reads
Here is a typical scenario every SQL Server DBA faces: Transaction Log grows unexpectedly or becomes full!! So, do I need to increase...
2012-10-12
463 reads
When tried to empty one of the tempdb data file using the below T-SQL command: (My goal here is to...
2012-10-07
1,561 reads
Today we got an escalation where on one of the servers ‘Agent XPs’ was in a disabled state. And when...
2012-09-19
400 reads
Data isn't just about numbers and spreadsheets. It holds stories, patterns, and the answers...
By Brian Kelley
When I look at a system and think about its security model, the first...
On Wednesday May 15th 2024 I will give a free webinar on MSSQLTips.com about...
I have table TicketNumbers i TicketNumber UID 2 10 09901a22c7c3acc6786847c775f1d113 6 5 00dad28bef21f916240d6e8c1c1bd67d 12 ...
Hello Everybody, I have a database on which I try to empty a file...
My knowledge of Extended Events is limited, but I am trying to capture some...
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers