Currently looking at this. Have noticed the following so far 1. The text data is saved across all datafiles. However if you reindex a table...
Basically because of the lack of downtime we are allowed. We are seeing more use of one array than another, same disks, same size datafiles (not...
dineshasanka, I don't have two filegroups. I have one filegroup but multiple files within that one filegroup FrankKalis Thats what I thought. The...
I have a DB and we have one filegroup (PRIMARY). This file group contains 4 data files (i.e. 4 different data files belong to the same filegroup)....
This SQL should show you the max number of bytes per row. Obviously if you are using variable length columns the results may not be entirely...
I want to do the following. Have 3 + servers that have the same copy of the same DB on (it has to be real time - hence log shipping is out of the...
It is my understanding that if a trigger fails to execute then the SQL that fired that trigger will also fail to execute. I basically need triggers...
I was wondering if anyone can help me. Are the following SQL statements different in any way (accept syntax)? Would one out perform another on SQL...
Thanks for your help
If you set a table as pinned will it always remain this way unil you unpin it. Want I want to know is if I restart the SQL Server Service will I have...
Does anyone know of any (hopefully) free plug ins for query analyser (SQL Server 2000) that allow you to set up different coloured backgrounds to...
I'm sorry Twan, I dont understand what you mean by slots. Do you mean SQL Server 2000 will try to extend each row on the data page and if it cant it...
I know EM is not very good, however I was using profiler at the same time so it would show exactly what was running. I suppose the real question is...
Thanks for your help. However taking the nulls off in EM also created a new table, inserted everything into it and then renamed them. I still dont...
Sorry I forgot to say. Nobody else was connected to the DB at that time, no other Jobs were running on the DB (I was using profiler whilst I was...
Does anyone know why ALTER TABLE seems to take so long. For instance consider a small example table called TestTable. Adding a new field does...
I have several large tables and occasionly these need new fields adding to them. I normally use Enterprise Manager for this. This process can take...
Right I feel that I am fairlly knowledgable with a lot of DB Issues. I currently have a Stored Procedure that retreives a lot of information when...
Separate names with a comma.
