Search my blog
-
-
Recent Posts
- Reading list for the week – 24/10/11
- Reading list for the week – 17/10/11
- Reading list for the week – 10/10/11
- Reading list for the week – 03/10/11
- Reading list for the week – 26/09/11
- MSP Error: 29528 The setup has encountered an unexpected error while Setting reporting service exclusion path
- Reading list for the week – 19/09/11
Page Views
283,436-
Popular Posts
- How the Cannot generate SSPI context error was fixed
- Cannot create an instance of OLE DB provider ‘OraOLEDB.Oracle’ for linked server
- Find the SQL Server Instance name using Task Manager
- The CHECK_POLICY and CHECK_EXPIRATION options cannot be turned OFF when MUST_CHANGE is ON
- Script to check database user permissions
Archives
Tags
backup configure data corruption data file hardware hotfix index internals locks maintenance plan performance PradeepAdiga restore RLFTW scripts security services setup sql 2000 sql 2005 sql 2008 sql 2012 sql agent ssis system databases tips and tricks tools Top Posts trace transaction log troubleshoot windows
Tag Archives: index
Mr.DBA what is the status of Rebuild Index?
Within a few hours of my announcement of coming back to business yesterday, my cellphone started ringing. Call from Office on a Saturday evening could not mean nothing but an escalation call. Indeed it was one. The customer had some … Continue reading
Posted in scripts, SQLServerPedia Syndication
Tagged index, internals, maintenance plan, scripts, sql 2000, tips and tricks
3 Comments
Find tables with Large Obejct (LOB) data types in a database
From SQL Server 2005 onwards, the indexes can be re-indexed ONLINE. This ensures that the underlying tables and indexes are available for other users when the re-indexing is taking place. Also Standard and Workgroup editions of SQL The limitation for … Continue reading
Posted in Internals, scripts, SQLServerPedia Syndication
Tagged index, scripts, sql 2005, sql 2008
2 Comments
RSS
Email
Twitter
Ovi App
LinkedIn
FourSquare