@sqlauthority profile picture
Pinal Dave @sqlauthority

SQLAuthority Founder - SQL Server MVP

Joined February 2009
  • Tweets 17,178
  • Following 1
  • Followers 1,700
9 Photos and videos
Let me know what you think of this new video - SUM(1) vs COUNT(1) Performance Battle #SQL #sqlserver2019 #performancetuning #SQLServer youtube.com/watch?v=rtcLpnQq…

SUM(1) vs COUNT(1) Performance Battle - SQL in Sixty Seconds 177

SUM(1) vs COUNT(1) Performance Battle. This video is created based ...

youtube.com
2
Pinal Dave retweeted
Pinal Dave
@pinaldave
26 Jun 2021
Arrow in Execution Plan bit.ly/3o9Hdm8
1
4
Must read...
Pinal Dave
@pinaldave
27 Jun 2021
How to Add Constraint With No Validation? bit.ly/3geFpGy
2
How to Count Week Days Between Two Dates? – Interview Question of the Week #132 ow.ly/FsN450cYQQ9
1
6
WordPress – All the IP Addresses of Comments are Same and of Local Server ow.ly/GsBY50cXTg8
SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio ow.ly/KtNp50cWx7h
1
1
SQL SERVER – Can I Delete Always On Availability Groups Initial Sync Folder? ow.ly/bJyI50cV43E

1
2
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations ow.ly/761I50cTA2H
1
4
SQL SERVER – How to See Scripts Executing in sp_executesql? - Question: How to See Scripts Executing in sp_exec... ow.ly/RZgx50cS57F
1
1
SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server? ow.ly/sm8a50cQCaU
What is the Default Datatype of NULL? – Interview Question of the Week #131 ow.ly/hn6R50cPF5b

What is the Default Datatype of NULL? - Interview Question of the Week #131 - SQL Authority with...

Question: What is the Default Datatype of NULL?

blog.sqlauthority.com
1
2
SQL SERVER – Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer ow.ly/7V1950cOFVq
1
SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet ow.ly/vkHB50cNhp7
Heimdall Data Auto-Caching for SQL Server – No Changes to Application ow.ly/keTe50cLNwJ

Heimdall Data Auto-Caching for SQL Server - No Changes to Application - SQL Authority with Pinal...

I found a unique caching solution that accelerates SQL Server. Heimdall Data auto-caches and auto-invalidates, removing complex configuration. It requires zero changes to your application and...

blog.sqlauthority.com
1
SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why? ow.ly/D21J50cKkB1

SQL SERVER - Unable to Start SQL When Service Account is Removed From Local Administrators Group....

One of my clients wanted to secure their SQL Server. One of the rules was that wanted to avoid running SQL Server service with an account which is part of local “Administrators” group. They wanted to...

blog.sqlauthority.com
SQL SERVER – How to Pass Parameters to the Stored Procedure? ow.ly/MuJG50cIPCN
SQL SERVER – Running CHECKDB with Minimum Repair Level - “How do I run CHECKDB with Minimum Repair Level?” When... ow.ly/jlKX50cHoc7
What does BACKUP WITH NAME Command do? – Interview Question of the Week #130 ow.ly/fL3450cGrQL

What does BACKUP WITH NAME Command do? - Interview Question of the Week #130 - SQL Authority with...

Questions: What does BACKUP WITH NAME Command do?

blog.sqlauthority.com
1
SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port ow.ly/7v8o50cFtGV

SQL SERVER - An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port -...

Microsoft SQL Server has given an option to connect to SQL Server when normal connections can’t be made because of any reasons. This feature is called as Dedicate Administrator Connection (DAC). You...

blog.sqlauthority.com
SQL SERVER – The Patch Installer has Failed to Update the Shared Features ow.ly/Ggbq50cE384

SQL SERVER - The Patch Installer has Failed to Update the Shared Features - SQL Authority with...

Applying a patch in SQL Server is a planned process which is followed across various companies. Most of the companies take time to apply the patch to make sure the stability of the patch can be...

blog.sqlauthority.com
Load more