Browse by Tags

• 32 bit
• 64 bit
• access
• catalog
• grant
• Hardware
• information schema
• memory
• performance
• permission
• server
• SQL Server
• tsql
• windows
• x64

• 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 Read More... Posted Friday, August 17, 2007 8:45 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, tsql, access, system, permission, grant

• TSQL methods to display the owner of schema in a database.

  You can use 2 methods to get information about owner of a particular schema or set of schema(s) within the database. Using INFORMATION_SCHEMA views method (which I prefer most of the times): USE <DBName> GO SELECT * FROM INFORMATION_SCHEMA.SCHEMATA Read More... Posted Wednesday, August 15, 2007 7:23 PM from SSQA.net | (Comments Off) Filed under: tsql, system, information schema, catalog

• 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 Read More... Posted Tuesday, August 14, 2007 11:16 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, x64, memory, server, windows, 32 bit, system, 64 bit