Viewing 15 posts - 721 through 735 (of 2,387 total)
sp_helpfile will tell you the database file size which have been allocated to your database.
SELECT FILEPROPERTY('yourdatabaselogicalfilename', 'spaceused') will give you space used for your database files.
December 30, 2003 at 9:39 am
Even though you change recovery mode to 'simple', any activeties such as insert/delete/update in your query will still be loged in transaction log file during the query execution.
You have...
December 30, 2003 at 8:22 am
Can you check whether structures of tables have been altered, for example adding new column, and the query may use wrong indexes and statistics.
Is Auto Create statistics turned on?
sp_createstats creates...
December 29, 2003 at 12:09 pm
Can you start SQL Server manually?
Run sqlservr.exe -c -T3608 in command prompt from node which ownes all resources.
December 24, 2003 at 8:22 am
Make sure all resources your SQL Server depends on all online before you bring SQL Server resource online.
Here are the steps to move Model database.
1. Add -T3608 to startup parameter.
2....
December 24, 2003 at 7:59 am
Have you tried to generate SQL scripts from EM with option "generate scripts for all dependent objects"?
December 24, 2003 at 7:45 am
Did you add trace flag -T3608 to startup parameter and restart SQL Server before moving Model database?
December 24, 2003 at 7:38 am
You need to use SQL Server virtual name for the connection.
December 24, 2003 at 7:34 am
quote:
I am running a sp on SQL2000 on Win2k machine with 128 MB ram.
December 24, 2003 at 7:30 am
quote:
We have seen sp's that run in our production environment slow down dramatically on the 2003 box, even though the 2003...
December 24, 2003 at 7:24 am
Try dynamical query.
create proc spMyProcedure @op varchar(10), @ids varchar(20)
as
declare @cmd varchar(255)
select @cmd = 'DELETE FROM tblOne WHERE tblOne.ID ' + @op + ' (SELECT * FROM #tblTemp)'
exec (@cmd)
EXEC spMyProcedure @op...
December 23, 2003 at 12:53 pm
Run "restore headeronly' on the last backup from your backup device and find out "backupfinishdate", compare to current datetime and issue the backup statment with/without init according to the time...
December 23, 2003 at 7:42 am
I don't know the best/fastest way but the safest way for your data is export/import.
You have to rebuild your server too since server was built with "Cyrillic_General_CS_AS collation" and the...
December 23, 2003 at 7:34 am
What is the error message? Do you have similar problem if you work at office (PC is in Local Area Network)?
December 23, 2003 at 7:25 am
select count(*) from (select distinct orderid, customerid from orders1) as a
December 23, 2003 at 7:07 am
Viewing 15 posts - 721 through 735 (of 2,387 total)