Binary Files Import and Export
Importing binary files is always a challenge in SQL Server. New Author Sergey Benner brings us a technique using bulk loading that has worked well for him.
2018-01-12 (first published: 2008-08-28)
20,315 reads
Load (ETL)
RE: Login failed for user ''''(null)'''' in linked server
check this articles. you need to set up security account delegationhttp://www.sql-server-performance.com/tb_kerberos_protocol_transition.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_1_server_24tv.asphttp://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_2gmm.asp
2005-03-03
RE: temp table
SQL Server generates a 128 byte unique name for each temporary table. The last 12 charaters i.e. 000000102330 is the Current Session ID generated by SQL Server. So every temporary table created in this session will always contain these charaters at the end. The session ID is internally generated by SQL Server whenever a session […]
2003-05-26
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers