Forum Replies Created
Viewing 15 posts - 7,741 through 7,755 (of 59,072 total)
-
Reply To: Error while trying to create a csv file
Shweta Jain-392928 wrote:##csvtemp only contains 6 lines.. so it is not big...
set @sql = 'bcp "SELECT Col1,Col2,Col3,Col4,Col5,Col6,Col7,Col8,Col9,Col10,Col11,Col12,Col13,Col14,Col15,Col16,Col17,Col18,Col19,Col20,Col21,Col22 FROM ##csvtemp" queryout '+@processedFolderLocation+'/"'+@csvFileName+'" -c -d ' + DB_NAME() + ' -t, -S '+...
-
Reply To: Find and Copy Data from Another Table
uknites wrote:thanks alot 🙂
It worked 🙂
Excellent. My next question would be... why are you denormalizing/duplicating data? For that matter, why does the INFO table have a DOB column to begin...
-
Reply To: Connecting to AS400
cbrammer1219 wrote:I GOT IT, I figured it out, Thank you very much, I am very appreciative for your assistance.
That's nice. Would you mind sharing what you did... maybe even as...
-
Reply To: How to write loop below with best practice performance ?
Hold the phone here... inserting 5000, 10000, 15000 rows isn't a large, time consuming task for SQL Server. Why do you think you need to "chunk" the data in this...
-
Reply To: Insert Data and read all Foreign Keys/Constraints first
TRACEY-320982 wrote:Hi sschasing, I doing a few inserts first, and then a larger conversation starts from source to target. I thought it may be simple to do a few inserts...
-
Reply To: The Main Obstacles to Implementing Database DevOps
maroon-78 wrote:That is a scary thought to most people. Change!
I wonder how many people actually fear change? I don't fear change for the better. I don't believe anyone actually does. ...
-
Reply To: Document storage
My question would be... how would you be accessing the documents and what would be the search criteria for finding a given document? Also, are you going to be searching...
-
Reply To: Insert Data and read all Foreign Keys/Constraints first
pietlinden wrote:If you're doing an insert where you don't want the constraints checked, you can script out the constraints on the table, then drop them, do the import, then add...
-
Reply To: shrink operation is slow.
Hold the phone on that... consider the following graphic from your original post...
According to that graphic, your first database is 2.5 TERA-Bytes...
-
Reply To: Good Luck is Needed with Old Versions
I agree with everything you said but, with all the really cool stuff that's been built into SQL Server in the last 8 years, couldn't you have cited a better...
-
Reply To: UPDATE statement on CTE with INNER JOIN
Lynn Pettis wrote:May I ask why you are using CTEs in this manner when you could just use the tables themselves?
That was going to be my exact question.... or is this...
-
Reply To: Identifying Empty columns
EamonSQL wrote:Hi
is there a way to identify empty columns.
I'm going through a new database right now and dropping columns that have never been used.
I've been generating SQL statements to get...
-
Reply To: Figure out Source of SPID retrospectively
Sue_H wrote:You can get information of the DBCC executions by querying the default trace file for the Audit DBCC Event. It will have login, host name, application name, etc.
Sue
Just a...
Viewing 15 posts - 7,741 through 7,755 (of 59,072 total)