• Web Hosting strategy – NAT’ing and ARR

    I'm looking to develop a new strategy for our web hosting farm. Currently I've got  set of standalone IIS 6 web servers and sql 2005 database servers sitting in a network behind a kerio winroute proxy (which handles our nat'ing and intrusion prevention and VPN to our office location) which in turn...

    Phil4mat5 pointsBadges:
  • After Patch Installation Documentation / Checklist

    just wondering once you guys patch windows servers (any type), SQL server, windows xp or even as400, do you guys come out with a checklist or a document to show that the patch has been installed on the servers?

    jinteik18,655 pointsBadges:
  • Why does SQL server use no more than 500MB in RAM?

    Why does sql server use no more than 500mb in ram? We have sql server 2005 running on server 2003 32bit with 32GB of ram and in the task manager under processes, Mem Usage sqlservr.exe is only using 430, 268 K. SQL Server min memory is set to use 25GB and max is set to use 29GB. Our database is...

    Rick Martinez585 pointsBadges:
  • SQL Server 2005

    Is user cloning the only way to use windows authentication in sql server?

    Kingjah15 pointsBadges:
  • SQL Server Profiler

    What numbers are considered high when using sql server profiler for reads, writes, and duration

    Rick Martinez585 pointsBadges:
  • Disaster recovery for SQL 2005

    How can we setup a disaster recovery sql server? We are running SQL 2005 on a 2003 box. We need a real time exact replica we can switch to?

    NewnanIT1,110 pointsBadges:
  • Upgrading from SQL Server 2000 to SQL Server 2005

    We want to upgrade our SQL Server 2000 to SQL 2005. What should we watch out for and what is the actual procedure for the upgrade? Will it require another server or can the upgrade be done in place?

    NewnanIT1,110 pointsBadges:
  • SQL Server 2005 Express

    Hi, Is it worthwhile to schedule optimisation job (update stats and rebuild index) on another server so it can be run on a database that was created on SQL Server 2005 Express from an application installation? I know it is probably a good idea to atleast change the autogrowth setting from 1MB but...

    Db23290 pointsBadges:
  • SQL Server I/O

    Hello, we have a database that contains three tables. Each table has more than 25,000,000 rows in them. All three tables are in the same file group, array, and drive. Our daily Avg physical I/O is 1,000,000. Our users are complaining that the system is slow daily. Everytime a user writes to any of...

    Rick Martinez585 pointsBadges:
  • Log of stored procedures run on my SQL 2005 box.

    How can I tell who ran which stored procedure on our SQL 2005 server and at what time? Can we see if one stored procedure called other stored procedures there as well? Can we enable verbose logging somehow as well for more data?

    Karl Gechlik9,860 pointsBadges:
  • SQL 2005 keeps rebooting

    My SQL 2005 server keeps rebooting. I can not figure out why. I get an NT SUbsystem message and then a 30 second countdown. This happens 20-40 times in a day. How can I fix it? I can not even run a virus scan to completion. Windows server 2008 SQL 2005. McAfee 8.7.1.

    Troubleshooter24755 pointsBadges:
  • SQL Server 2005 database design

    What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help. 

    Shamu75 pointsBadges:
  • Process ID 174:102 owns resources that are blocking processes on Scheduler 2.

    Looking for solution to Process ID 174:102 owns resources that are blocking processes on Scheduler 2. We recently installed our Lucent Vitalnet app with SQL 2000.  it runs fine for 2-3 days, then the app stops when the above SQL error message occurs.  Rebooting the server temporarily fixes the...

    Meken1abe5 pointsBadges:
  • Trouble installing SQL Server 2005

    I have installed SQL2005 as default instance on a server that already has 2000 as the default. how can I remove sql2005 safely and reinstall 2005 as a named server.

    Pmister5 pointsBadges:
  • Can I restore a SQL 2000 backup to a new SQL Server 2005?

    Can I restore a SQL 2000 backup to my new SQL Server 2005? Will I have to perform any other steps or can I do a simple backup and restore? Windows 2008 Server.

    TeachMeIT975 pointsBadges:
  • Upgrading from SQL 2000 to SQL 2005

    Will you need to purchase a new server to upgrade SQL 2005?

    Noles15 pointsBadges:
  • Running Profiler, an update statement show reads but no writes?

    Example: last 3 columns are write, rowcount,reads [table] [tbody] [tr] [td]75072[/td] [td]SQL:StmtCompleted[/td] [td]UPDATE UserHdr SET LastActivity = '29-Aug-2010 01:23:24 AM' WHERE UserKey = 'M'[/td] [td]205[/td] [td]2010-08-29 01:23:24.393[/td] [td]The FactorSoft Program[/td] [td]12695[/td]...

    Manodak15 pointsBadges:
  • SQL Server 2005 error after development

    I developed an application and when we moved it to the clients site we started getting this error from their SQL 2005 box: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings...

    TeachMeIT975 pointsBadges:
  • High Disk usage on SQL Server 2005

    We recently upgraded our application from version 3.1 to 3.5. We had run the latest schema and other DB changes on the existing 3.1 Database. This is how we upgrade to higher versions. Now the problem is, after the upgrade, the disk usage has gone very high. What are the possible reasons for high...

    Jsql155 pointsBadges:
  • SQL Server 2008 Restore error message

    I get this error when trying to restore a 30 mg database "Callback:SQL Server 2008: Out of memory on restore" and then get the error ""There is insufficient system memory in resource pool ‘internal’" Anyone have any ideas?

    Kmmc1122334455665 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following