Pinal Dave

SQLAuthority Founder - SQL Server MVP

[Pinal Dave @sqlauthority]

Let me know what you think of this new video - SUM(1) vs COUNT(1) Performance Battle #SQL #sqlserver2019 #performancetuning #SQLServer

https://t.co/ZmRT9vfBOy

[Pinal Dave @pinaldave]

Arrow in Execution Plan https://t.co/edLxai3Q1B

[Pinal Dave @sqlauthority]

Must read...

[Pinal Dave @pinaldave]

How to Add Constraint With No Validation? https://t.co/0VqET56T0B

[Pinal Dave @sqlauthority]

How to Count Week Days Between Two Dates? – Interview Question of the Week #132 https://t.co/lCpwOydmcw

[Pinal Dave @sqlauthority]

WordPress – All the IP Addresses of Comments are Same and of Local Server https://t.co/NtDVoG5E2a

[Pinal Dave @sqlauthority]

SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio https://t.co/zrQ3Q9WrxW

[Pinal Dave @sqlauthority]

SQL SERVER – Can I Delete Always On Availability Groups Initial Sync Folder? https://t.co/KufDTgGRRo

[Pinal Dave @sqlauthority]

SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations https://t.co/uQvVvl6pkb

[Pinal Dave @sqlauthority]

SQL SERVER – How to See Scripts Executing in sp_executesql? - Question: How to See Scripts Executing in sp_exec... https://t.co/3aPIcN9D6X

[Pinal Dave @sqlauthority]

SQL SERVER – Why Edition Upgrade is Not Upgrading Edition of SQL Server? https://t.co/vhkKQtff2n

[Pinal Dave @sqlauthority]

What is the Default Datatype of NULL? – Interview Question of the Week #131 https://t.co/PAExrN1edi

[Pinal Dave @sqlauthority]

SQL SERVER – Missing Columns and Other Folders in SQL Server Management Studio (SSMS) in Object Explorer https://t.co/sNPggL7oS4

[Pinal Dave @sqlauthority]

SQL SERVER – Setup Rule: Microsoft .NET Application Security. The computer cannot access the Internet https://t.co/kuLqJVYjzV

[Pinal Dave @sqlauthority]

Heimdall Data Auto-Caching for SQL Server – No Changes to Application https://t.co/ThXNFqOG3n

[Pinal Dave @sqlauthority]

SQL SERVER – Unable to Start SQL When Service Account is Removed From Local Administrators Group. Why? https://t.co/LDUnVAXFpH

[Pinal Dave @sqlauthority]

SQL SERVER – How to Pass Parameters to the Stored Procedure? https://t.co/OHiMaUNbS4

[Pinal Dave @sqlauthority]

SQL SERVER – Running CHECKDB with Minimum Repair Level - “How do I run CHECKDB with Minimum Repair Level?” When... https://t.co/u52sjo4v0D

[Pinal Dave @sqlauthority]

What does BACKUP WITH NAME Command do? – Interview Question of the Week #130 https://t.co/FvKGje68xd

[Pinal Dave @sqlauthority]

SQL SERVER – An Error Occurred While Obtaining the Dedicated Administrator Connection (DAC) Port https://t.co/i0EcEP9zkJ

[Pinal Dave @sqlauthority]

SQL SERVER – The Patch Installer has Failed to Update the Shared Features https://t.co/1DOLN1q2qP