I have three tables. Table One is a master table which contains rows which need to be updated with data from the other two tables (I’ll call them Table Two and Table Three). I have created a cursor which updates existing rows in Table One with data from Table Two. This works fine, and following [...]
Answer Question | March 23, 2011 10:57 AM
SQL Cursors, SQL Server 2005, SQL Server 2005 administration, SQL tables
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
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
Hello, I am writing a stored procedure that will query data from another database, but the database name is variable. Do I have to use a dynamic query? We dont want to use dynamic queries because of performance loss. But is there a way to do it without a dynamic query? Example GetData ‘some_remote_db_name’; and [...]
Answer Question | February 14, 2012 3:20 PM
SQL 2005, SQL Query, SQL Select, SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server stored procedures, T-SQL
I enter as the administrator, and when creating a new database a message always appear stating that permission denied in database master! what shall i do?
Answer Question | March 1, 2012 3:36 AM
SQL Server, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 error messages
I need some ideas of how to create a SQL Server System Report, i.e. how much memory has been consumed, how much time was taken in a job run? Can some one provide me an example, please? Thanx.
Answer Question | May 15, 2010 4:40 PM
SQL Server 2005 administration, SQL Server 2005 Analysis Services, SQL Server 2005 Reporting Services
Hi , We need a way using sql server for updating more than one rows at a time . Thanks , Pramod.
Answer Question | April 13, 2010 8:01 AM
SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 Database
At what point should we truncate the transaction log
Answer Question | April 9, 2010 1:38 AM
sql 2005 Performance Issues, SQL Server 2005, SQL Server 2005 administration, SQL transaction logs
I am trying to add a field that has different values.I need to add them to get a total number .Example: Lesson num field contains value 1245,3467,6754,9987,4089 I need to add them to get a total of 5.
Answer Question | April 8, 2010 1:32 AM
SQL Server, SQL Server 2005 administration, SSRS 2005, SSRS reports
On SQL Server 2005, what is the minimum permission needed to allow a user to export tables from one database server to another server? Permission on SOURCE=? Permission on DESTINATION=?
Answer Question | April 9, 2010 7:55 PM
SQL Server 2005, SQL Server 2005 administration, SQL Server permissions
I am new to the SQL Server 2005 Fulltext search technology and I have not tried it yet myself. I would like to ask about availability of a feature which is provided for example by the Oracle Text technology which is indexing documents using FTP protocol. I have various formats of text documents residing on [...]
Answer Question | May 16, 2009 9:57 AM
FTP Server, SQL Server 2005, SQL Server 2005 administration, SQL Server Full Text Search
We’ve had a few performance incidents in SQL Server 2005 and I want to check the Max Worker Threads. Would someone explain how to return that? Thanks. Moderator Note: This is a user submitted question
Answer Question | March 21, 2009 7:08 PM
Max Worker Threads, SQL Server 2005, SQL Server 2005 administration, SQL Server 2005 performance
My SQL 2005 Enterprise Edition SP1 on server 2003 Enterprise SP2 has 12GB memory. I set min memory 10MB,10GB for max memory and set ‘lock page on memory’, but Task Manager show only 4.50GB only and performance monitor show SQL server manager – total memory on 4GB. Expert: Do I setup memory wrong?
Answer Question | March 9, 2009 10:46 PM
SQL Server 2005 administration, SQL Server 2005 memory, SQL Server 2005 performance