SQL Server Help
Hi all, I am running into a little bit of a problem. I need to insert records with a stored procedure into a table based on the information selected. From the info selected, it decides what table to insert it into.  Example: Select top 1 SerialNo from dbo.Serial –returns ‘ASEEADL1234567′ based on the 8th letter [...]

Answer Question   |  March 31, 2012  8:36 PM
INSERT SELECT statement, SQL Records, SQL Server, SQL Server administration, Stored Procedures

Name Pipe work arounds in SQL 2005 database
I am working on a SQL 2005 data base, the supplirer is telling me that the reason I am unable to find the SQL Data Base when i run there Client install software through a VPN connection is that the Name Pipes are keeping the Data base from being accessed.   Can anyone herlp me with this issue [...]

Answer Question   |  March 31, 2012  12:41 AM
SQL 2005, SQL Express, SQL Server, SQL Server administration, SQL Server security

SQL Server Patch
How do you get notified when Microsoft is doing a SQL Server Patch? Is there a way to be alerted before they do a patch?

Answer Question   |  June 27, 2011  1:56 PM
SQL Server, SQL Server administration, SQL Server alerts

How can I create reference key of non-unique column in SQL server 2008
how i create refrence key of non-unique column in sql server 2008?

Answer Question   |  May 2, 2011  11:39 AM
SQL Column Headings, SQL Server, SQL Server 2008, SQL Server administration

Slow response with SQL server over a network.
Hi, We do a simple select 1 million record over a client server setup with SQL server 2008 and it take 10 times more time to get the results that doing the same request with Microsoft access db. Exactly the same setup for the network. Any special setup in SQL server we are missing. thank [...]

Answer Question   |  April 5, 2011  5:46 PM
Java, SQL Server 2008, SQL Server administration, SQL Server installation, SQL Server performance

Combining 2 queries in SQL 2008
I am having a little trouble combining the following 2 queries into a single nested statement (if indeed it’s possible). Can anyone assist? Query 1: SELECT Eff_Date, CoNum, Brandname, COUNT(Brandname) AS CountOfBrandName FROM dbo.Products WHERE (Eff_Date BETWEEN ’1/1/2010′ AND ’12/31/2010′) GROUP BY Eff_Date, CoNum, Brandname, DateApplied Query 2: SELECT Eff_Date, CoNum, SUM(CountOfBrandName) AS SUMofBrandNames FROM [...]

Answer Question   |  March 4, 2011  3:34 PM
SQL 2008, SQL Server 2008, SQL Server administration, SQL Server Query, T-SQL 2008

SQL I/O Best Practice
I just inherited a SQL SERVER 2005 32-bit attached to a SAN Server. I want to use SQLIO for performance testing and stress testing. The database is in production. Would it be a good idea to run SQLIO on a production sql server during non-work hours?

Answer Question   |  December 20, 2010  10:11 PM
iSCSI SAN Server, SQL 2005, SQL Server 2005, SQL Server administration, Windows Server 2003

Access or SQL Server tables
Yes I am consultant for a small business, and currently they have a Access database that works pretty decently. At the current situation, the owner needs another database. I really do not want to have to ask the developer to keep creating different databases that includes him having to put more separate tables on the [...]

Answer Question   |  December 16, 2010  4:02 PM
Access Tables, SQL Server administration, SQL Server Table Migration, SQL Server tables, SQL tables

How can I use SQL codes in delphy7?
I am going to use the sql code below in a query in delphy7 SELECT     left(edit1.text, 5)+’0 ‘ FROM        edit.text2

Answer Question   |  December 13, 2010  10:26 AM
SQL 2000, SQL Server 2000, SQL Server 2000 administration, SQL Server administration

What are the best tools for SQL monitoring and SQL diagrams?
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?

Answer Question   |  December 16, 2010  10:51 PM
Network Monitoring Tools, Network security, SQL 2008, SQL Server 2008, SQL Server administration

