master model tempdb corrupt repair startup start crash crashed
SQL Server Backup, Integrity Check, Index and Statistics Maintenance
select single_pages_kb + multi_pages_kb + virtual_memory_committed_kb from sys.dm_os_memory_clerks where type = 'MEMORYCLERK_SQLCLR'
- The curse and blessings of dynamic SQL
- Arrays and Lists in SQL Server
- Dynamic Search Conditions
- How to share data between stored procedures
- Giving Permissions through Stored Procedures
- Build Your Own Index
- Error Handling in SQL 2005 and Later
- Connecting to MS SQL Server from Unix
Szükséges al-sp-k:
http://support.microsoft.com/kb/246133
További módok (DTS, SSIS package)
http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx