Subscribe to this blog
PracticalSQLDba
I have total of 11 years of IT experience with Application development, Database Development and Database Administration. I have worked with different version of SQL server from 7.0 to 2008.Started my carrier as VB ,VC++ and database developer in a banking sector for implementing their core banking solution. Currently working as Database Administrator with wide knowledge in performance tuning, high availability solution, troubleshooting and server monitoring. This blog is my humble attempt to share my knowledge and what I learned from my day to day work.
Archives: June 2012
How Local Variable or Optimize for Unknown Resolve Parameter Sniffing
In my last post , we have gone through the parameter sniffing and possible solutions for parameter sniffing. In the possible solutions except the local variable and Optimize For Unknown are very straight forward solution and we know how they helps us to resolve the issue.In this post we will…
0 comments, 1,017 reads
Posted in PracticalSQLDba on 27 June 2012
SQL Server : Parameter Sniffing
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure. Her complaint was one stored procedure is taking long time from the application but completing in two seconds in SSMS.I told her it might be due to parameter sniffing but…
9 comments, 3,794 reads
Posted in PracticalSQLDba on 25 June 2012
Connection Pooling :At a Glance
What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the application server so that these connections can be reused when future requests to the database are required.Creating a connection to the database servers is a time consuming process.To establish…
0 comments, 1,823 reads
Posted in PracticalSQLDba on 15 June 2012
SQL Server : Moving System, resource and User Databases to New SAN disk
In my earlier post I have explained the steps that we have followed to move the MSDTC and Quorum drive to the new SAN. In this post let us go through the steps that we have followed to move the System,Resource and User databases to the new SAN.The environment that…
6 comments, 2,277 reads
Posted in PracticalSQLDba on 12 June 2012