Viewing 15 posts - 2,731 through 2,745 (of 3,061 total)
Bruce W Cassidy (2/9/2009)Try creating an index on a bit field in SQL Server 2005. Yes, it works.
Unfortunatelly that's not the concept of an Oracle bitmap index 😀
Oracle...
February 10, 2009 at 4:07 am
jgrubb (2/9/2009)
... but aggregates and functions are different.
Not to mention Triggers, Cursors, Partitioning and stuff that does not exist in the SQL Server world like bitmap indexes, star-transformation, materialized...
February 9, 2009 at 10:55 am
Let me help you with a couple of them...
1. While instalation i am getting one error "restart ur system and install again" ?
Server liked the process that much it wants...
February 9, 2009 at 9:45 am
Oracle documentation is clear, comprehensive and FREE!... check here http://www.oracle.com/pls/db102/portal.all_books
If you have Transact-SQL skills please take into consideration things are not that straighforward in the Oracle side, SQL and PL/SQL...
February 9, 2009 at 8:53 am
:w00t: never got that one. What do you see before and after that error message?
February 9, 2009 at 8:31 am
SQL Server lock resources have nothing to do with how much memory you have in the box.
February 9, 2009 at 7:29 am
1- Take Microsoft training
2- Get certified
3- Get a job as Transact-SQL developer
4- Get an entry level job as SQL Server DBA
February 8, 2009 at 7:00 am
You should be Okay.
SQL Server standard edition can use as much memory as O/S maximun and dynamic AWE support is also available (1).
(1) http://www.microsoft.com/Sqlserver/2005/en/us/enterprise-compare-editions.aspx
February 8, 2009 at 2:16 am
shri_sastry (2/6/2009)
Thanks for the script, how do I know when was the last time the indexes were rebuilt/reorganized. I am trying to come up with...
February 7, 2009 at 3:37 am
David got it covered but I would like to add my two cents.
If you are working in a maintenance window -which means users are not there to bother you- ......
February 6, 2009 at 10:54 am
Script just processes any index which avg_fragmentation_in_percent is greater than 10%, isn't it?
Question here is... Why?
Those scripts and policies are good for small size databases, not for a 900 Gig...
February 6, 2009 at 10:47 am
It looks to me your transaction got commited.
How about point-in-time recovery?
February 5, 2009 at 4:07 am
LAW1143 (2/3/2009)
The objective is to only rebuild the indices on the data we plan to retain.
we have ~5 years of transactional...
February 3, 2009 at 10:31 am
I'm a little confused because your post first states rebuilding indexes would be impractical because of their size then you are entertaining the idea of bcp-out/bcp-in the whole table which...
February 3, 2009 at 10:05 am
Viewing 15 posts - 2,731 through 2,745 (of 3,061 total)