Do you have access to the source code behind the GUI?  If so, I would tackle it on the GUI source side of things NOT on the database side of...

I think a lot of it falls under "it depends".  IF you have the licenses, I would recommend putting it on a separate machine.  BUT SSRS needs a SQL license...

My opinion - I would try your query as just a SELECT without the CAST and see what you get back, as well as selecting all values in that CTE.

If...

Could you post your code and sample data and DDL?

You are doing something that the query optimizer thinks will be a SMALLINT, but that being said, 0.0000005328 WILL successfully cast...

My opinion, if you want to toss the full backup on onedrive in smaller chunks, I would include MD5's with the backups.

I am a bit confused what you mean by...

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)...