Michaeljswart.com

Michael J Swart. Free articles, tips and tricks. Mostly about SQL in general and SQL Server in particular.

What’s new on Michaeljswart.com: Check updates and related news right now. This site’s feed is stale or rarely updated (or it might be broken for a reason), but you may check related news or Michaeljswart.com popular pages instead. It is generally safe for browsing, so you may click any item to proceed to the site.

News, stories and media buzz related to Michael J Swart

Subscribe to related news

Incorrect Results Caused By Adding an Index
via sqlblog

It’s not often that a SQL Server bug really surprises me or makes me wonder how it was never spotted before, but this is one of those. To get right into it, say you have the following two tables: Load table T1 with 4,999 rows. All of the rows...
Imp Update: Advanced SQL Server Technology Master Class/Bangalore
via seekajob.blogspot

Dear Rajesh, Wanted to share an important update with you. The December 12 to 16, 2016, Master Class (Bangalore batch) on SQL Server Performance Tuning and T-SQL Programming, Query Tuning & Optimization has been re-scheduled & now it will be...
Data Modifications under Read Committed Snapshot Isolation
via sqlperformance

The previous post in this series showed how a T-SQL statement running under read committed snapshot isolation (RCSI) normally sees a snapshot view of the committed state of the database as it was when the statement started execution. That is a good description...
SQL Server: some links on displaying query plans
via wiert

Link dump: Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL). SET SHOWPLAN_ALL (Transact-SQL). SET SHOWPLAN_XML (Transact-SQL). SET SHOWPLAN_TEXT (Transact-SQL). Displaying Graphical Execution Plans (SQL Server Management...
SQL SERVER – Performance: Do-it-Yourself Caching with Memcached vs. Automated Caching with SafePeak
via sqlauthority

We’ve all been reading a lot of articles that suggest adding a caching layer in front of a database is more efficient than hitting the database directly. Among different caching options there is Do-It-Yourself coding, using open source tools like...

Michaeljswart.com popular pages

Michael J Swart - Database Whisperer

Michael J Swart's blog about all things database, free articles, tips and tricks. Mostly about SQL in general and SQL Server in particular.
What’s Going On Inside Tempdb? | Michael J. Swart

I discovered that digging into tempdb's transaction log using the undocumented fn_dblog is a surprisingly useful technique for finding data to help battle

sum | Michael J. Swart

The PRODUCT() Aggregate Function Okay, I’m pulling your leg a bit. There is no function defined in T-SQL that is called PRODUCT(). But everything is in place to let you build one without having to res...