Here's a fast one I just stumbled across. Since, I'm pretty sure I've made this mistake before I thought I'd write it down in an effort to prevent myself from enduring another Groundhog Day moment. (Yes! I just managed another pop culture reference in an otherwise dry and lifeless technical blog post! Stay tuned till… Continue reading Computed Column With A Date: Computed column cannot be persisted because the column is non-deterministic
When deploying code I try to create my scripts so they can be rerun without an error being thrown (e.g. "object already exists"). There's some fancy word for this that I used to try and use so as to appear ostentatious but it turns out people found me ostentatious even when I didn't use the… Continue reading SQL: Create Schema If Not Exists
This article falls into the half baked posts category. Once I figured out how to compare two variables and then overwrite one with a script task in SQL Server Integration Services, I also realized I did not in fact need to perform the task. Doh! Still a useful bit of code though so I'm posting… Continue reading SSIS Compare Variables And Change One With A Script Task
Nooooooooo! Power outage+unsaved files SQL Server Management Studio files=Panic!!! Wait a sec. Don't panic. Every modern application, especially Microsoft apps, prompts you after a crash and asks you if you want to recover your lost files right? Right!?! Somehow, SSMS does NOT include this feature. Why? No idea. Blame Management Studio's stability. It rarely shutsdown… Continue reading SQL Server Management Studio: Recover Lost Files
Warning! This post is barely finished. I putting it up as a reminder to myself that I had a hard time finding a post explaining how to do it and I should write a post on it. "It's impossible" they said. "It can't be done!" they claimed. "You're mad (but still surprisingly handsome!)" the women… Continue reading Create A List In Your SSRS Tooltip: Not Impossible!
Alright. MAX on rows *and* columns. This was a bit of a mind bender. A fellow SQL Server Developer was wondering if it was possible to find the MAX and MIN values of multiple rows and columns and then compare it to a value on a single row. Of course this could be done by… Continue reading Compare a Row to the MAX of Multiple Columns and Multiple Rows: The Easy Way
Are you trying to use a stored procedure as the source of a SQL Server Integration Services (SSIS) data flow task? If your stored procedure contains a temp table you may run into the message "No column information was returned by the SQL command" (complete error message below). Although there are a number of solutions… Continue reading SSIS: No column information was returned by the SQL command
Preparing to do some MDX performance testing? Step one for each and every test should be to clear the cache. This will ensure you are seeing the performance results without the benefit of having data already loaded up in memory. How do you empty the MS SQL Analysis Services cache prior to running your query?
Whenever I want to check a setting in SQL Server I always prefer to find it using a query. Every once in awhile these settings turn out to be on the verge of being undocumented. This is the case with table level lock escalation (also known as partition level lock escalation). The T-SQL query below… Continue reading SQL Server Partition Lock Escalation Property Query
Need to find the default schema for a user in MS SQL? Need to confirm all your SQL Server users default schema's are set correctly? Easy peasey. Run the following query and enjoy.