Viewing 15 posts - 16 through 30 (of 321 total)
You need to drop and create it again.
October 10, 2012 at 8:01 am
If you want to have distinct values u can use distinct otheriwise you want aggreate values for the columns you need to use group by clause. All that depends...
October 10, 2012 at 6:30 am
You can transfer the data using ssis into stage table on target server and update.
if the delay is acceptable and it is an repeating task.
October 10, 2012 at 6:12 am
Could you please provide more detailed information such as the version of your SQL Server?
October 5, 2012 at 7:47 am
Check the following link
http://stackoverflow.com/questions/3824461/ssis-xml-task-with-a-for-each-loop
October 5, 2012 at 7:33 am
What is the functionality of jobs? Is that jobs are calling any SP's?
October 5, 2012 at 7:26 am
Did you tried using table hints on the tables? and what is MAXDOP value now?
October 5, 2012 at 6:17 am
Look at the following links
http://msdn2.microsoft.com/en-us/library/ms345235.aspx
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=83229&SiteID=1
October 5, 2012 at 5:21 am
Please check the following link:
http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/
October 4, 2012 at 9:38 am
check the following link:
http://msdn.microsoft.com/en-us/library/ms152532(v=sql.105).aspx
October 4, 2012 at 9:27 am
Viewing 15 posts - 16 through 30 (of 321 total)