June 2022 Discount: Comprehensive Database Performance Health Check | Testimonials

  • 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
  • Training
suspended

SQL SERVER – SUSPENDED Sessions Waiting on PAGELATCH_UP and PAGELATCH_SH – Solution

June 26, 2019
Pinal Dave
SQL Performance
SQL FileGroup, SQL Memory, SQL Server, SQL TempDB, SQL Wait Stats

Their server got tremendously slow with many sessions suspending in the status of SUSPENDED status and they were waiting on PAGELATCH_UP and PAGELATCH_SH.

Read More
Temp Tables

SQL SERVER – DROP Multiple Temp Tables Using Cursors on Azure

June 21, 2019
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Scripts, SQL Server, SQL TempDB, Temp Table

SQL Server Expert Ahliana Byrd has written a very interesting script to DROP Multiple Temp Tables Using Cursors on Azure, which we have included today.

Read More

SQL SERVER – 5 Performance Optimizations Must Do for TempDB

June 19, 2019
Pinal Dave
SQL Performance
SQL Data Storage, SQL Scripts, SQL Server, SQL TempDB

We fixed quite a lots of things at customer place with regards to TempDB and he finally was able to get “the Flash” fast performance.

Read More

When Was SQL Server Last Restarted? – Interview Question of the Week #225

May 19, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL DMV, SQL Scripts, SQL Server, SQL TempDB, Starting SQL

Question: When Was SQL Server Last Restarted?

Read More

SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation

February 2, 2019
Pinal Dave
SQL
Shrinking Database, SQL Error Messages, SQL Scripts, SQL Server, SQL TempDB, Starting SQL

Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation.

Read More

SQL SERVER – FCB::Open Failed – TEMPDB Files Fail to be Created with Error: “CREATE FILE Encountered Operating System Error 3”

January 21, 2019
Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server, SQL TempDB

Once there was an urgent request from my client and they asked my assistance. Without wasting any time, I sent them GoToMeeting invite and started working. In this blog we would learn how to fix FCB::Open failed for TempDB database.

Read More

When to Use sort_in_tempdb for Rebuilding Indexes? – Interview Question of the Week #207

January 6, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts, SQL Server, SQL TempDB

Question: When to Use sort_in_tempdb for Rebuilding Indexes?

Read More
Previous 1 2 3 4 5 6 7 8 … 11 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version