Browse by Tags

All Tags » performance » system
  • TSQL to generate GRANT statements from a database

    select p . state_desc + ' ' + p . permission_name + ' OBJECT::' + s . name collate Latin1_general_CI_AS + o . name collate Latin1_general_CI_AS + ' TO ' + u . name collate Latin1_general_CI_AS + 'GO' , p .* from sys.database_permissions p inner join sys.objects o on p . major_id = o . object_id inner join sys.schemas s on s . schema_id = o . ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on August 17, 2007
  • 32bit vs 64 bit what other factors you need to consider?

    Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of the reason that memory has been a constraint on scaling-up server capacity. Once you consider ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on August 14, 2007