Viewing 15 posts - 1 through 15 (of 325 total)
This was a good question. Thanks!
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
August 2, 2021 at 5:57 am
Thanks for sharing! This is an interesting question to start the week. For those starting work after the holidays - Have a Happy New Year 2020!
Reading the documentation and some...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
January 6, 2020 at 6:29 am
Wouldn't '2019-01-18 20:23:10' print as Sep 1 2019 8:23 PM? 🙂
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
September 27, 2019 at 7:05 am
Learnt something new today. Thank-you for the QotD.
Have a great week ahead!
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
July 8, 2019 at 6:03 am
Learnt something new today. Thank-you!
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
December 20, 2018 at 3:50 am
Is there any particular reason to use SHA1 instead of MD5? I would recommend changing the algorithm and then validating if the changes are being detected correctly or not. SQL...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
December 6, 2017 at 9:42 pm
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
January 30, 2017 at 11:58 pm
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
January 30, 2017 at 11:38 pm
The problem is scalability. Aggregations are blocking transforms. Hence, they block the data flow in the pipeline and start bloating the memory (as they keep the entire result set in...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
January 30, 2017 at 10:34 pm
If my source is a SQL Server, I generally prefer using CAST/CONVERT for the appropriate data-type conversion. For non-relational sources (e.g. an Excel File), I use the Data Conversion Transform.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
December 15, 2016 at 3:59 am
Thank-you, all for taking the time to read my article and share your valuable feedback. I have made to the article since the original publication:
- Added a new section –...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
September 5, 2016 at 4:45 am
h.tobisch (8/24/2016)
Moreover - there is no result generated at all.
What happens is that...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
August 24, 2016 at 9:01 am
ebouras (8/23/2016)
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
August 23, 2016 at 7:11 am
Whatever value we supply is taken by SQL Server as the value to be set.
For example, the following turns ANSI_WARNINGS (8), QUOTED_IDENTIFIER (256) and XACT_ABORT (16384) to ON. The value...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
August 23, 2016 at 3:34 am
nick.mcdermaid (8/23/2016)
Enforcing data integrity is an important function. Encouraging lazy developers is not...
Exactly. That's why I was concerned when the development team asked me whether it would be okay...
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins
August 23, 2016 at 1:22 am
Viewing 15 posts - 1 through 15 (of 325 total)