SSMS 18.X error when creating NonClustered index This seems to be a bug in SSMS as the index can be created using TSQL just fine here is the […]
Why does the query throw NULL and Schrödinger’s cat?
An interesting problem came up in #SQLHelp today. The query is fairly simply and aims to generate a random distribution of value 1,2 and 3. I am not […]
Online Indexes Failures in Azure for VLDBs
Recently we had a requirement that was caused by a very unique situation. A table with a column of datatype nvarchar(max) was inadvertently populated with some text in […]
Snapshot isolation level when database is set to read only.
Recently there was a question posted on #sqlhelp about why a database switched to Snapshot isolation level when you make it read only and then reverts back to […]
Cannot use row granularity hint on the table
Got approached with the below error message recently and thought it might be an interesting problem to look into. ProgrammingError((\’42000\’, 651, \'[Microsoft][SQL Server Native Client 11.0][SQL Server]Cannot use […]
SQL 2016 – Possible bug in temporal tables
I am not sure if this has been raised before, it seems like a very common scenario that I am sure most people will encounter but I wasn’t […]
Exception Message: The client could not finish the operation within specified timeout. Killing the lease on a file in Azure BLOB
Exception Message: The client could not finish the operation within specified timeout. When backing up a database to the cloud if the network connectivity is slow or if […]
A Nonrecoverable I/O error occurred – when restoring the database from a Cloud URL in SQL 2014
When restoring the database from a cloud URL there is a chance you will encounter the below error. Msg 3271, Level 16, State 1, Line 1 A nonrecoverable […]
Visual Studio crashes after loading toolbox
A quick post for an annoying problem that creeps up with Visual studio. I get this issue occasionally and it has to do with the TBD files used […]
Not getting options when right clicking the report in report manager
I came across this issues today while doing a training today reporting services report manager doesn’t display the options when you right click the report . See the […]