Viewing 15 posts - 1,216 through 1,230 (of 2,463 total)
sqlserver12345 (10/25/2010)
I need a t-sql (specifically a select statement) which can retrieve disk space(total/used/remaining..all drives)database space (total/used/remaining)Thanks
See how much below SP helps you.
Text
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE PROCEDURE dbo.sp_SDS
@TargetDatabase sysname...
October 27, 2010 at 2:07 am
ecarmon-249589 (8/1/2005)
How can we reclaim this space?
You can also reclaim space from LOG perspective . First backup the log and then Do the DBCC shrinkfile
October 27, 2010 at 2:02 am
brian_winzeler (10/21/2010)
No item by the name of 'ix_name' could be found in the current database 'db', given that @itemtype was input...
October 22, 2010 at 3:52 am
It also depends on number\size of columns .
October 19, 2010 at 5:38 am
Lowell (10/15/2010)
Bhuvnesh (10/15/2010)
What does it mean?
when you do a backup that does not include the WITH INIT clause, the new backup is appended to the same physical file. So after...
October 15, 2010 at 5:49 am
Toby White (10/14/2010)
I just want to delete certain backups on the file.
What does it mean?
October 15, 2010 at 2:28 am
GilaMonster (10/14/2010)
MindOptimizer (10/14/2010)
GilaMonster (10/14/2010)
Since it's running after an index rebuild, you only need to update column statistics, not index statistics.
Will it get benefit, if we go for first "update...
October 14, 2010 at 6:06 am
rockingadmin (10/14/2010)
Both the users having dbowner permission
have you tried this ?
goto properties>>security and select "be made using this security context" and use the login
October 14, 2010 at 5:50 am
GilaMonster (10/14/2010)
Since it's running after an index rebuild, you only need to update column statistics, not index statistics.
Will it get benefit, if we go for first "update statistics" then...
October 14, 2010 at 5:41 am
try the login (dbowner) available in both sides while setting up linked server
goto properties>>security and select "be made using this security context" and use the login
October 14, 2010 at 4:53 am
you can divide heavy transactional DB and less transaction Db and set their job accrodingly like for "heavy" DB daily and for "less Db" weekly OR you can choose...
October 14, 2010 at 4:10 am
Two things come to my mind
1. the table may be low in volume( small data)
2. if it is fresh insertion which results in contiguous page filing/less page split
October 14, 2010 at 2:23 am
f_ernestog (10/11/2010)
Lately I've been having to recompile the very same SP because it starts taking very long, at first I had to do it around once every 6 months, then...
October 12, 2010 at 2:21 am
pujain (10/11/2010)
Thanks For your reply,Task is completed.
Puneet , Did you notice how much log drive and tempdb got eaten ? additionally did you set the sort_in tempdb = on...
October 12, 2010 at 2:18 am
Viewing 15 posts - 1,216 through 1,230 (of 2,463 total)