Viewing 15 posts - 1,411 through 1,425 (of 2,462 total)
pankaj.kuchaliya (8/20/2010)
I read out "if i will rebuild the clustered index on new file group then it will move the table to new file group."
Yes you will take this...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 20, 2010 at 12:54 am
you can go some optimal settings according to your asking requirements in that index like MAXDOP or SORT_IN_TEMPDB
these might help you.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 10:48 pm
sushantkumar1984 (8/19/2010)
@bhuvneshHow is that compression different from sql 2005?
Thanks,
Sushant
http://sqlblog.com/blogs/tibor_karaszi/archive/2007/12/12/backup-compression-in-sql-server-2008.aspx
http://www1.unisys.com:8081/eprise/main/admin/corporate/doc/41371394.pdf
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 10:31 pm
then how did you resolve it ? compression or zip ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 4:14 am
Krasavita (8/18/2010)
When I ran job I got this error:The package execution failed. The step failed. I get this error when I view job history
right click the maintenance plan...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 3:51 am
If you are running short of space on disk , then you should go for shrink. Shrinking data file should be done with very intelligently, for genuine cause as it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 3:50 am
You can do one thing , dont drop/create index instead , DISABLE it before purge process ( it must contain
INSERTION into destination table ) and then REBUILD it...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 1:41 am
SELECT TOP 1 Stock FROM Tb_Item_Cost_Ledger WHERE (ItemId = Tb_Item.CoA_ID) AND (Vdate <= '20100101')
AND ISNULL(stock, 0) > 0
ORDER BY Vdate DESC
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 1:22 am
can you explain the output logic, what you are trying to get ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 1:03 am
i don't think this is complete query as there is no stock > 0 clause , post complete query
.Additionally where are the table definition part ? that can...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 12:50 am
there is a column "last_execution_time", check with it
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 12:22 am
PradeepVallabh (8/18/2010)
What are the various factors i need to consider
USE following query for every concerned table dbcc showcontig( 'tablename')
for more details google "dbcc showcontig( 'tablename')"
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 19, 2010 at 12:07 am
🙂 for that Microsoft has to hire me. jokes apart , in sql 2008 there is feature of backup files compression
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 18, 2010 at 10:08 pm
Jeff Moden (8/18/2010)
Bhuvnesh (8/18/2010)
Anamika (8/18/2010)
SELECT * FROM [font="Arial Black"]SYSOBJECTS[/font] WHERE XTYPE = 'P'
output of this query gives the new SP name.
My problem is while getting the create script for the...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 18, 2010 at 9:59 pm
mirravi (8/18/2010)
what shal i do now? any suggestions.
uSe my second last post's query
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
August 18, 2010 at 9:54 pm
Viewing 15 posts - 1,411 through 1,425 (of 2,462 total)