Download Attachments from Exchange Web Services using SSIS
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
5,101 reads
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
5,101 reads
I recently worked on an engagement where the requirement was to process excel spreadsheets sent to a group mailbox hosted...
2016-03-11
309 reads
In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of...
2015-10-08 (first published: 2015-09-29)
3,160 reads
There’s been an excellent free solution for documenting SSAS metadata in multi-dimensional models for quite some time: http://www.purplefrogsystems.com/blog/2010/09/olap-cube-documentation-in-ssrs-part-1/.
I had the...
2015-09-09
1,242 reads
I’ve seen many a blog post about migrating SQL Agent jobs across instances using PowerShell, SMO, T-SQL, and the like....
2015-05-26
1,693 reads
Intro
AlwaysOn availability groups are a powerful enhancement to SQLServer HA, and offer many improvements over older database synchronization techniques like...
2015-05-15 (first published: 2015-05-05)
6,812 reads
Intro
This blog post is designed to be useful to two different audiences:
Those implementing Ola Hallengren’s Maintenance Solution for the first timeThose...
2015-04-16
6,008 reads
I recently worked on a project where the client requested to “remove all of the unused jobs” that had been...
2015-04-09 (first published: 2015-04-01)
8,457 reads
Background
DAX offers many powerful time intelligence functions that can be applied at virtually any level of a date / time hierarchy....
2015-02-13 (first published: 2015-02-04)
6,617 reads
This is a short, but hopefully sweet post for someone, whom, like me, might have had to end up spending...
2014-12-03
2,690 reads
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call...
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item People Make Odd Choices
Comments posted to this topic are about the item SQL Server 2022 Clusterless Distributed...
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers