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...
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...
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...
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...
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...
I have been able to find this default cursor behaviour in BOL.
So if anyone can take the time to answer these thank you very much:
I pick up the following in a profiler trace.
exec sp_cursorexecute 197, @P1 output, @P2 output, @P3 output, @P4 output,...
I have a table:
I am in need of some high cpu sql statements tips.
I have been performance optimizing and baselineing for a while, but i am a bit stumped...
I realize this is probably a basic question or at least i hope so but i cannot get distributed transactions working.
BOL is just driving...
Is there any need to manually update stats during maintenance jobs at night if the database is set to auto update stats ?
I am using SS2005 Enterprise Edition, proper release version not a ctp or anything
When i try navigate to my packages in MSDB i get the...
Does any one have a good resource or link on the side by side migration process and considerations for migrating a sql server 2000 database...
This is probably an old often asked question.
I need to do the following:
INSERT INTO TABLEA (COLUMN LIST) SELECT (COLUMN LIST) FROM...
When i setup a perfmon trace on a server for normal server counter, processor, physical disk etc everything is ok.
As soon as i add any...
I have various scripts and profiler templates that help me track cpu and io usage.
To find out which queries are using the most cpu and...
The other day i was testing a new backup script that deleted old backups etc.
For some unknown reason 9 hours later the job was still...
Ok hopefully this is a simple question.
Under replication monitor on a distributor, under replication alerts, i have enabled the...
Separate names with a comma.