06 October 2019

SQL Evolution


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Resource Governor

Resource Governor  is a feature that you can use to manage SQL Server workload and system resource consumption. Resource Governor enables y...

  • DBA's Queries
    List of all 'open tran' to stop deadlocks SELECT   [tst].[session_id] AS SessionID   ,[des].[login_name] AS LoginName ...
  • Basic Server Information
    SELECT @@VERSION --Returns the version of MS SQL Server running on the instance. SELECT @@SERVERNAME --Returns the name of the MS SQL ...
  • Important Questions-SECURITY PERMISSIONS
    SECURITY PERMISSIONS Q1. What is Authentication and Authorization? What is the difference between both? Authentication is the process...