@sqlauthority

SQLAuthority Founder - SQL Server MVP

 India
blog.SQLAuthority.com
Joined February 2009
  • Tweets17.2K
  • Following1
  • Followers1.7K
9Media
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
@pinaldave26 Jun 2021
Arrow in Execution Plan bit.ly/3o9Hdm8
1
4
Must read...
Pinal Dave
@pinaldave27 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
2
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...

What is the Default Datatype of NULL? Most people say NULL has no type. A quick SELECT INTO test shows which datatype SQL Server actually picks.

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

Parse and compile time: SQL Server examples

Parse and compile time is the first line of STATISTICS TIME. See why the second run shows 0 ms and what makes a statement compile again.

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....

When the service account is removed from local Administrators group, SQL Server may not start. Here is why, and the minimal permissions it needs.

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...

What does BACKUP WITH NAME do? It simply names your backup, and you can then find that name in the msdb backupset table. Here is a quick example.

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 -...

A student could not connect with the Dedicated Administrator Connection (DAC) after my class. Here is the port error he saw and how to fix it.

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...

Under a tight downtime window, a client got "The patch installer has failed to update the shared features". Here is what the logs showed and how we fixed it.

blog.sqlauthority.com
Load more