I have a sequel DB of users which is periodically updated by exporting to access, making changes, then re-importing amended table. After re-importing, the records are duplicated, and the autosequence jumps to over 10,000. I only have 682 records. (That is the highest index number used.) Why does...

24 hrs ago disk i/o and activity shot up to 100* with quues grwoing. our average i/o queue is normally around zero with disk activity at <15% we have had this before - lasts a couple of days and then stops. we have never found out why? can anyone help?

Based on the advice "Don't run the SQL Server Account as Local Administrator or member of the Administrator Group" Will this setup prevented you from using critical features? How did you get around this? The link below makes reference as to how a critical feature "Automatic Server Restart Feature"...

Looking for a way to "Bulk delete" in SQL Server 2008. Since I want to use WHERE for limiting the rows in action, I know I can't use TRUNCATE. Should I use something like "batch deletes" or "bulk copy"?

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 I...

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...

We deal with a very large database that grows at an avrage of 50GB a month. The current database size is 700 GB. All the transaction tables are horizontally partitioned to seperate filegroups assigned to a individual data files holding each months data. What would be the best strategy to retain...

For (AS/400) I need to create a source member with multiple sentences of sql: i.e. update aa.... update bb.... update cc.... , and then run these source member with runsqlstm. Is it possible? which is the character to separate between sentences? Thanks in advance

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 you for...

To follow this tag...

I agree to TechTarget's Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.

I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.