August 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
rowcount

SQL SERVER – SSMS – SET ROWCOUNT – Real-World Story

April 22, 2020
Pinal Dave
SQL Tips and Tricks
SQL Performance, SQL Server, SQL Server Configuration, SSMS

Let us today talk about SSMS Query Execution configuration for SQL Server where SET ROWCOUNT settings gave us an interesting challenge with query tuning.

Read More
WMI Provider

SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable

March 31, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration

Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.

Read More
maxsize

SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size

March 19, 2020
Pinal Dave
SQL Tips and Tricks
File Growth, SQL Error Messages, SQL FileGroup, SQL Log, SQL Scripts, SQL Server, SQL Server Configuration

Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647

Read More
authentication

SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?

March 18, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?

Read More
External Data Sources

SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC

March 16, 2020
Pinal Dave
SQL
PolyBase, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration

In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC. Let us read more…

Read More
slow performance

SQL SERVER – Top Reasons for Slow Performance

February 10, 2020
Pinal Dave
SQL Performance
Ad Hoc Query, Clustered Index, Disk, File Growth, Query Hint, SQL CPU, SQL DMV, SQL Function, SQL Index, SQL Memory, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL TempDB, SQL Utility

Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.

Read More
configurations

SQL SERVER 2019 – New Values in Sys.Configurations

January 8, 2020
Pinal Dave
SQL Tips and Tricks
meta data, SQL Scripts, SQL Server, SQL Server Configuration

I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.

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

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

Go to mobile version