I'd suggest adding a Continuous Integration step into your setup. Just deploy the code, without data, into a database, on commit of the code (or a push to a particular...

Stuff grows over time and we will absolutely, occasionally, make some poor choices. I would say external-internal-external-internal calls to the database are less than efficient and so, should be avoided....

I doubt there's a single video explaining that because some of that stuff is quite detailed. Take FILESTREAM for example. It's not enough to simply say that you have FILESTREAM...

Indexes?

Seems like a lot of work.

DBCC SHOW_STATISTICS

That does it.

You can also see some of this info from sys.dm_db_stats_properties, or, if you're on 2016, go straight to sys.dm_db_status_histogram...

It's called deferred name resolution. It allows you to create a procedure, view, or in your case, function, on objects that do not yet exist. It does this under the...

You can't "restore" the mdf file on its own. You can attach it though. Here's an example.

By the way, sounds like the database is in FULL recovery, but you're...

Nope. Not really. There's no tracking mechanism for table, view or index. Not like what you're asking for.

What you can do is track the queries in the system using

No money from it, but I built a database and an application that stored information about the location of veterans grave sites. This was then used by the Veterans of...

Excellent feedback. Thanks Peter. Couldn't agree more.

Jeff's on target from what I can see. I don't see both queries and locks there in a way that you can accurately associate them with one another.

Oh! Missed that. Sorry. Yeah, you're hammering your CPU with that. I'd strongly suggest stopping.

Considering there's something urgent going on, why not tell us exactly what it is that you're trying to do and then we might be able to better help. All these...

Sp_whoisactive is querying the DMVs, and, depending on how you run it, an aggregation of multiple runs. Profiler is capturing through trace events, one execution at a time, providing more...

You sure it's a table and not a function or a view? A simple select on one table shouldn't place locks on a second table, even if there are foreign...