Alen Teplitsky


Alter Index with online rebuild - SQL 2005

This is an Alter Index script i made up from the one found in BOL and some other scripts we had. You need to create a table to hold the fragmentation data and it has a date column so you can track historical data. You can also add a db_mail part at the end to […]

5 (1)

2007-08-10 (first published: )

2,112 reads

Blogs

Book Review: Lights Out

By

I have always been interested in GE since I was a kid. My best...

A Successful Blogger on Making the Switch

By

For Kyla Marie Charles, switching to WordPress.com opened up possibilities for her website and...

Login Timeouts

By

I was recently approached at work about a company that was seeing tons of...

Read the latest Blogs

Forums

SQL Server internal variable with DML type

By sergino.taglia

Can you advice how to retrieve the DML type a query is running? Does...

How to Convert Oracle SQL to T-SQL

By carlton 84646

Hello Community, I have been given a challenge of converting the following SQL code...

Right place for newly graduates?

By LeviHampton

Hi everyone, I have a brother who just graduated with a programming major. And...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers