What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?
Answer Question | May 2, 2008 5:23 PM
Clusters, SQL Server 2005, SQL Server clustering, SQL Server installation, Windows Server 2003, Windows Server 2003 SP1
What are the pros and cons for log shipping vs. replication in SQL Server? When is one favored over the other?
Answer Question | May 2, 2008 5:21 PM
Log Shipping, SQL Server availability, SQL Server replication
I want to know how to Export BLOB data to a JPG File at the SQL Server end … NOT USING C# or VB
Answer Question | May 2, 2008 2:46 PM
BLOB, Database, SQL Server 2005
Hi How to setup mobile notifications on jobs using SQL Server 2000. Aim is when a job fails I should receive SMS notification on my mobile phone. Please show me web sites on this topic. Please help. Thanks & Regards -Rajesh.
Answer Question | May 2, 2008 11:37 AM
SQL Server 2000, SQL Server alerts
Hi! When I try this: update fileD d set d.value = (select c.value from (select b.key, b.value from fileB b where b.key not in (select a.key from fileA a)) c where d.key = c.key) I get the message “Null values not allowed in column or variable VALUE.” on the other hand, when I do this [...]
Answer Question | April 29, 2008 11:03 AM
SELECT statement, SQL, Update
I want to have a stored procedure on a server in Domain A, read data from some tables in Domain B. Is this possible in SQL Server?
Answer Question | April 29, 2008 3:49 PM
SQL Server stored procedures, Stored Procedures
We have 52 SQL Server databases on different SQL Server versions (6.5,7.0,2000). We need to consolidate all the databases into a single SQL Server 2005 database. The structure is almost the same for all the databases, i.e.,tables/datatype. The actual data is different in all the databases. Could you please provide advice or links to documents [...]
Answer Question | April 29, 2008 3:45 PM
SQL Server Database Consolidation, SQL Server upgrades
I was reading the article “Use the database maintenance plan wizard” on SearchSQLServer.com and wanted to ask, why in some cases, a maintenance plan would fail to generate a SQL Server job. I currently have cases where a maintenance plan was saved but jobs were not created at all or, in one instance, only the [...]
Answer Question | May 23, 2008 3:34 PM
SQL Database, SQL Server performance tuning
Why do I get this message; “SQLVDI: Loc=CVDS::Cleanup. Desc=Release(ClientAliveMutex). ErrorCode=(288)Attempt to release mutex not owned by caller.”?
Answer Question | April 29, 2008 2:24 PM
SBS, SBS 2003, SBS 2003 logs, SQL, SQL error messages, SQL Express
Is there any Load Balancing in SQL Server 2005 to distribute CPU load between more than one server?
Answer Question | February 11, 2012 11:07 AM
Load balancing, SQL Server, SQL Server 2005, SQL Server clustering, SQL Server performance
WE are dealing with stored procedures in a PL/SQL program. I am trying to execute the procedure from within the program itself. Is there a need to do it within a cursor or is there a specific manner to do that?!
Answer Question | April 28, 2008 10:53 AM
EXEC, PL/SQL, SQL Server stored procedures, Stored Procedures
I need to help out in a move of a site coded in ASP/VBScript from one host we’re having major problems with to another host that has been highly reliable for us. They both offer all the same features needed for this site, but we don’t know how to move the SQL database along with [...]
Answer Question | May 8, 2008 2:54 AM
ASP, Database migration, SQL, SQL Database, VBScript, Web development
Hi i have a scenario of n level tree structure.in order to traverse to my desired node i am using Recursive function until i get my desired node in my vb code but i am getting a performance issue. SO i reckon that this performance can be overcome by using sql udf or stored procedure. [...]
Answer Question | April 28, 2008 7:38 AM
Recurive function, Recursion, SQL, SQL UDF, VB, Visual Basic
I just patched my servers to this build and noticed that the time used to ‘Delete files based on the age of the file at task run time’ within a maintenance cleanup task is screwed up. Hours become days, days become weeks, weeks become months when the Maintenance Plan executes. Anyone else noticed this with [...]
Answer Question | April 25, 2008 5:53 PM
Hot fixes, SQL Server 2005, upgrades and patches
A reader wrote in with this SQL stored procedure question. Our AS/400 experts weren’t as familiar with this topic. So, any SQL experts out there with an answer? Do I have to hard code the library in my stored procedure? I have my procedures in sqltblsrc and have to edit the library to create the [...]
Answer Question | April 25, 2008 3:38 PM
SQL, SQL stored procedures
We have 1 server Proliant ML570T04 with 16GB di ram and 11 SAS Disk 70 gb. The software installed is SQL Server 2005, 32-bit and the application is Navision. With < 15 clients, the response time is slow because the SQL Server utilizes only 4 GB of ram. Is it possible to utilize the remaining [...]
Answer Question | April 25, 2008 2:27 PM
SQL Server 2005, SQL Server memory, SQL Server performance tuning
Apart from maintaining a SQL Server checklist to check in with developers, how can a DBA know if restored databases on local servers – that were gotten for developers to test – can be dropped after a few days? This would help increase the available SQL Server disk space. Let’s say about 7 user databases [...]
Answer Question | April 25, 2008 2:23 PM
Disk space, SQL Server administration
Is there any commercially available supported software that does data driven subscriptions for Reporting Services? This is the *only* feature we need from the enterprise edition and we are looking for alternatives to paying MS $30,000 just to get this one capability.
Answer Question | May 22, 2008 1:52 PM
Business intelligence software, SQL Server Reporting Services
hi.. i have tried UPDATE TableA SET TableA.A1 = TableB.B1, TableA.A2 = TableB.B2 FROM TableB WHERE TableA.A3 = TableA.B3 this query but it is not working.. plz any one suggest me.. thx in advance…
Answer Question | April 25, 2008 4:47 AM
BULK UPDATE, SQL Server 2005
HI would like to know if we need to apply patches for a newly created instance if the default instance has already been patched to SP2 Thks for any info
Answer Question | April 25, 2008 3:31 AM
SQL Server, SQL Server 2005