I've worked on several applications which ride on the external data being received as a flat file every day on an SFTP. The processing time was going...

I have a different opinion here as far as the OLTP is concerned. Having Clustered Index (but not utilizing it) will not benefit, instead will be overhead.

If you do...

Yes, agree that it would benefit in the read loads. But we should also consider the overhead of CI on write operations. So if the database is read-intensive then CI...

I have a different opinion here as far as the OLTP is concerned. Having Clustered Index (but not utilizing it) will not benefit, instead will be overhead.

If you do not...

I thought to answer it by writing my own stuff here. But then I typed the warning message provided by you on google search and it gave me the following...

You may simply execute the sub-procedure from the main procedure using the following syntax.

EXEC <sub procedure name>

The main procedure will look somewhat similar as follow. Please note to supply the...

I found an issue in the code you posted. You may try after correcting it.

Assign a length to the NVARCHAR in the following line of your code. If you'll not...

This is strange. Kindly help us understand if the size of your database has grown or the size of the database backup file has grown? If it is a database...

As far as Primary Key (without Clustered Index) is concerned you MAY have it on a GUID or an Identity column (mostly preferred). But if you ask Primary Key with...

I've extensively worked on financial calculations, and based on my experience I would not suggest using the WHILE loop for the amortization calculation if the number of transactions to be...

I recommend the following steps:

1. Identify the total row count and keep it in a variable [A]
2. Identify the average row size (in bytes), and derive the average number of...

Do you know the number of files (smaller files) to be created out of the table? Or it's dynamic?

I think Phil is trying to point out to check if both 32 bit and 64 bit of the Microsoft.ACE.OLEDB driver is installed or not? Please validate this once.

If your...

Try SINGLE_BLOB instead of SINGLE_CLOB. Microsoft official documentation on OPENROWSET says

We recommend that you import XML data only using the SINGLE_BLOB option, rather than SINGLE_CLOB and SINGLE_NCLOB, because only...

I agree with the suggestions from Brian. Also, I was wondering Table Compression can help to save space. I've noticed up-to 80-85% of storage space savings with Table Compression. It...