SQL Server +0 and -0
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,551 reads
This is a very interesting error happened in one of my clients’ databases. Their database has been running for at...
2013-04-30
1,551 reads
SQL Saturday 198, http://www.sqlsaturday.com/198/ ; is coming to Vancouver Feb 16 this year. As of now, 56 sessions are collected from...
2013-01-09
813 reads
We know that we need to take special attention about NULL values while writing queries because they may lead us into...
2012-12-26
1,928 reads
Inserted and deleted tables are 2 pseudo tables preseting the before and after images of modified rows. They can only...
2012-10-17
2,341 reads
Do you think it’s a good idea to add UPDLOCK hint to the table which will be modified in an...
2012-10-10
1,325 reads
location: AppendOnlyVerStoreMgr.cpp:776
Expression: 0
SPID: 64
Process ID: 4912
Description: Cannot locate version record and page is not allocated. Status = 3
Msg 3624, Level 20,...
2012-09-10
1,156 reads
Quite often people need to write a new T-SQL application to replace an existing one for various reasons. For instance,...
2012-07-06 (first published: 2012-06-29)
4,136 reads
With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...
2012-06-26
2,730 reads
I run into a bug recently with SQL Server 2012. I believe this exists in SQL Server 2008 as well....
2012-06-20
1,075 reads
DBCC WritePage is a dangerous undocumented DBCC command. It’s useful in your sandbox to change data, crash objects, and do...
2011-11-23
2,595 reads
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers