Viewing 15 posts - 2,221 through 2,235 (of 3,738 total)
You need to develop a strategy to cleanse the data so that you can normalize it, create Clustered Indexes, Primary and Foreign Key Constraints as was suggested.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 15, 2011 at 7:02 am
Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 14, 2011 at 12:02 pm
Congratulations Jeff.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 14, 2011 at 5:35 am
You could use the SSIS Export Wizard.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 11:51 pm
mzzzshay (9/8/2011)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 5:15 pm
Just my personal preference.
I would prefer to document the Path in the Statement.
I would try to avoid having to CD to the path where the destination file exists every time...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 5:03 pm
You don't need to prefix with the drive?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 4:50 pm
Smiley77 (9/13/2011)
I have a user who wants to be able to refresh a copy of his test database from production on the fly. He needs to be...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 4:20 pm
The following may give you some ideas:
http://stackoverflow.com/questions/640862/change-column-type-from-ntext-to-varbinarymax
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 4:04 pm
The Jets loaded up with players recently.
They now have two former Pittsburgh 1st round draft picks as their starting Wide Receivers.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 3:57 pm
CELKO (9/13/2011)
You are confusing SQL with punch card data processing. Magnetic tapes and traditional sequential files have fields in a record of a file that are ordered.
I would think...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 3:00 pm
I gave you an example early on that was based on the Adventureworks2008 Database.
If I'm not familiar with something and I'm getting errors, I have tried running the example.
Often this...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 2:37 pm
BCP OUT to the local Server.
Compress the file and copy to the destination server.
Uncompress the file.
BCP IN to the destination server.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 13, 2011 at 10:43 am
What is the syntax?
Could you include the DDL and the Data for the file so that I can test?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 12, 2011 at 7:57 pm
With the SELECT INTO not only will it not carry over the Identity but it will not carry over Indexes, constraints, etc.
As was suggested Script the Table and perform an...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
September 12, 2011 at 7:50 pm
Viewing 15 posts - 2,221 through 2,235 (of 3,738 total)