Browse by Tags

• 1433
• backups
• busy
• cache
• create
• creation
• databases
• indexes
• microsoft
• monitoring
• online
• performance
• port
• security
• sql server
• tsql
• users

SQL Server 2005 Enterprise Edition - make data available while creating indexes on large tables!
25 January 08 02:41 AM | SQL Master | 3 Comments   

Though it is not a best practice to perform a CREATE INDEX on large tables during the online hours where you have number of users accessing the metadata of SQL Server database. Within SQL Server 2005 Enterprise Edition you can perform ONLINE indexes operation, Read More...

Filed under: performance, sql server, cache, indexes, tsql, users, best practice, backups, monitoring, operating system, creation, create, online, busy

Changing ports on production SQL Server - things to watch for 1433
07 December 07 11:29 AM | SQL Master | 2 Comments   

What is your criteria on assigning ports to SQL Server? Are you leaving them to default 1433? Is your SQL Server is exposed to Internet or any external sources where there is a chance to produce mass attach or run code injection? Every DBA should give Read More...

Filed under: sql server, microsoft, security, databases, best practice, 1433, operating system, port