What numbers are considered high when using sql server profiler for reads, writes, and duration
Answer Question | October 8, 2010 10:00 PM
SQL, SQL 2005, sql 2005 Performance Issues, SQL Profiler, SQL Server, 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?
Answer Question | October 4, 2010 2:29 PM
SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 upgrade, SQL Upgrades
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 what about [...]
Answer Question | October 2, 2010 6:29 AM
SQL 2005, SQL Jobs, SQL Server 2005, SQL Server 2005 Express, SQL Server Express
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 thos [...]
Answer Question | September 24, 2010 8:36 PM
Average Disk Queue Length, SQL, SQL Server, SQL Server 2005
We are looking to migrate from MySql to a full blown iteration of SQL 2005. Are there tools in place that will allow us to migrate our data and tables or are we on our own for getting our data into the MS database?
Answer Question | September 21, 2010 3:14 PM
MySQL, MySQL Database, MySQL functions, SQL, SQL 2005, SQL Server 2005, SQL Server migration, Windows
I have made a program in VB 2005 with SQL2005 as back end. In the data base there are three fields which are unique id of a person. I want to display “Already Exist” message box when i enter an already existing id. matching all three fields and not allow duplicate entry.
Answer Question | September 20, 2010 10:29 PM
Software Management, SQL 2005, SQL Server 2005, VB 2005, Visual Basic, Visual Basic 2005
Is there a way to replicate a SQL server database to another SQL server with the same hardware and software? I want a live copy of the data up to date in case something goes wrong and we need to switch to the backup server.
Answer Question | January 30, 2012 8:08 PM
Backup, Backup and Recovery Hardware, SQL 2005, SQL Backup, SQL Server 2005, SQL Server database
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?
Answer Question | September 15, 2010 5:22 PM
SQL, SQL 2005, SQL Log Files, SQL Server 2005, SQL Server stored procedures, Stored Procedures
What is 1*,o* 1..1,1..*,0..*,1..* in databse design,i have no exact idea about this,need help.
Answer Question | September 14, 2010 3:57 AM
Database design, SQL 2005, SQL 2005 Database design, SQL Database, SQL Server, SQL Server 2005
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 problem until another 2 days. Also [...]
Answer Question | September 10, 2010 4:15 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Server 2005, SQL Server upgrades, Windows, Windows Server, Windows Server 2003, Windows Server 2003 SP2
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.
Answer Question | September 9, 2010 8:06 PM
SQL 2000, SQL 2000 to 2005 Migration, SQL 2005, SQL Installation, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2005 administration
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.
Answer Question | September 8, 2010 8:32 PM
SQL 2000, SQL migration, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server backup, SQL Server migration, Windows Server 2008
Will you need to purchase a new server to upgrade SQL 2005?
Answer Question | September 8, 2010 3:23 PM
SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server Hardware
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 SQL Server [...]
Answer Question | September 2, 2010 8:12 PM
Application deployment, Application development, SQL Server, SQL Server 2005
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] [td]2010-08-29 01:23:24.407[/td] [td]0[/td] [td]1[/td] [td]2[/td] [/tr] [/tbody] [/table]
Answer Question | September 7, 2010 2:16 PM
SQL 2005, SQL Profiler, SQL Server 2005, SQL Server 2005 administration, UPDATE statement
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.
Answer Question | September 15, 2010 1:59 PM
McAfee, Reboot problem, SQL Server, SQL Server 2005, SQL Server 2005 connectivity, Subsystems, Windows Server 2008
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?
Answer Question | October 17, 2010 8:52 AM
Patch management, SQL Server, SQL Server 2005, Windows Patch Management, Windows Security, Windows Server, Windows Server 2003, Windows XP
Has anyone ever seen a White Paper on the best way to utilize features of both VMWare and EMC Symmetrix based SANs in a real-time or rapid batch based upgrade from SQL Server 2000/2005 to SQL Server 2008 with minimal downtime for application availability?
Answer Question | August 27, 2010 4:47 PM
EMC SAN, EMC Symmetrix, EMC Symmetrix DMX-4, SAN, SQL Server 2000, SQL Server 2000 to SQL Server 2005 upgrade, SQL Server 2005, SQL Server 2005 upgrade, SQL Server 2008, SQL Server Upgrade, Symmetrix, VMware, Windows Server 2008
I have several maintenance plans setup in SQL 2005, but if the backup fails I am not alerted in any manner how can I fix this? Will I need to script something or is this a built in feature?
Answer Question | August 26, 2010 1:16 PM
Backup, Maintenance Management, SQL, SQL 2005, SQL Manager, SQL Scripting, SQL Server 2005, SQL Server 2005 backup
What is an index in Microsoft SQL? What types of indexes are available in SQL Server 2005? Do I need to know about this to create and deploy a database?
Answer Question | August 27, 2010 8:08 PM
Database design, SQL, SQL Database, sql indexes, SQL Server 2005, SQL Server 2005 index strategy