Hi Michael.  Without going into my reason, I need to know the sum of CPU usage for ad-hoc batches of SQL statements I execute, on a per-database and per-time-window...

This is the third post related to CPU usage you have made.

What are you trying to determine?  What issue are you trying to solve?

You can certainly write a T-SQL script and run it in a SQL job to kill connections.   However, it's not going to kill a connection in a rollback state.  You...

Is backup verify option available with third party tools (DDBoost or Lite speed or Redgate) like native backup in sql? What are the negative impact using backups with verify...

How?

I'm almost out of "off the top of my head questions" but, just to be sure, are you taking DIF backups and mistakenly naming them BAK like your FULL...

I have a SQL 2012 database with simple recovery that backs up every night.  Normally the backup file is around 87,000 MB and grows proportionality as data is added. ...

The table #LastLogin as well as sys.server_principals contain the column default_database_name.

In the query where you join both of these, you are referencing that column.  SQL cannot determine which table it...

Your code does not run properly.  The create table statement  throws an error.

Can you use the CODE button to properly insert code?

So have existing 2016 SQL instance and SSRS on same box. They need to upgrade ssrs to 2019. I was going to do in place for sql instance first...

Have you read this link:

https://docs.microsoft.com/en-us/sql/ssms/scripting/sqlcmd-use-with-scripting-variables?view=sql-server-ver15

It's pretty clear how to do this.

Sure. So is learning how all of the pieces move in the game of Chess.  You can memorize how all of the pieces...

Hi,

I've inherited an existing system. We've had an issue with our application connecting to the SQL back-end. The port number of the instances is 1433 and the AG Listener...

Good morning,

We had one of folks put in a request to have a database taken offline.

This is the only database in an AG.  This, of course, made the AG...

There is no such thing. ...