Install SQL Server 2005 without Local Admin
Books Online tells me … make sure you have administrator permissions on the computer where SQL Server will be installed. Based on the principle of using the lowest possible user rights is it possible to safely install SQL Server 2005 using an account or group that has the required level of privileges but no more. [...]

Answer Question   |  December 2, 2010  5:07 PM
Local Administrators Account, SQL Server 2005, SQL Server administration, SQL Server installation, Windows Server 2003

Can’t log in after upgrading SQL Server 2005 express to SQL 2005 standard
I have upgraded SQL Server Express 2005 to Standard 2005. Every thing is updated and all Services are well running, But not able to login because I have got only Configuration Tools in Menu- Start->Programs->MSS 2005->Configuration Tools. and if I try through Run SQLWB,it’s shows not avalable. Kindly help how can I will get all [...]

Answer Question   |  November 1, 2010  6:18 AM
SQL Server, SQL Server 2005 Standard Edition, SQL Server administration, SQL Server Express 2005, SQL Server Upgradation, SQL Server upgrades

Rolling back a SQL server 2005 database.
We need to roll back a copy of our database 5 hours. We are running sql 2005 on a windows 2003 server. How can we do this? We do not want to effect production data but want to report against the 5 hour old data.

Answer Question   |  October 23, 2010  5:33 PM
SQL Server 2005, SQL Server administration, SQL Server Database Rollback, SQL Server Rollback

Benefits/disadvantages of hosting SQL server on site versus MySQL in cloud?
What are the benefits or disadvantages of hosting a SQL server on site or using a MYSQL server in the cloud? The MYSQL box is much cheaper is there anything I will not be able to do with my web app using MYSQL?

Answer Question   |  November 3, 2010  8:14 PM
Cloud Computing, Cloud Computing in 2010, Cloud Services, MySQL, SQL, SQL Server, SQL Server administration

SQL Server 2005 & 2008 on a Cluster in Production
Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because they were so [...]

Answer Question   |  August 18, 2010  2:46 PM
Cluster management, Clustered servers, SQL Server (64-bit), SQL Server 2005, SQL Server 2008, SQL Server 2008 64-bit, SQL Server administration, SQL Server clustering

How to roll back service pack in SQL server 2005
HOW TO ROLL  BACK SERVICE PACK IN SQL SERVER  2005 

Answer Question   |  August 12, 2010  6:24 AM
SQL Server, SQL Server 2005, SQL Server administration, SQL Server Service Packs

Maximum memory on a 64-bit operating system?
I need to install a new SQL server and we are buying a 64-bit OS. What’s the maximum amount of memory that the operating system can hold/support/make use of?

Answer Question   |  July 13, 2010  6:01 PM
64-bit (x64), Capacity planning, Memory management, Operating systems, SQL Server administration, SQL Server memory

sql server 2000 in server
Hi, We have a server in which windows 2003 is installed and we have created users in the domain (eg – aaa). The server is installed with sql server 2000 and data is stored in the database. The user name for the server is administrator. The problem is when we login from the user computer [...]

Answer Question   |  February 2, 2010  5:19 AM
SQL Server 2000, SQL Server administration, Windows Server 2003

SQl Server Replication Internals
Can someone please explain me the internals of SQL Server replication. I need to know what happens when a new data is inserted, which all views and triggers get initiated and how the whole process works. Thanks.

Answer Question   |  November 10, 2009  5:19 AM
SQL Server administration, SQL Server replication

Database restore
I’m struggling with when is the right time to do my last transactional log backup before my full database backup. My question is this: if I do a full db backup once a day at 10pm; and a tran log backup every 4 hours (12pm, 4am, 8am, 12am, 4pm, 8pm). If i have to restore the [...]

Answer Question   |  October 27, 2009  2:53 PM
Database backup and recovery, SQL Server 2005, SQL Server administration