Viewing 15 posts - 961 through 975 (of 2,387 total)
If your database is very large and very busy, data has be spreaded into multiple data files, SQL Server will create multiple threads (one per physical file) to access the...
October 16, 2003 at 12:17 pm
Indexes is part of your database and it will be in either MDF or NDF files, Doesn't matter which drives it resides.
quote:
October 16, 2003 at 11:57 am
Run select * from sysobjects where xtype = 'U' in TempDB to see any temp tables created and sp_spaceused to find out the temp table's size if there are any.
...
October 16, 2003 at 11:48 am
Any one of them failure will cause your database corruption and stop working.
What do you mean "can I retore to the last commited transaction?"
October 16, 2003 at 11:41 am
Your statements craeted deadlock on page PAG: 6:1:56182 involving parallelism from both spid 131 and spid 57. SPID: 131 main thread has locked above page but its sub-threads (1,2) are...
October 16, 2003 at 9:50 am
Select * from [my-server].mydb.owner.table
October 16, 2003 at 9:21 am
October 16, 2003 at 8:55 am
What is MDAC version? SQL Server service pack?
Edited by - allen_cui on 10/16/2003 08:23:31 AM
October 16, 2003 at 8:23 am
Check registry key "currentversion" in hkey_local_machine --> software --> microsoft --> mssqlserevr --> mssqlserver --> currentversion
October 16, 2003 at 8:21 am
Is Windows NT group/user 'DDDD\blah your login? Have you tried to grant it to accsse SQL Server and run your sp?
According to explanation of [@set_user], If user is not specified,...
October 16, 2003 at 7:59 am
That is what I expected to hear. Shrink database transaction log in 7.0 is different than in 2000. See details in following KB.
http://support.microsoft.com/default.aspx?scid=kb;en-us;256650&Product=sql
October 16, 2003 at 7:26 am
I would change the query to "sp_configure" to see whether it works. If it does, I guess you have to review your stored procedure "msdb.dbo.rpt_JobSummary".
October 16, 2003 at 7:22 am
quote:
We are planning the SQL 2K migration but we have noticed that some databases are performing poorly and we are seeing...
October 16, 2003 at 7:09 am
Viewing 15 posts - 961 through 975 (of 2,387 total)