Viewing 15 posts - 7,396 through 7,410 (of 7,428 total)
From 6.5 to 7 is a complete rewrite of SQL server and that is why you cannot use the old backup files. Since 2k is a further exstension of 7...
February 5, 2002 at 1:34 pm
I don't really think the intention was to tell you to detach attach the master db from 7 (which you cannot attach a master anyway with attach DB you just...
February 5, 2002 at 1:29 pm
Sounds to me like you did not actually refresh the recordset. What exactly does F2 fire as far as code would be where I check. Make sure it either requires...
February 5, 2002 at 1:18 pm
If you are referring to a large number of unique values as high density. Then the answer is you always the most unique values as your cluster evn thou you...
February 5, 2002 at 1:13 pm
Ok I was thinking maybe in an app. However are any of the Stored Procedures using cursors. I have seen this on a few cases where the type of cursor...
February 5, 2002 at 12:47 pm
My only concern with that previous by Steve or ## as by Brian is that only one user at a time can runn the procedure which is fine if that...
February 5, 2002 at 12:39 pm
As previously stated rework it to try to out from the inserted table to the table you want the data. Whether or not it is related a select into or...
February 5, 2002 at 12:33 pm
Can you provide you code for the connection minus sensative stuff. And the query and recordset object.
February 5, 2002 at 10:46 am
Really not much you can do as deletes are logged operations and that is what slows them down. You could however for the sake of time drop any non-clustered indexes...
February 5, 2002 at 5:51 am
The basics of it is SQL likes memory and CPU time but with IIS on the same server you create contention between the two fighting for resources (especialy if large...
February 5, 2002 at 5:38 am
Sorry on previous should be DBCC UPDATEUSAGE, this should clean up and inaccuracies in the sysindexes table.
February 5, 2002 at 5:34 am
Personally I would use DBCC UPDATEUSAGE to clean up any inaccuracies in the sysindexes table.
February 5, 2002 at 5:33 am
Try rebuilding the indexes.
Look at DBCC REINDEX in SQL Books Online.
After this the run updateusage and see if this helps.
One things to keep in mind, the tables will become unavailable...
February 5, 2002 at 5:29 am
Make sure auto update statistics and auto create statistics are on (I had a developer turn update off and started seeing delays). Also what does the maintainence plan actually do...
February 5, 2002 at 5:19 am
Personally I have seen improvements doing this (especially on larger tables). Also have seen bennifits by putting large tables into seperate filegroups even when the filegroup files are on the...
February 5, 2002 at 5:16 am
Viewing 15 posts - 7,396 through 7,410 (of 7,428 total)