Setting your predicate arguments at run time Part: 2 MultiSelect

 
Introduction
A few days ago, I did a presentation for a Virtual Chapter meeting where I discussed SQL Server Data Access...

SQL Cruise competition, and the winner is …

Earlier this month SQL Cruise, (an initiative created by Tim Ford (B|T)) and Dell Software announced a competition to win...

SQL SERVER – SQL Server Configuration Checking – A Must Do for Every DBA – Notes from the Field #004

Originally posted on Journey to SQL Authority with Pinal Dave:
[Note from Pinal]: This is a fourth episode of Notes from...

SQL Server Data Tools (SSDT) – October 2013 update

Since my last post about the SSDT update for August, there have been two updates, each containing one fix:
The September...

The World Needs More A/B Testing

Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to...

Things I've Learned In Regards To Fill Factor:Quick Tips

I don't have much today... It's been a good week so far. I think I'm becoming a bit obsessed with...

An application error occurred on the server running on SQL server

AdvertisementsRecently one of my application website went down.
 

I checked all the basic connectivity troubleshooting and seem everything was looking and...

Case Statement/ Expression in SQL Server

Case Statement/ Expression in SQL server 
 
Sometimes we need to get one result output from multiple possible outcomes based on the...

Fill Factor, Why Do You Taunt Me? Part 3

Let's look at something a bit more in depth. Let me start by saying, "Please don't arbitrarily change any default...

Finding the metadata for a query

You know I occasionally find it interesting how I learn new things. I was running through a practice test for...