One reason for available memory not being used is inappropriate memory grants.  Make sure that you are updating your statistics regularly.

John

No, but I'd be surprised if you noticed it.  You're filtering before writing to disk, so I think it's quite a lightweight process.

John

Just remove the quotes from round GETDATE() in the CREATE TABLE statement.  I don't recommend named constraints for temp tables (like in your second example) since it may harm concurrency:...

I think you'll need to capture actions from all principals and then filter out the stuff you don't want at server audit level.  Here's an example:

CREATE SERVER...

Not sure exactly what you're after here - please supply some sample data and expected results.  You can use TRY_CONVERT to verify whether a string can be converted to a...

• This reply was modified 6 years, 8 months ago by John Mitchell-245523.

Without seeing the execution plans, I'm guessing.  What I imagine is happening is that the query optimizer does not know the value of the variable at compile time, and so...

It is, yes.  You'll find the correct syntax here.

John

Edit: even when you get the syntax right, you're always going to get the value "02:30".  It looks as if you...

• This reply was modified 6 years, 8 months ago by John Mitchell-245523.

If you no longer have your log backups, you can only restore to a full or differential backup.  Point-in-time restores are only possible with log backups.

John

Those errors couldn't have come from the code you posted.  You might want to check the code - it has more close parentheses than opens.

John

Yes, sometimes the old CE works better than the new.  A third option is to rewrite the query.  Are you in a position to post it so that we can...

There's a utility from Microsoft called the SQL Server 2016 Upgrade Advisor.  I'm not sure how you get hold of it now that SQL Server 2016 is no longer the...

That doesn't sound like a SQL Server error message.  Do you get the same error message if you call the stored procedure from SSMS instead of from the SSIS package? ...

Looks like Netazza syntax is different from SQL Server syntax.  Not sure there's anyone here who will be able to help you - you may be better off on a...

• This reply was modified 6 years, 8 months ago by John Mitchell-245523.

Yes, set the database to Simple and shrink the log file to the size of the largest index in the database.

Assuming you haven't shrunk the log file, its size will be the size of your biggest log backup so far (plus maybe a little bit more depending on what your...