Viewing 15 posts - 31 through 45 (of 1,178 total)
I guess you need to first understand requirement in your environment whether to go with IPV4 or newer version IPV6. you also need to understand what is the difference between...
June 24, 2015 at 6:20 am
With your experience there are enough opportunities in India. One has to be proactive to gain the knowledge and you can't implement all the features available on tool/technology and expect...
April 22, 2015 at 5:24 am
Recompile worked that means my guess is correct it is optimizer issue. This is also similar to parameter sniffing if you are using any parameter in stored procedure.
April 22, 2015 at 2:14 am
Select statement is always fater than Insert statement.
This looks like optimizer issue.
Extract from Microsoft:
OPTIMIZE FOR ( @variable_name { UNKNOWN | = literal_constant } [ , ...n ] )
Instructs the...
April 21, 2015 at 9:39 am
As Gila has mention UPDATE STATISTICS with FULLSCAN is good. Refer following link for your reference:
http://sqlperformance.com/2013/07/sql-statistics/statistics-updates
https://msdn.microsoft.com/en-IN/library/ms187348.aspx
https://msdn.microsoft.com/en-IN/library/ms173804.aspx
HTH
April 21, 2015 at 9:22 am
It's not BCP but with OPENROWSET you will able to export in various tabs in a xls; refer the following link for further detail
http://www.sqlservercentral.com/Forums/Topic487837-19-1.aspx
HTH
April 21, 2015 at 6:57 am
Carlo Romagnano (4/15/2015)
Hugo Kornelis (4/15/2015)
April 15, 2015 at 1:46 am
Check summary.txt file for further troubleshooting which sql server has created during the installation.
HTH
April 14, 2015 at 1:23 am
You can delete the data by committing small chunk of the data which will help tlog file to grow minimal with very minimal open transactions.
Usually after large insert/delete operation SQL...
April 14, 2015 at 1:05 am
Yes, it is possible with the help of pass-through authentication. Refer the following article which might help you.
http://www.kendalvandyke.com/2011/12/database-mirroring-in-windows-workgroup.html
HTH
April 13, 2015 at 6:37 am
Nice question. However didn't encounter a situation to use this command.
Thank you.
April 13, 2015 at 6:31 am
Yes, that is the problem. Once you resolve the port issue after connecting to VPN; you will able to connect.
HTH
April 9, 2015 at 4:59 am
Viewing 15 posts - 31 through 45 (of 1,178 total)