Execution Plans – Merge Join

The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...

Importing images to SQL server database using T-Sql

Yesterday evening one of the developer  asked me that he need a help in importing images into a   table. It...

Security and Permissions presentation from the Baton Rouge SQL Server User Group Meeting, 3/14/2012

Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security.  This...

SQL Server 2012 Performance Test: Truncate a Date/Time to Different Parts

SQL Server 2012 introduces several new date/time functions that allow you to build a date/time from the individual parts of...

Tempdb quick notes from Professional SQL Server 2008 internals and troubleshooting

I spent sometime to understand more about tempdb today. posting some key points for our quick reference.
some key books/links on...

Webcast: What Are You Waiting For?

What was the number one question from today’s webcast on wait statistics?  Where can the slides and sample code be...

Creating cards in Trello via the REST API and parsing the returned JSON all in a SQL CLR

I recently blogged about how good I thought Trello was and shortly afterwards I found out that they did provide...

Distinct Count in Analysis Services

Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the...

Error 0xC0014062: Unable to complete login process due to delay in opening server connection

Sometimes on a heavy loaded server(many databases/connection). You may get an error log when your backup maintenance plan job gets...

Happy #Pi Day

Here’s wishing you a Happy Pi Day…

If my picture isn’t good enough, here’s a better representation of pi.

3.14159265358979323846264338327950288419716939937510
Related posts:Happy Pi...