SQL Server Database Recovery

Removing Bottlenecks to Improve Performance of SQL Server

When you are looking to improve the performance of a SQL Server implementation you need to look at the issue in a holistic manner. From giving thought to how the deployment is planned out to how the application logic is addressing the data, a host of issues have to be factored in. You would also need to minutely go through the schema design and also visualize the scalability issues affecting your system. Even minuscule things like the data types you choose for a specific field can have an...

Read more »

Quick tips to improve the performance of SQL Server Queries

The SQL Server database application from Microsoft is known for its capacity to handle numerous queries in real time in an effective manner. However with every database system, inefficient querying can place an inordinate amount of load on the server which would eventually make it slow to respond when a flood of queries comes through. As a database administrator, you should always be looking at improving your database application and optimizing your SQL queries with an eye on improving overall...

Read more »

Using Solid State Drives to Improve the performance of SQL Server

In a competitive world where time is a critical constraint, businesses are always in the lookout for technological innovations that can give them an added advantage over their peers. Now if your SQL Server driven application is able to process data requests at a higher speed and become less prone to crashes then it can surely give a flip to your business applications. By using solid state drives(SSDs) instead of traditional mechanical hard drives, you can eliminate IO issues with ease and...

Read more »