Creating a Scheduled Task that runs under a gMSA requires PowerShell.The Task Scheduler GUI insists on a password you don’t have. Problem I wanted to define a specific schedule to run a task: start at 08:00 stop at 15:00 after starting, repeat every 15 minutes only on Monday, Tuesday, and Wednesday At first glance, this […]
New-ScheduledTaskTrigger: limitation and workaround. Read More »
The problem: I was checking the query store of a database where performance testing was done.The top CPU resource consumer was a simple query on 1 table with a perfect covering index, but the query plan looked more complicated than expected. The problem? The varchar(max) datatype of parameters in the query didn’t match the data
Use (n)varchar(max) parameters only when you really need to. Read More »
When you use the Query Store, you could miss load on your database if query’s are launched from another database. Query’s are stored in the database from where they are launched. Let me show you this with an example. We have a query that is launched from the AdventureWorks2019 database. It doesn’t touch any resources
Cross-database query’s and Query Store Read More »
