Viewing 15 posts - 31 through 45 (of 1,179 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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2015 at 5:24 am
Nice question, Thanks!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2015 at 4:47 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.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2015 at 6:57 am
Good One!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 21, 2015 at 6:28 am
Carlo Romagnano (4/15/2015)
Hugo Kornelis (4/15/2015)
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 15, 2015 at 1:46 am
Good one! Thank you, Stewart.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 14, 2015 at 1:38 am
Check summary.txt file for further troubleshooting which sql server has created during the installation.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 13, 2015 at 6:37 am
Nice question. However didn't encounter a situation to use this command.
Thank you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
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
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 9, 2015 at 4:59 am
Viewing 15 posts - 31 through 45 (of 1,179 total)