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 


Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

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)

My Profile

  • Kumar K Shiva
  • Unknown
  • kumar shiva

Total Pageviews

Pages

  • Home
  • How to read Alert and Listener logs from SQLPLUS
  • Useful Oracle metalink notes
  • Renaming table: How does that affect the associate...
  • Identify Oracle Process ID and related SQL
  • Local Indexes for Partitioning
  • Historical Growth of Tablespace
  • Converting to millions and more
  • Some Useful SQLs for Partitioning
  • Explain plan for SQLs
  • How to find IP address of a server
  • Oracle DBA Interview Questions
  • Schedule snapshot collection in Statspack reports
  • Script for Health Check of Database
  • Collect and report Linux System Activity Information with sar
  • Move table and dependent LOB to other tablespace
  • To make all the datafiles of the database or a tablespace in autoextend mode
  • grep next / previous few lines of key word
  • Good Linux / Unix System Admin Commands for DBA
  • find (grep) the last few lines of many files in Li...
  • Check Hardware configuration of Linux Box
  • Change column width of show parameter in SQL Plus
  • Monitoring CPU output on Solaris and report in exc...

Flag Counter

Flag Counter

Supercounters


Subscribe To

Posts
Atom
Posts
All Comments
Atom
All Comments

Selaris Counter

Free Essay Buy Custom Essay answering service Free Counter
Counter Free

Disclaimer

Disclaimer: All data and information provided on this article is for informational purposes only. Author makes no representations as to accuracy, completeness, suitability, or validity of any information on this article. All information is provided on an as-is basis

Live Traffic Stats

Disclaimer: All data and information provided on this article is for informational purposes only. Awesome Inc. theme. Powered by Blogger.