What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?
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?
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

Storing BLOB to file through SQL Server 2005
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

Mobile phone notifications
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

update a field from a file with a field from a selection from two files
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

Is it possible to have a SQL Server stored procedure in Domain A read data from tables in Domain B?
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

How to consolidate databases from different SQL Server versions to one SQL Server 2005 database
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

Why might a maintenance plan fail to generate a SQL Server job?
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

Critical error in event logs
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

load balancing in sql server
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

Running Procedures within the PL/SQL program
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

Moving a SQL database from one host to another
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

IS It Possible to create Recusrive function using sql udf or stored procedures?
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

Build 09.00.3239.00 (cumulative update)
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

Coding for library in stored procedures
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

Is it possible to increase the amount of memory used by SQL Server 2005 to speed up response time?
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

In an effort to free up SQL Server disk space, how can a DBA know when it is time to drop developers test databases from local servers?
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

Looking for commercial software that does data driven subscriptions for SQL Server Reporting Services
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

bulk update in sql server 2005
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

Patches for new SQL2005 instance
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