Search results for query: *

Hi all, I have MS SQL 2005 Standard installed. Running on Windows 2003. 16GB of RAM I understand that in 2005 they changed memory management so that they would not have an issue with O.S. Ram memory being relinquished by SQL server. in 2000 it never gave memory back to the O.S. until you...

hi ptheriault thanks for the code, I will check it out/ Do you know why it happens? Its such a weird thing thanks for the code I will try and see if it helps

Hi I hope you can help. My sql server 2005 (CLustered, active active) running on an MSA disk array has been working fine, all of a sudden the simplest of queries, i.e. SELECT COUNT(1) FROM tableA spikes the CPUs (there are 8 in there). With 8Gig of Ram to use. I have checked execution plan...

thanks guys for the info. My apologise with regards to VM ware . What I meant was Virtual Processors. I.e. 1CPU has 4 cores aka 4 Virtual Processors. Bad terminology, I know. I wouldnt ever dream of putting SQL SErver on a VMWare system. Apologise Ok so thanks for the licensing info

yep the processors have 4 cores each, so yep Microsoft still charge per CPU not per core. Is it possible to add more CPUs and then tell SQL SERVER 2005 to use the extra CPUS at a later stage?

Hi I have a virtual Box where i want to build a SQL Server 2005 instance. This is going to be licensed using per processor licensing. currently starting at 2 processors. How easy is it to tell SQL SERVER 2005 to use additional CPUs if I change the processors to 6 processors on the box. i.e...

Hi Paul thanks for the reply. Ok is there a good resource on the net to get replication via SQL SERVER 2005 replication working correctly. Thanks Sanj

Per second, not sure, but we get about 5mm hits per day. We insert a lot rather than read, so the shape is a bit different. We are in a cluster (Active-Active), so mirroring I dont think is an option. Any other ideas?

thanks for that, the table didnt have a clustered index my bad thanks

Hi I am having a weird problem RUnning both UPDATE STATISTICS <<table>> WITH FULLSCAN and sp_updatestats both dont change the modCtr column in Sysindexes for that database. Does anyone have anyideas??????????? Even a re-index of the table doesnt shift the indexes on my tables Any ideas

Hi I am currently running SQL Server 2005 - Standard in a cluster and want to replicate this out. I do need to keep the subscriber in sync all the time (Live). I dont want to use the in-built SQL Replication as I think it is resources intensive and they havent got it right. Database is highly...

so using SSIS I can transfer the database to the other server? is that right using the transfer database task!!!

Why would they offer 2000 compatability and then not enable us to restore the database on a sql 2000 server. I even tried attach and re-attach but with no luck at all. Is there a system or a 3rd party vendor which can convert the backup to 2000??? Sanj

Job history shows two schedules, I deleted and re-created them and now it has fixed it but its such a bad thing when upgrading from SP1 to SP2(a) Their were schedules in sysjobschedules which had no schedule_id inside of sysschedules However, It is fixed now by deleting the jobs and...

Hi This is really really annoying, I have checked on Microsoft website and other forums about this apparent problem with maintenance tasks, or just generally anything that is scheduled via SQL SErver Agent going out of sync or jobs for no reason running twice, i.e. my backups are running twice...

no i havent tried that yet, but that is strange though that you can keep a 2000 database and then when you want to restore it to a 2000 server it doesnt like it. Is that because the backup is done in 2005 and hence not compatable

Hi I am having a problem with a 2000 backup of a database made on a sql 2005 server. The database was created as a 2000 database on 2005 box. I now want to back it up and restore it on a 2000 box, however I get an error of compatibility. Is their anything else i can do?? I have set the...

Last week sometime

Hi I have upgraded my cluster environment SQL SERVER 2005 Standard from SP1 to SP2 (4th Apr 2007). I am getting the following strange errors on the server, i. Management Studios - trying to open the Maintenance Plan to see the backup plan, not possible error: Value set to NULL, unable to...

I thought it would need to do that. Wow, I guess I need to teach the guy how to BULK INSERT instead of running the heaviest statement in SQL (UPDATE) Thanks Sanj