Viewing 15 posts - 901 through 915 (of 3,738 total)
I also need to output as XML Raw.
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/
March 4, 2014 at 10:41 am
Thank you for the responses.
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/
February 24, 2014 at 9:47 am
Thanks for the input.
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/
February 23, 2014 at 3:16 pm
Hi to you. :hehe:
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/
February 16, 2014 at 1:53 pm
free_mascot (2/12/2014)
Recompile the query plan could resolve the issue.
Thanks for the advice.
There is not an SP involved.
It is a Bulk Insert in an SSIS Package.
Thanks again.
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/
February 13, 2014 at 6:30 am
Nadrek (2/12/2014)
Welsh Corgi (2/12/2014)
Nadrek (2/12/2014)
Welsh Corgi (2/12/2014)
IMHO, there is nothing wrong with using or at least being familiar with the Import/Export Wizard.
Upgrading hundreds of import/export packages to a new version...
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/
February 12, 2014 at 12:27 pm
Nadrek (2/12/2014)
Welsh Corgi (2/12/2014)
IMHO, there is nothing wrong with using or at least being familiar with the Import/Export Wizard.Upgrading hundreds of import/export packages to a new version of SQL Server?
What?...
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/
February 12, 2014 at 11:05 am
Nadrek (2/12/2014)
=CONCATENATE("INSERT INTO #YourTable VALUES...
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/
February 12, 2014 at 10:33 am
You could create a Linked Server for one but I would import the Data into SQL Server Tables.
You can use the Import Wizard which is basically SSIS.
You may need to...
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/
February 11, 2014 at 9:14 am
Problem went away.
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/
February 11, 2014 at 7:46 am
It was the firewall.
It is working.
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/
January 30, 2014 at 10:09 am
I got it, just simply add another line with the logical and physical file name.
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/
January 28, 2014 at 11:55 am
Revenant (1/23/2014)
Welsh Corgi (1/23/2014)
I will get a statement from the Microsoft SQL Server Engineer that documents what actions were taken and the outcome?
The situation was not the norm and there...
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/
January 23, 2014 at 5:08 pm
Lynn Pettis (1/18/2014)
Welsh Corgi (1/18/2014)
Lynn Pettis (1/18/2014)
Welsh Corgi (1/18/2014)
I had to drop the database and restore. Basic syntax.
I think the problem was that they did not stop the SQL 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/
January 23, 2014 at 4:30 pm
Revenant,
I will get a statement from the Microsoft SQL Server Engineer that documents what actions were taken and the outcome?
The situation was not the norm and there were extenuating circumstances.
What...
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/
January 23, 2014 at 4:23 pm
Viewing 15 posts - 901 through 915 (of 3,738 total)