Thanx For the response guys, i will read up on the matter.
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...
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...
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.
Thank YOu i will run these scripts.
So what solution do you reccomend?
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...
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...
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...
How do you backup the database ? DO you use SAN snap/clone technology ? How long does your backup take ?
Output from @@VERSION from my 64bit installations.
Microsoft SQL Server 2005 - 9.00.2153.00 (X64) May 9 2006 13:58:37 Copyright (c)...
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...
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
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....
But this exactly the same kind of article i keep finding.
It does not go into any detail about server configuration and setting to...
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...
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.