Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Copy Statistics from One Server to Another Server

January 5, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Statistics
I was recently working on a performance tuning project in Dubai (yeah I was able to see the tallest tower from the window of my work place). I had a very interesting learning experience there. There was a situation where we wanted to receive the schema of original database from…
Read More

SQL SERVER – Unused Index Script – Download

January 4, 2011
Pinal Dave
SQL Performance
SQL Download, SQL Index, SQL Scripts, SQL Server

Performance Tuning is quite interesting and Index plays a vital role in it. A proper index can improve the performance and a bad index can hamper the performance. Here is the script from my script bank, which I use to identify unused indexes on any database. Let us see script for unused index.

Read More

SQL SERVER – Missing Index Script – Download

January 3, 2011
Pinal Dave
SQL Performance
SQL Download, SQL Index, SQL Scripts, SQL Server

Performance Tuning is quite interesting and Index plays a vital role in it. A proper index can improve the performance and a bad index can hamper the performance. In this blog post we will discuss about Missing Index.

Read More

SQL SERVER – Reduce the Virtual Log Files (VLFs) from LDF file

January 2, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, VLF
Earlier, I wrote a quite note on SQL SERVER – Detect Virtual Log Files (VLF) in LDF. Because of this I got responses suggesting too many VLFs are bad for log file. This prompts to a simple question: “How many is ‘too many’ VLFs?” I suggest that you go and read…
Read More

SQLAuthority News – Resolution for New Year 2011

January 1, 2011
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
Today is the first day of the year so I want to write something very light. Last Year: 2010 Last Year was a blast; really traveled a lot. My family and I went on vacation. There I enjoyed being father, rolling on the floor and playing with my daughter. Here…
Read More

SQLAuthority News – Community Service and Public Speaking Engagements

December 31, 2010
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News
SQLAuthority Book Review
Today is the last day of the year and I was going over my memories for year 2010. Almost all of them are good and I feel for sure better person in terms of knowledge, nature and overall human being. Looking back at the year, it is very satisfying as…
Read More

SQL SERVER – Detect Virtual Log Files (VLF) in LDF

December 30, 2010
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, VLF
In one of the recent training engagements, I was asked if it true that there are multiple small log files in the large log file (LDF). I found this question very interesting as the answer is yes. Multiple small Virtual Log Files commonly known as VLFs together make an LDF file.…
Read More
Previous 1 … 600 601 602 603 604 605 606 … 829 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version