Viewing 15 posts - 1,351 through 1,365 (of 2,436 total)
Based on "actual size is 180Gb ,used space is 3GB and unused space 177 GB" I'd say that you've got bad code out there somewhere. Yes, re-indexing can cause space...
May 10, 2006 at 10:51 am
Don't think that this list will be authoritative in all cases on all networks. There are lots of reasons why all of the SQL Servers on a network potentially will not show...
May 10, 2006 at 9:42 am
The model database should NEVER grow. It is used as a template to create tempdb on server startuo and for creation of all other databases. That more or less makes...
May 10, 2006 at 9:27 am
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round II
DBCC DBREINDEX
...
May 10, 2006 at 9:21 am
Here's my 'short list' for tuning:
Round I
DBCC UPDATEUSAGE
UPDATE STATISTICS (with FULL scan) for all tables
exec sp_recompile for all tables
exec sp_refreshview for all views
Round II
DBCC DBREINDEX
...
May 9, 2006 at 11:16 am
I do not know ... have you tried googling it ? I generally use google as a first step for unknown issues ... you'd be suroprised at what you might...
May 9, 2006 at 9:17 am
What is in the SQL Server errorlog ? Usually there is some information there is it relates to permissions of the fact that there is not enough disk space.
May 5, 2006 at 12:16 pm
For your XP machine, just kill it (or reboot). There should be no ill effects. As for diagnosing a slow SQL Server here's my 'short list' for tuning:
Round I
DBCC...
May 5, 2006 at 12:14 pm
You might also look into your DNS and WINS settings on the network cards for both computers. Verify the subnet masks. Talk to your network people and make sure that...
May 4, 2006 at 2:54 pm
Oh well ... I guess that I'm one of the few surviving 'dinosaurs' left ... this tired mind remembers seeing first run epsiodes weekly in black and white !
May 4, 2006 at 12:35 pm
I had to respond since no one else did ... I guess that we have both dated ourselves pretty well now ... maybe we ought to talk to 'Grandpa' about...
May 4, 2006 at 12:23 pm
... and a question for you now jgljgl ...
"Who lives at 1313 Mockingbird Lane "
May 4, 2006 at 11:41 am
Viewing 15 posts - 1,351 through 1,365 (of 2,436 total)