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,982 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,345 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,338 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,168 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,076 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,639 reads
SQL doesn’t really give us too many tools out of the box to allow...
Did you know that you can change the browser used by SQL Server Management...
By DataOnWheels
A few months ago, I wrote a post on how I use voice technology...
Hi All, Our server team is planning to move secondary data centre from one...
Hello everyone, I am importing from a csv file into a table. Everything works...
Hi all, The app server is running on Linux. SQL server is running on...