Viewing 15 posts - 316 through 330 (of 860 total)
homebrew01 (4/6/2009)
EXEC sp_dbcmptlevel @dbname ='DatabaseName', @new_cmptlevel = '90'
.
dbcc updateusage ('DatabaseName') with count_rows
.
use DatabaseName
.
exec sp_msforeachtable 'alter index all on ? rebuild WITH ( FILLFACTOR =...
April 6, 2009 at 7:52 am
Yes, that's true on whatever the members said.
First of all bear in mind that you should arrive at this situation where you should shrink your file. If the files have...
April 6, 2009 at 7:44 am
ALZDBA (4/6/2009)
San (4/6/2009)
Somehow I managed to install SQL2k5 with different instance name and logged using "machineName\instanceName". Now another problem is that, when I select " " option in SERVER...
April 6, 2009 at 7:38 am
radek (4/6/2009)
Table is not big, about 20 000 rows with 15 columns, index has 18 pages, and depth=2.What cause that it cant fragmentation? only few pages?
thanks Radek
But let me ask...
April 6, 2009 at 7:32 am
ksparke (4/6/2009)
Have you tried using the xp_smtp_sendmail in master? If not i'll send you an example;-)
Nope
April 6, 2009 at 6:51 am
radek (4/6/2009)
I have question about fragmentation indexes.
I have table with with Primary key(clustered index).
Fragmentation is 30 percent on nonclustered index, then I run reindex on this index,...
April 6, 2009 at 6:40 am
San (4/5/2009)
Also one more doubt, I had 6 jobs runing in the server. Since I reinstalled SQL2k5 I lost all those jobs. Is there any way to get it back..?
Thank...
April 6, 2009 at 6:36 am
Kailash Mishra (4/6/2009)
I want to generate an email from my database. I have tried it lot of time by reading a lot of forums. But I still unable to...
April 6, 2009 at 6:27 am
karan457 (4/1/2009)
connection failed check sql server registration properties
After registering did you try to restart the sql server or the OS? Restart both and let us know, more insight into this...
April 6, 2009 at 6:26 am
Dean Jones (4/6/2009)
Krishna Potlakayala (4/6/2009)
Dean Jones (4/6/2009)
How can this be doen with Delete and Updates, i thought it was mainly reads.
You cannot use...
April 6, 2009 at 6:22 am
vrabhadram (4/6/2009)
is there any data loss if i do shrinking.thanks
What are you trying to shrink here? Shrinking is basically releasing any unused space to the OS.
April 6, 2009 at 6:15 am
vrabhadram (4/6/2009)
problem is the staging database is in restore status, how can i remove this status.
is there any problem with the scheduling...
April 6, 2009 at 6:14 am
Achtang (4/5/2009)
Have a question: I read having high page life expectancy is good? how to achieve this? with proper indexes or more memory?
Should not be lesser than 300s. Yes proper...
April 6, 2009 at 4:51 am
Dean Jones (4/6/2009)
Just to give you guys an update, we are still experiencing other deadlocking problems, I have read that try/catch blocks can help resolve deadlocking problems, is this true.
Also,...
April 6, 2009 at 4:46 am
Perry Whittle (4/6/2009)
Krishna Potlakayala (4/3/2009)
As Grant mentioned, what recovery model it is in?Grant who??
Oops..I get confused with the pics...sorry Perry:-D, next time i should focus on the names
April 6, 2009 at 4:38 am
Viewing 15 posts - 316 through 330 (of 860 total)