Even if you have a prior agreement - and the provider is sending the data in YYYY-MM-DD format you could still have problems depending on the data type...

• This reply was modified 3 years, 5 months ago by Jeffrey Williams.

You also need to remove the SSIS maintenance agent job - but other than that there shouldn't be any issues.  That system will still think it has been configured though...

As I have stated in your thread at SQL Teams - using SSIS for what you are trying to accomplish is going to be much more work than utilizing SSRS. ...

Actually, the development team should have nothing to do with how the data in the db is physically stored.  That's the DBA's job.  (Sorry, just had to...

Actually, the development team should have nothing to do with how the data in the db is physically stored.  That's the DBA's job.  (Sorry, just had to say that...

• This reply was modified 3 years, 5 months ago by Jeffrey Williams.

There isn't anything that states you must have a separate filegroup for each partition - in fact, you could have all partitions in the same filegroup or split across 2...

When the preference is set to secondary only - log backups must occur on the secondary node without copy_only.  When you perform the log backups on the primary node Ola's...

It's free.  Try it.  If it doesn't work out, upgrade to the Standard Edition.

And do heed Steve's warning about not being able to create jobs or schedule them.  As...

You cannot prove that a date like 2022-05-09 is actually in the YYYY-MM-DD format.  For example, in SQL Server in the English Language, that will be YYYY-MM-DD but, if...

I suggest you consider writing a stored procedure, with parameters, to return your desired dataset. This sort of thing:

CREATE PROCEDURE dbo.GetSomeData @StartDate DATE, @EndDate DATE
AS
SELECT t.c1,...

There really isn't an 'online' redo logs in SQL Server - but there can and will be transactions in the log that have not yet been backed up.  In the...

What did you change?  Is...

The problem with using IP address alone is that there's no indication that you wish to connect to the specific \SQLSRVR2008 instance.

If you set the IP port number for...

Part of the problem is that SQL Server implicitly converts the results to a higher precision than you specify for one or both of the operands.  If it didn't do...

One of the problems with Ola's utilities is that it relies on arbitrary limits to determine when to use REORG vs REBUILD.  In fact, you are probably going to hear...