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
792 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
792 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
927 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
396 reads
When an error is raised by the SQL Server Database Engine, we usually see the Severity Level as in the...
2012-11-02
436 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
474 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,571 reads
Today we got an escalation where on one of the servers ‘Agent XPs’ was in a disabled state. And when...
2012-09-19
407 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers