Aren't those already in source control too?

I generally dislike DACPAC, but this might be a great use of...

Also, in SQL Server, when you're looking at a clustered index, remember, that's the table. The data is stored with the clustered index. There isn't any kind of separation between...

I wouldn't worry about sp_MSForEachTable going away.

However, if we're really doing this all the time, nuking the entire database. What about just having an empty one available and run a...

Certainly, your intent is the right one. A loop is just a horrible way to code within SQL Server (depending, looping through tables for maintenance, looping through databases for backups,...

I'm always puzzled as to ask the question I had in this forum. I know a lot of people don't want to record their presentations, but I'm looking for...

If I were tuning this query. I'd take it apart. Get the root table and ensure that I'm pulling only the rows out of that in which I'm interested. Then...

I didn't even notice it earlier, but the older version of the plan had a missing join predicate. The structure of this query is in dire straights.

How big are these...

You're still looking at 2.4 million rows estimated and 46.8k actual. That's an enormous disparity. What other functions do you have in there? You also have filters that aren't doing...

Not sure that's always...

HA!!

From the reviews I've heard, I was right though.

It's a real shame. I did love the universe set...

Don't put your face in them. I stopped recording videos about 9 months ago. I'm going to get back on it, but change the format a bit. No more "video"...

I hear you. Thinking about it some more, while a bit of a pain, I don't see any way this is dangerous. Sure, you have a few more files, so...

It's estimating 1.9 million rows and moving 500k. That's my first concern, not the spool. The spool is in place so that it doesn't have to do that scan over...

The better you get at communication, the better an employee you'll be. The better you get at communication, the more likely you'll get hired. Yes, if you communicate a ton,...