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 [...]
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 [...]
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?
how i create refrence key of non-unique column in sql server 2008?
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 [...]
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 [...]
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?
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 [...]
I am going to use the sql code below in a query in delphy7 SELECT left(edit1.text, 5)+’0 ‘ FROM edit.text2
we have SQL 2008, and looking for tools to monitor sql and get sql diagrams. do you know any good tools?
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. [...]
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 [...]
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.
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?
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 [...]
HOW TO ROLL BACK SERVICE PACK IN SQL SERVER 2005
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?
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 [...]
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.
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 [...]





