Viewing 15 posts - 45,496 through 45,510 (of 49,552 total)
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 11:14 pm
Please post the full table definitions (as Create statements) and the query that you have now.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:46 pm
If shrink is currently running, you will just have to wait for it to finish. Adding more files is not going to help if you have an ongoing shrink operation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:37 pm
Ankit Bhurat (7/22/2008)
SELECT * FROM [TableName] where Database = 'ReportDB' and Userid = 'John'...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:35 pm
Fix the code's a popular option.
Post the code please, the table structures and the index definitions. Talking about performance in the abstract isn't very useful.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:34 pm
As for what queries are run, that will have to be profiler or a server-side trace.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
July 22, 2008 at 12:31 pm
Viewing 15 posts - 45,496 through 45,510 (of 49,552 total)