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...

Nope. If it's already running, you can't retroactively start collecting the data necessary for a plan with runtime statistics.

However, on SQL Server 2019 or greater and Azure SQL Database, you...

• This reply was modified 3 years ago by Grant Fritchey.

Yeesh. Your team stacked up a bunch of jenga blocks awfully high. Have fun playing.

As to letting anyone edit them, I'd build a small app for it. No sense in exposing more than you need to.

Just that, as with anything, I'm sure there's a tipping point. "3 extended properties, no big deal, 300, 3000000, something, big deal". I honestly don't know how many zeroes you...

Total agreement, but this one that Sam will...