Great Post on Clearing all data from your Data Warehouse
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
414 reads
Hey there Gang !
Most of you probably know Jamie Thompson has move his blog over to SQLBlog.com. This is worth noting...
2009-09-09
414 reads
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
2009-09-08
3,539 reads
Have you ever received the following error when developing your ETL or working with data cleanup?
Msg 544, Level 16, State...
2009-09-08
581 reads
Have you ever lost your project file for a SQL Server Analysis Services database? There is a great option to...
2009-09-08
590 reads
Intellisense is one of my favorite features in SQL Server Management Studio and BIDS for 2008. A common frustration I...
2009-09-08
972 reads
When working with a dimensionally modeled data warehouse it is common for a large number of your queries to follow...
2009-09-08
6,167 reads
By Chris Yates
AI is no longer a niche capability – it is a leadership catalyst. As...
By Steve Jones
A friend was asking for help with some data analysis. This was in PowerBI,...
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Hi i was surprised to see the approach my coworkers used to sunset talend...
Comments posted to this topic are about the item People Make Odd Choices
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