Tiho's blog

I'm putting this here so that I don't forget where to look for it later when I need it as it has already happened in the past. Mike has a great post which is full of links to other great posts on the topic. Read More...

After spending some time to find out that there is no easy way to drop all indexes from a SQL table I came up with this script. DECLARE @indexName NVARCHAR(128) DECLARE @dropIndexSql NVARCHAR(4000) DECLARE tableIndexes CURSOR FOR SELECT name FROM sysindexes Read More...

Brad Abrams on volatile and MemoryBarrier() . Someone sent this to the team and I couldn’t stop myself from reading it. If you use the double check locking pattern, then most probably you are already aware of the pitfalls in it. Using volatile introduces Read More...