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 – Enable PowerPivot Plugin in Excel

March 7, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
PowerPivot
Recently I had interesting experience at one conference. My PowerPivot plugin got disabled and I had no clue how to enable the same. After while, I figured out how to enable the same. Once I got back from the event, I searched online and realize that many other people online…
Read More

SQL SERVER – Running Multiple Batch Files Together in Parallel

March 6, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts, SQL Utility
Recently I was preparing a demo for my next technical session, I had to do run a SQL code in parallel. I decided to use Batch File to run the code. I am not the best guy to with command shell so I did it with following setup. Code of…
Read More

SQL SERVER – Concurrency Problems and their Relationship with Isolation Level

March 4, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
Concurrency is simply put capability of the machine to support two or more transactions working with the same data at the same time. This usually comes up with data is being modified, as during the retrieval of the data this is not the issue. Most of the concurrency problems can…
Read More

SQL SERVER – Demo Script – Keeping CPU Busy

March 3, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Scripts
Recently face very interesting situation, during presentations at event, I was asked very famous questions: “My CPU is very high all the time, how can I reduce it?” This is very interesting question and there are many answers and a single blog post is not good enough to justify this…
Read More

SQLAuthority News – Uncut and Unedited Video Interview of Pinal Dave

March 2, 2011
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
Earlier this year Lohith (@kashyapa) from Bangalore took my ‘Uncut and Unedited’ video interview. It was really fun to answer his questions as it was very different from regular interview. He asked few personal details few technical details and made me show few secrets. [youtube=http://www.youtube.com/watch?v=k3yLkPt2LIc] I think if you want…
Read More

SQLAuthority News – Pinal Dave: Blogger, MVP and now Interviewee by Michael J Swart

March 1, 2011
Pinal Dave
Personal, SQL, SQL Server, SQL Tips and Tricks
Michael J. Swart is a very unique person. I have often exchanged emails with him and also used a couple of his scripts in my presentations (with his permission). Every time I conduct spatial database presentation, I always start with his script where he has drawn the wonderful image of…
Read More

SQL SERVER – Best Reference – Wait Type – Day 27 of 28

February 27, 2011
Pinal Dave
SQL, SQL Server, SQL Tips and Tricks
SQL Wait Stats
I have great learning experience to write my article series on Extended Event. This was truly learning experience where I have learned way more than I would have learned otherwise. Besides my blog series there was excellent quality reference available on internet which one can use to learn this subject…
Read More
Previous 1 … 325 326 327 328 329 330 331 … 536 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version