Dynamic SQL procedure for bulk insert
https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql
2017-11-17 (first published: 2015-05-16)
5,231 reads
Dynamic sql for convert SQL statement to txt/csv file
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpUnloadSelect.sql
Quick export to flat file.
Before use please enable xp_cmdshell.
2016-12-09 (first published: 2015-05-12)
2,356 reads
Dynamic sql for convert table to flat file using bcp
I comment CATCH section for removing dependence to log procedures.
Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql
2016-08-22 (first published: 2015-05-07)
2,215 reads
Count character matches with DATALENGTH function
https://github.com/ktaranov/sqlserver-kit/blob/master/Scripts/Count%20character%20matches.sql
2015-06-08 (first published: 2015-05-18)
1,085 reads
2014-04-17 (first published: 2014-03-25)
1,293 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Pulogadung Trade Centre Tlpn/wa:085373737551
Kw. Industri Pulogadung, Jl. Raya Bekasi Km. 21, Ruko No.A2/18-19, RW.3, Wil, Kec. Cakung,...
BCA KCP Permata Ujung Menteng Tlpn/wa:085373737551
Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota Jakarta Timur,...
BCA KCP Setiabudi Atrium Telp/Wa:08218200174
Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said No.Kave 62 Lt.l Ruang 101...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers