Problem with MSSQL? .NET application? or Win Server?
Dear members, Please help me in regarding my problem. I am very much confused on whom to blame for the problem……..MSSQL? or .NET ? or Win server? I have a dedicated server with 2GB RAM, SQL 2005, 150GB bandwidth, 160 GB disk space etc., I have created a .net application that fetches data from different [...]

Answer Question   |  February 22, 2008  5:09 AM
.NET applications, SQL Server 2005

Possible Deadlock Condition
I have a server at work that I have been having some serious issues with. It is our main server that holds our database and runs our applications. For the last 3 days we have been receiving ‘Possible Deadlock Condition’ errors which leads to the server locking up. The only way to restart the server [...]

Answer Question   |  December 14, 2007  6:04 PM
Database, Possible Deadlock Condition, SQL Server 2005

How to transfer data from two servers of GIS to one server of sql server?
How to transfer GIS data from two servers into one server of SQL server , is it possible? and if so then what tool should i use? could anyone please help me in this plzzz

Answer Question   |  May 14, 2008  3:49 PM
GIS, SQL Server, SQL Server 2005

Retrieving large binary objects
Server: SQL Server 2005 SP2 on Windows 2003 R2, Quad Core, 4GB Ram, Gigabit Ethernet Client: Windows XP SP2, Dual Core, 1GB RAM, Gigabit Ethernet I am retrieving images from my database across the network and am concerned about thruput. It seems to me when I request a 300k image that it will be sent [...]

Answer Question   |  December 2, 2007  7:13 PM
SQL Server 2005, SQL Server performance tuning, Windows Server 2003

import data from access into sql server 2005
hello, I have a large database on ms access with more than 100 tables. I am planning to do migrate this database into ms sqlserver 2005. I am receiving info into database access on a daily basis. so I have to do an auto job to import data from access into sql server 2005. I [...]

Answer Question   |  November 24, 2010  10:30 AM
Migration, SQL Server 2005, Stored Procedures

connecting VB2005 Express with remote msSQL2005 Express server
I’m trying to do the above with no sucess although I can connect msQuery, create msAccess projects, and ODBC with the remote server. The remote server is already configured to accept remote connections.!!! the message is that the remote server do not allow remote connections!!! any ideas

Answer Question   |  December 2, 2007  8:07 AM
Connect, Remote access servers, SQL Express, SQL Server 2005, VB 2005, Visual Basic

bcp utility in sql server 2005
hi,how to send logins from server to another server using bcp utility.

Answer Question   |  July 8, 2010  5:51 AM
BCP Utility, SQL Server 2005

move db,logins
how can we transfer database and logins from sql server 2005 to another sql server 2005

Answer Question   |  November 14, 2007  8:43 AM
Migration, SQL Server 2005

Disaster Recovery
How to get database back in disaster recovery when database is in emergency mode in sql server 2005 is there any option to update master then take a backup –please let me knw—

Answer Question   |  December 2, 2007  10:40 AM
Disaster Recovery, SQL Server 2005

Can’t bring master database back online
hi,i bring master database into offline. after that i tryed so many times to make master database as online.But i did’t get that one into online(production side)wht is root cause for that?

Answer Question   |  December 1, 2010  11:27 AM
SQL Server 2005, SQL Server database, SQL Server errors, SQL Server Master Database

SQL 2005 Restore DB with Multiple files in Primary File group
Is it possible to take a backup of a database that has multiple files within the primary file group (10 total in this example) and restore that backup to a new database that has only one file in the primary file group? THanks, Lee

Answer Question   |  December 2, 2007  8:58 PM
Database, Restore, SQL, SQL Server, SQL Server 2005

Indexing Fact Tables for a data warehouse
Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple around 15 [...]

Answer Question   |  December 2, 2007  1:17 AM
Data warehouse, SQL Server 2005

Question on JOIN Clause
Folks, Is there any differences between selecting values from a table using JOIN clause, by using as JOIN or INNER JOIN. I mean, Will the result or performance changes when JOIN is used instead of INNER JOIN in MS SQL SERVER 2000/2005 Thanks in advance ! ash

Answer Question   |  November 2, 2007  9:00 AM
JOIN statement, SQL Server 2000, SQL Server 2005

Triggers in sql server 2005
hi Experts, I have created a table called MyEmployees with ManagerID,ContactID,etc.,.. fields. Also i created another table ManagerAndContact with Only ManagerID and ContactID as fields. Now what i need is, whenever am inserting a new row in MyEmployees table, the corresponding ManagerId and ContactId should be inserted into the second table – ManagerAndContact using trigger. [...]

Answer Question   |  December 2, 2007  2:36 AM
SQL Server, SQL Server 2005

RAID Levels on SAN
When deploying SQL Server 2005 Enterprise whether it is 32-bit or 64-bit versions using a SAN backend, does the Storage Methodologies regarding RAID1 (VRAID1) or RAID5 (VRAID5) change? There are differences of opinions in our organization regarding this issue. From the DBA Standpoint we strive to implement the correct solution using RAID1 or VRAID1 for [...]

Answer Question   |  July 15, 2008  11:13 AM
RAID, RAID 1, RAID 5, SAN, SQL Server 2005, SQL Server Enterprise Edition, VRAID1, VRAID5

VSS Backup Fails On Servers Running SQL Server 2005
I have 2 servers running SQL Server 2005. One has Standard and the other has Express. Both are running on Server 2003 w/SP1. Since I installed SQL 2005, Backup Exec (through Remote Agent) has been unable to backup VSS on either computer most of the time, although it’s occasionally worked for a day or two [...]

Answer Question   |  February 3, 2009  8:26 AM
Backup, SQL Server 2005, VSS Backup

VMware ESX 2.5 or 3.0 Virtualizing SQL (2000 or 2005)
First thanks for weighing in on this…. I support a department whose deployment of several department size SQL 2000 systems needed overhauling. I have recommended virtualizing their SQL because: 1. this is a department level database that has at best moderate use 2. It is currently and comfortably deployed on servers with 2GB of ram [...]

Answer Question   |  February 3, 2009  4:42 PM
SQL Server 2005, SQL Server Virtualization, VMware, VMware ESX, VMware ESX 2.5