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 […]
administration / Azure / Database / Errors / MSSQL
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 […]
administration / Errors / TSQL
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 […]