Hello,

I recently migrated from 2012 to 2016 SQL server.  When comparing SSRS reports, the new server is showing the records as exactly double.

Troubleshooting/Background -Data is being pulled from a...

https://ola.hallengren.com/downloads.html - these has maintenance data scripts.

Others you have to use Audit, XEvent Profiler etc based on your requirement

We get a bunch of tasks/requests to run t-sql scripts...

I take the opportunity to explain that I wanted to explore ssis because I'm migrating databases from Access to SQL, but in Access I can use code to do...

There is no information you have provided that we can use to help you.

Is the high CPU usage on all nodes, or just the primary?  If it’s just the primary, do you have synchronous or asynchronous commits? If it’s async, is tempdb significantly...

• This reply was modified 3 years, 2 months ago by Michael L John.

What if the secondaries are not read only?

For question #1, just do a test.  I think that you'll find that the stats take a lot longer because Index Rebuilds only affect/rebuild the columns they actually use. ...

Is it Monday?  It seems like Monday.

One of my DBA's set up a SQL account, with db_owner on a database in production.  The contractors have now raised havoc with this...

Does this thread help?

https://www.sqlservercentral.com/forums/topic/how-do-i-write-a-record-for-each-day-in-a-date-range

None of your questions are out of a senior level person's knowledge and understanding.

Does 10 years indicate a senior level position?  Maybe not.  The time on a job is no indication...

In the properties of the Scheduled Reports folder, is is set to inherit permissions from parent?

What are you asking?

If you are looking for any information about the job, schedule, and...

Are any thredizens going to be in Atlanta for SQL Saturday BI Edition???

No work done. This was escalated, but there is a  BBPress upgrade, that requires a WP upgrade, which depends on a PHP upgrade, which was held for an OS...

That's handy, Michael, but we're not ready as a company to embrace the use of PowerShell.   I'm going to create a new table that we can refresh via a...