What is the purpose of moving to AG?  You already have failover - and all the shared storage has been setup and configured - and it is working...why change it?

If...

The files should revert back to initial size on a restart of SQL Server - if that doesn't work, then you can shrink the files specifying the size (using DBCC...

I am working with a table that I have not seen before, and do not have a clear idea on what it is doing or what the data in...

When using the join only option - most likely the reason it isn't synchronizing is because a log backup was performed on the primary node prior to the restore on...

Instead of suffering for the type conversion - use CONCAT which will take care of the conversion for you:

Declare @CaptureError varchar(100) = 'This is an error'
 ...

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

We can actually simplify this even further:

Declare @endDate date = '2019-11-16';

   With groupedDates
     As (
 Select t.recid
    ...

Here is another option:

   With groupedDates
     As (
 Select t.recid
      , t.docdate
    ...

• This reply was modified 6 years, 7 months ago by Jeffrey Williams.

Hi,

i would like to generate csv file with datetime  through sql job with below power shell script.But it didn't work.

Any suggessions.

$dt=get-date -format "_yyyymmmd_HHmss"

Invoke-Sqlcmd -Query "SELECT * FROM [xxxxxx].[xxxx].[xxxxx]" -ServerInstance...

You can use Standard Edition to support the databases for Enterprise SSRS, but it doesn't save you anything since you already have to license the SSRS instance at Enterprise Edition...

Are you planning on scaling-out your deployment - if not, then I see no reason not to host everything for SSRS on the same server.  It has to be licensed...

Someone pointed out that this could be done with synonyms - which I think might be a better approach.

To identify which staging table - you can query the currently defined...

You could also just perform the restore from the file located on the original server - instead of copying the file across to the new server.  All that requires is...

SSDT does not have a built-in sFTP component - the only way to utilize sFTP is to utilize a third-party product.  The basic setup would be an Execute Process Tasks...

Are those columns indexed?  If so - then most likely the reason for the issue is that SQL Server is performing logical consistency checks on the spatial indexes and that...

The code here isn't for SQL Server - it looks like it might be for MySQL.  This forum is for Microsoft SQL Server - you would probably get a better...