You probably want a covering index like:

CREATE NONCLUSTERED INDEX ncix_PropertyProduct_Cover ON dbo.PropertyProduct
(
Warehouse ASC,
Product ASC
)
INCLUDE(Id,PropertyId,Value);

SELECT CAST(ROUND(COLUMN_A*100.0/(CASE WHEN COLUMN_B = 0 THEN -1 ELSE COLUMN_B END),2) as decimal(5,2)) as "Percentage"

You lost the ROUND() function's length parameter in that version

You can use gzip. But make sure you use 7z.exe, not 7za.exe -- https://sevenzip.osdn.jp/chm/cmdline/index.htm:

7za.exe supports only 7z, xz, lzma, cab, zip, gzip, bzip2 and tar formats.

https://sevenzip.osdn.jp/chm/cmdline/switches/type.htm:

If -t{archive_type} switch is not...

Use the command line executable: https://sevenzip.osdn.jp/chm/cmdline/index.htm

DENY CONNECT ANY DATABASE TO [login]

I don't have a solution to the problem as stated, but as a workaround, my suggestion/question would be:

Could you just create a subscription with the report rendered as a PDF? ...

Is ProximityCardNumber really an nvarchar(11)?  Does it really need to be?  (Not if  ProximityCardNumbers are numeric strings like the sample... Of course, if this this a vendor database, your control...

• This reply was modified 6 years, 2 months ago by ratbak.

https://www.diva-gis.org/gdata

https://hub.arcgis.com/datasets/a21fdb46d23e4ef896f31475217cbb08_1

https://gadm.org/download_country_v3.html

http://www.maplibrary.org/library/index.htm

And many others of varying reliability.

You'll need to use a GIS converter to import into SQL Server.

To get plan reuse, you need to use stored procedures or parameterized queries: https://www.red-gate.com/simple-talk/sql/t-sql-programming/performance-implications-of-parameterized-queries/

2005.

Both work, but sp_change_users_login "is in maintenance mode and may be removed in a future version of Microsoft SQL Server."

Fortunately, it's as simple as wrapping the database name in brackets -- i.e.,

BACKUP DATABASE [update] TO DISK = N'C:\SQLBackups\update.bak' WITH INIT

Your vendor is at best, uninformed about...

Assumption: You mean a datetime/datetime2 type and not the timestamp data type (which is just a synonym for rowversion) -- a guid-like value used for versioning.

If you are in an...

I don't know that you could/should in TSQL.

Here is an example that uses SQL CLR to convert PDF into a series of images: https://www.codeproject.com/Articles/34551/Reporting-Services-2008-Embedding-a-PDF-Document

I don't know why this conversion couldn't be...

Yes. AWS added that capability for SQL Server in November 2017: https://aws.amazon.com/about-aws/whats-new/2017/11/amazon-rds-for-sql-server-supports-scaling-storage-size/

A couple caveats in https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ModifyInstance.SQLServer.html:

Can't change storage for 6 hours after a change.

Some older DB instances don't support storage...