Connection pooling can be used by an ODBC application exhibiting ODBC 2.x behavior, as long as the application can call SQLSetEnvAttr. When using...
your database is 3GB , memory is 64GB , 24 processor , so database should swim in cache , and server should be faster, so it may HW problem: -...
broadband connection with 2-10 mbit/s the client in LAN run with speed 100 mbit/s (may 1Gb/s) so you should expect slow for data from server to...
- what the size of datbase? -How many record in the tables included in the query? -can you check the execution plan of the query in the two servers?...
When you close connection , it will be in the connection pooling , and if the connection string is the SAME , you re-use it again if it is...
Set the computed field as Persisted computed column , enhhance performance , but get more space Set large tables on separete group file
Why 32 bit , if you have 64 bit processors. if your server is 4 GB or less , it may be reasnable for 32 bit Server 64 bit is also very safe , and...
TSM software is not installed yet, in the meantime, Tape is connected To SAN Switch When they finish installation , i will post the final...
I have : - one server windows 2008 SP2 as a domain controller (DC). - Two nodes as a cluster server active/passive running sqlserver 2008 enterprise...
As the server stopped accediantly, so no way to get alarm except you have a service in other computer that monitor that server. it can be simple...
I think that network problems may lead to open transactions which may need to be resolved , but not corrupting database
The new features in sql server 2008 R2: Multi-Server Administration and Data-Tier Application Master Data Services Features Supported by the...
I faced this problem yesterday in sql server 2000 sp4 , and sp_attach_single_file_db was not helpfull at all I had to restore database from backup....
when IP is "Obtain IP address automatically" , run ipconfig /all and find the IP address /subnet mask ,default gateway , DNS match these values...
This query retun all objects including 'PONo' SELECT o.object_id, OBJECT_NAME(o.object_id) Name, o.type_desc, schema_name (o.schema_id) Owner From...
This problem may occur due to memory allocation contention which causes a slowdown on the login process or the query execution process. what is SP...
Have a look to that post in the forum: http://sql-server-performance.com/Community/forums/t/5718.aspx it may help
No change for sql 2008 compared to sql 2005 you create a service account user in every domain group (with min. rights) and use these domain...
There is a limitation for sql express : 1 cpu , 1GB RAM , 4GB database size Can you check if you reached these limits. have alook to:...
yes you can The first instance has the default name , the next one have a new named instance. but only you install one SSMS tool , so you should...
Separate names with a comma.
