Indeed, thank-you, vk-kirov for alerting us on the use of GO as a column alias. I was unaware of it as well.

As Hugo rightly mentioned, even with this knowledge, chances...

Hello!

This was very similar to one of my own QotDs a few months back.

However, what I take from this one is that the DDL is not committed automatically because...

Can you confirm if the SQL Server is configured to use all processors (CPU affinity)?

Also, depending upon the query and the load, SQL Server can choose not to use the...

What edition of SQL Server are you using? Straight out of Books On Line - "Parallel index operations are available only in SQL Server Enterprise, Developer, and Evaluation editions."

Personally, I hate the idea of having the office along with me during commutes and at home (that maybe because I have been lucky to have a max. commute time...

That is good to know, Dipali. Have a good evening!

Hello!

Thank-you. I assume that @objTextStream is the value that contains the text to be written to the file.

If yes, is that value Unicode enabled? i.e. is that value NVARCHAR/NTEXT/NCHAR? If...

Can you post the code (with business specific items omitted) that you are using to write to the file?

Dipali,

Does the workstation where you are opening the file have proper fonts installed? In other words, if you would do a SELECT FieldName FROM MyTable, copy the unicode data and...

I guess that in today's world, knowing everything about any product is a physical impossibility. What matters most is:

1. You know what the product can do (not how!), and

2. As...

Really very nice question. Gets the mind thinking about the internal storage and is a very, very important consideration for capacity planning.

I got it right, but I must admit that...

Excellent question!

Thank-you!

Good question, Hardik!

I answered wrong because I was distracted by the use of the stored procedure uspPrintError 🙂

Hello!

Happy Friday :-)!

I am of the opinion to have 1 trigger for business logic (per operation - Insert/Update/Delete) and 1 trigger for auditing. The prime reason being - it is...

Yes. Typically, you would run this the morning you see the job as suspended/waiting in sp_who2...