30% is usually the rule of thumb (below 30%, you REORGANIZE or do nothing, above it you REINDEX)

Take a look at Books Online from Microsoft (sample script uses 30%)

DBCC INDEXDEFRAG

Defragments...

I am interested to know as well

Personally I think

Certifications like 70-431, 443, 444 for MCITP: DBA

and advanced books like

Inside T-SQL series

It's a never-ending road, sadly 🙁

I am in Canada, about to take my 70-431 soon too (should've done it a year ago)

but now a year later, I have learned a lot more that's beyond the...

SQL Server installation includes

SSDE (Database engine)

SSIS

SSRS

SSAS

so yes, it's part of the install

If you see "Reporting Service Configuration Manager" in Start Menu, it should mean that SSRS is installed

check your "Configuration...

Thanks for the code

I think you missed the @DBName declaration at the top

Declare @sqlstmt varchar(5000);

declare @DBName sysname;

set @DBName = DB_NAME()

set @sqlstmt = 'use ['+@DBName+']' + char(10)

Even Full-Text may not be 100% to your request, but it's a start

You can assign weights to terms/words, but not the columns (which I hate)

Maybe take a look at this...

LiteSpeed Rapid Access to Backups: Save Time with Object Level Recovery

Backup and recovery activities divert expert resources from high-gain IT initiatives to role processes. Using LiteSpeed for SQL Server, you...

martincjones (11/27/2008)

---

Just like to say thanks to the posters on this thread and the advice of checking that all the jobs ran successfully. As a result I managed to solve...

I find that SSIS 2008 has improved much better

I had issues/errors involving truncation and unicode (despite nothing was in unicode column nor data) from Access 2003 to SQL Server

2008 automatically...

You should use GROUP in the Table/Matrix, that's what it's created for

Then you can just leave the Group Footer blank to have your blank row

Tough to guess without knowing too much

But it could depend on the workload at the job execution time, the fragmentation of the indexes, blocking processes...

Are these OFFLINE re-indexes? are they...

It's typical for a discussion forum

I just subscribe to a thread with no email notification for a favorite

For articles, I use the "Briefcase" feature

Thanks for the help Gail

Yeah, "fortunately" we are moving away from this server (it's being migrated)

Otherwise I don't know how easy it is to convince others to go on a...

I know about the Broadcom Gigabit NIC driver, and it's updated as well (I'll re-check it)

We have

2 Broadcom BCM5708C NetXtreme II GigE NIC

2 Intel PRO/1000 PT Dual Port

and this...

Mnn, if you assign the users appropriate limited permissions

Won't they just use the same SSMS interface, just with less options?

They don't see everything a sysadmin would see

Beyond that, either write...