Viewing 15 posts - 1,216 through 1,230 (of 2,462 total)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 22, 2010 at 3:52 am
Enable TCP/IP protocol on SQL Configuration.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 22, 2010 at 3:45 am
It also depends on number\size of columns .
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
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...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2010 at 2:18 am
no. you can remove any post, either you can edit it and remove the post's text
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2010 at 6:08 am
Viewing 15 posts - 1,216 through 1,230 (of 2,462 total)