Viewing 15 posts - 45,511 through 45,525 (of 49,571 total)
Those disk stats don't look good. The sec/write is far too high. Could you plese describe how the disks are set up. How many diska, how many separate arrays, what...
July 23, 2008 at 12:52 am
A full new instance with a different instance name, separate services, etc?
You install SQL again and when it asks for default or named instance, you give it the name of...
July 23, 2008 at 12:48 am
CXPacket is caused by parallel skew, when a process parallels and the part on the one processor runs faster than the other (usually due to having an imbalanced split in...
July 23, 2008 at 12:45 am
This strange thing is that unless you are running in a high isolation level or this select is inside a trigger, a select shouldn't cause a deadlock.
A deadlock requires that...
July 23, 2008 at 12:27 am
Do you know what resources its deadlocking over? If not, you can enable either traceflag 1204 or 1222 (DBCC TRACEON(1222, -1)) and get the entire deadlock graph written into the...
July 23, 2008 at 12:13 am
shameersinbox (7/22/2008)
How can i restore it into SQL server 2005.
Without knowing how it was created, no idea. Please ask your client where the file came from and what app they...
July 23, 2008 at 12:03 am
The first issue is only a problem if you install the first (or is is 2nd?) release of SP2. Rather install SP2 and one of the later CUs. I think...
July 23, 2008 at 12:02 am
Sandy (7/22/2008)
Use attach and detach method..simple...:)
Cheers!
Sandy.
Can you please check your facts before posting in the future? Thanks.
July 22, 2008 at 11:47 pm
Is the row with the highest messageID the one that's just been inserted? If so, you can find it in the inserted table.
Perhaps something like this?
create trigger nukespam on...
July 22, 2008 at 11:42 pm
Can't be done. There is no way to downgrade a database from SQL 2005 to SQL 2000. That holds true for all the versions. The internal structure of the data...
July 22, 2008 at 11:33 pm
It's not so much what it does (which the others have covered), but what it doesn't. Nolock does not solve performance problems. All it does is solve some of the...
July 22, 2008 at 11:30 pm
MANU (7/22/2008)
Gila,I dont think sql server will kill it by itself. Will it?
Not unless it gets into a deadlock situation.
July 22, 2008 at 11:14 pm
Please post the full table definitions (as Create statements) and the query that you have now.
July 22, 2008 at 11:13 pm
Kill the data import, or wait for it to finish and to let the shrink complete. Depends how much time you have available and how easily/completely the import will roll...
July 22, 2008 at 12:48 pm
Apex SQL log reader?
It will show you transactions that occured. I don't know if the transaction has login/user info in it. It will show you the data that changed. How...
July 22, 2008 at 12:46 pm
Viewing 15 posts - 45,511 through 45,525 (of 49,571 total)