Kumar's Page for DBAs, SysAdmins, DevOps & beyond
A few pages For SQL SERVER
How to: Find the Objects That Have the Most Locks Taken on Them
Checking the Stored Procedures
Execute UPDATE STATISTICS for all SQL Server Databases
Good SQL Server Websites
https://sqlserverperformance.wordpress.com
http://www.sqlservercentral.com/blogs/glennberry/
track and log SQL Server stored procedure usage
for non-Enterprise Edition
Querying the SQL Server System Catalog FAQ-2008R2
Stale Statistics
sqlserver performance tuning for stored procedures
Transactions and Locks in SQL Server
SQLSERVER - Object Management
How to determine the version and edition of SQL Server and its components
Handy tips for SQL Server
SQL SERVER DBA – TOPIC WISE FAQs
Retrieving Deadlock Graphs with SQL Server 2008 Extended Events
No comments:
Post a Comment
Home
Subscribe to:
Posts (Atom)
Blog Archive
▼
2020
(1)
▼
January
(1)
For Cloud DBAs - AWS
►
2019
(1)
►
March
(1)
►
2017
(1)
►
October
(1)
►
2015
(1)
►
March
(1)
►
2014
(2)
►
October
(1)
►
July
(1)
►
2010
(2)
►
November
(2)
►
2009
(2)
►
May
(2)
No comments:
Post a Comment