Viewing 15 posts - 601 through 615 (of 1,065 total)
Run the delete from SSMS with "SET STATISTICS IO ON"
Look at the statistics, and that should tell you which table(s) are causing excessive IO
June 29, 2009 at 8:56 am
Take a look at the other tables referred to in the execution plan.
I suspect that these have a foreign key reference to the table you trying to delete from, and...
June 29, 2009 at 8:06 am
it leaves me with up to 24 backup files per database per day which will increase the risc of human error when restoring
Take the advice to leave things as they...
June 26, 2009 at 8:25 am
Credit where it's due for giving it a go
Hope my post didn't sound too critical... it was meant as constructive criticism:blush:
June 26, 2009 at 8:06 am
I think you need to test the solutions in your blog first.
The "Procedure for droping all constraints from a table" won't work because of this (amongst other things):-
WHILE(@@FETCH_STATUS-1)
It would also...
June 26, 2009 at 7:49 am
Manually creating your own sequence numbers has a lot of potential pitfalls.
There was a thread a few days ago regarding a similar issue, that you should read.
http://www.sqlservercentral.com/Forums/Topic737659-1291-1.aspx
The response from John...
June 26, 2009 at 3:04 am
Was that from a KB or other link?
No... because a definitive list of trace flags doesn't seem to exist, I've built up my own list.
Whenever I discover a new one...
June 25, 2009 at 10:05 am
WITH(NOLOCK)
That won't help... you may be making the decision on whether or not to delete from table1 based on updates to table2 that may be rolled back
June 25, 2009 at 8:16 am
This is the description for the trace flag:-
By default, lock partitioning is enabled when a server has 16 or more CPUs. Otherwise, lock partitioning is disabled. Trace flag 1228 enables...
June 25, 2009 at 7:59 am
This is the area of the registry you need to look at:-
HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo
June 25, 2009 at 6:25 am
Not necessarily... the aliases are stored as entries in the registry, and there are other tools that will maintain these for you.
If you have SQL 2000 client tools, then the...
June 25, 2009 at 4:55 am
The answer is yes.
Clustering just allows you to have 2 (or more) physical boxes that are capable of hosting your SQL instance and its resources.
All the SQL configuration is done...
June 25, 2009 at 4:15 am
You don't enable AWE on a "node", you enable it on a SQL "instance".
It sounds as though one of your instances has AWE enabled, and the other doesn't.
It's up to...
June 25, 2009 at 3:26 am
You need to create the alias on your remote machines.
June 25, 2009 at 3:02 am
When faced with this I usually reverse engineer the database schema using one of the data modelling tools e.g. ERWin, ER/Studio. You can usually download a trial edition of one...
June 24, 2009 at 3:05 am
Viewing 15 posts - 601 through 615 (of 1,065 total)