I can't say with 100% certainty the cause of the error, but to me that doesn't look like TSQL.

What I mean is the $ part and ESCAPE_NONE.  I don't know...

Has anyone used Brain Box SQL app for Android in the google play store?

What do you think?

I've been using it to connect remotely to my SQL Servers via...

I think we may be on the right track but my data isn't presenting correctly. I'm getting (although the seconds are not visible, they are incorrect):

December 13, 2021 at 2:09 pm

#3963068

The way I would do it is similar to this:

DECLARE @test1 DATE = GETDATE()
DECLARE @test2 TIME = GETDATE()
SELECT @test1, @test2, CAST(CAST(@test1 AS VARCHAR(255)) +' '+ CAST(@test2 AS...

That last bit is EASY  to fix - trim your strings:

SELECT PARSENAME(TRIM(@statement), 1)

What I would check, and what I expect the problem is, is the "Package" tab.  What is probably happening or happened is that the SQL instance you are configuring the...

I have a few thoughts on this.

First - is this consistently returning the same number of rows?  Like if you run the query 10 times do you always get 1035...

I agree with Fredrico_Fonseca on the performance question - it depends on a LOT of factors and the EASIEST way to know if it helps or not is to test...

As a thought - is it a native backup or a 3rd party tool (like redgate) backup?  Is the backup encrypted? Can you restore the backup to another 2012 STD...

One option you could do (probably not ideal, but a possibility) would be to use something like the scripting agent in SSIS to open the file in excel (hidden window)...

That I am not 100% certain on, but in my opinion - I would buy some sort of SQL monitoring tool.  It will let you know when a deadlock occurs...

My opinion - this is likely not a database issue, but possible a configuration issue.

BUT to rule out database, I would do a dbcc checkdb to make sure nothing is...

The other bit of "fun" with that, on top of what ZZartin siad, is that the TLOG may be in use by other queries that could be inserting, updating, or...

Yep - you see that greyed out "script" button?  Click on a checkbox then click on the script button then cancel out of that window.

That script button will tell you...

I am not certain what you mean by "access the checkbox" in TSQL code, but I am 99% sure that all configuration options within SQL Server for all available features...