Thanx For the response guys, i will read up on the matter. Thanx
Hi Guys Thanx for the response. Can you tell me why i never received these errors when sql only had 1.7 Gig RAM? Why does sql suddenly get memory...
Hi There I am a bit stumped. I have a SS2000 enterprise Edition instance. Up until 2 days ago it had performance issues, related directly to huge...
Hi There I know for parttioning or just general filegroup administration etc, it is best practice to split your data files on seperate disks, same...
Thanx A million for your input Joe and ndinakar, i will be meeting with the Dell vendor soon. Cheers
Hi Joe Thank YOu i will run these scripts. So what solution do you reccomend?
Hi ndinakar. If i search fro SQL Lite on the net, i only find an oracle/mysql tool, exactly what sql lite are you refferring to? Is this in terms of...
HI JOe Interesting you say that, the instance is currently on a SAN. I was reccomending that it be taken off the SAN, do you reccomend , local RAID...
Well i cannot , it is a single update statement joinging to a view, thats it, but DTA keeps falling over ? Could it have somethig to do with the...
Hi There Is anyone else experiencing problems with DTA when query tuning? Basically DTA only works is i try tune a very simple query, like a simple...
Hi ndinakar How do you backup the database ? DO you use SAN snap/clone technology ? How long does your backup take ? Thanx
Correct. Output from @@VERSION from my 64bit installations. Microsoft SQL Server 2005 - 9.00.2153.00 (X64) May 9 2006 13:58:37 Copyright (c)...
Hi There I have an OLTP DB currently at 50Gig. In a short period of time this will grow to at least a terrabyte. I am already looking into...
HI There I have a server running Sql Server 2005 Standard Edition X64. There are 3 instances on this server. The server has a total og 16Gig Ram, i...
You can use the copy database wizard, it will copy all objects from the database , and can also copy all logins/users and jobs etc
Hi Everyone. I am trying to get ideas for a possible technology we could use for a certain scenario. In a nutshell we want to run a distributed...
Thanx for the feedback Joe, i get what you are saying. I do agree on the leghtweight pooling etc , just wondered if anything changed with 64 procs....
Thanx ranjitjain But this exactly the same kind of article i keep finding. It does not go into any detail about server configuration and setting to...
Hi There I am having trouble finding out if there are any special considerations for Sql Server 2005 64 bit. BOL is useless, basically i need to...
Hi Guys Yes i am aware of all these methods, i guess you would have to see the whole sp to understand, the complexity of the logic around the cursor...
Separate names with a comma.
