Well, I moved half way across the continent on top of everything else, so, no, things are not what I would call normal, but they're pretty darned close. The one...

Thanks....the 2 tables in question are pretty small and have same amount of rows in both UAT & PROD

I've updated the STATISTICS on both tables and waiting for...

When it comes to index maintenance, I defer to Jeff.

The only I want to add here is that, as he stated, columnstore is a different ball of wax. Here's...

I'd suggest taking a look at sqlcmd instead of bcp. There's a ton more functionality there. While you can run sqlcmd, or bcp, from xp_cmdshell, it's not considered...

Think of it this way, you're looking for the second space ' '. That's how you solve this.

If you use the command line with SqlPackage.exe - one of the options available is a log file.  Instead of importing using SSMS - use the command line with...

I know of no way to do that beyond simple testing. Sorry.

I don't think that runing the import process of a dacpac is logged individually anywhere. The statements that create the database, tables, etc., are certainly logged (and maybe just getting...

I'm perfectly happy to help with homework.

Help.

So, where are you stuck? What have you tried that didn't work? Show me your work, and I'll be happy to toss in some...

Hey Brandie,

Honestly not sure on this one. I just wanted to let you know that someone at least looked at the question.

Look at the join criteria within the details of the operator and see what the likely output from that is, based on the statistics provided. Additionally, see if there are...

Probably your best bet is to export the database to flat files. You could try reading from the tables into another database too. Otherwise, you may be down to trying...

1. I'm sure with some work, I could find exceptions, but the overall rule is easy here, statistics updates are radically less resource intensive than index rebuilds. It's not even...

Rebuilding an index does two things. First, since you're literally rebuilding the index, it reorders the pages and the rows on those pages. This has a benefit in that it...

Restarting SQL Server does a whole ton of things. First, you're flushing memory. So queries coming along after the reboot have a clear memory run to load up just their...