2008 Index Fragmentation Maintenance
Just a stab at automating index maintainenance in SQL Server 2008
2013-01-11 (first published: 2008-11-07)
2,573 reads
Defragment
Checking fragmented indexes
A quick script to check for fragmentation in a database and generate a list of defrag statments you can run.
2008-09-24
2,406 reads
RE: Retrieving DB from .mdf and .ldf
By rebuilding the master, you can set the appropriate permissions to allow you to attach the databases. Unfortunately you will also need to recreate anything else stored in the master. Logins (both NT and SQL) would need to be recreated, and sometimes there are issues with recreating SQL Logins. Since it sounds like you are […]
2003-06-05
1 reads
RE: SQL occupied 90% usage and 99% outgoing traffic
Keep in mind that there's a hotfix to repair a memory leak and it came with the old netlib files. Some people who had been patched got unpatched when they installed the memory leak hotfix. That was one of the lessons learned. Of course, that memory hotfix was pre-SP3, though. K. Brian Kelley http://www.truthsolutions.com/ Author: […]
2003-06-05
RE: SQL occupied 90% usage and 99% outgoing traffic
I have run the sqldiag.exe. It shows the last three log files are unable to open. Meanwhile, What kind of command should I use to capture the command? Many thanks!
2003-06-04
RE: SQL Server Statistics
Don't know abt dropping all the STATS, but you can definitely update the stats for all the tables with UPDATE STATS. (It drops and re-creates the STATS) Here is the script to update STATS for all Tables in the DB DECLARE @tablename varchar(30) DECLARE @tablename_header varchar(75) DECLARE tnames_cursor CURSOR FOR SELECT name FROM sysobjects WHERE […]
2003-06-02
Blogs
Enabling an Index: #SQLNewBlogger
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers