Perhaps more code samples would help

what code takes 3~4 minutes to run?

Take a look into CONTAINSTABLE or FREETEXTTABLE as well if you need to

Otherwise Full-Text should be very efficient on...

You can update 1 TABLE at a time, not more than 1 in an UPDATE statement

But for that table, you can update from 1-N columns

so Garadin's solution should work

Perhaps it's time to look into PIVOT function that's built for this purpose?

You can group by YEAR, PIVOT by months

Unless you are using Reporting Service, then just use a Matrix...

thasteve (10/8/2008)

---

if i understand your situation right you can accomplish this by using output http://msdn.microsoft.com/en-us/library/ms177564.aspx%5B/quote%5D

I almost forgot about this, and I just read 2 2008 books 🙁

@@IDENTITY or...

Kalen has a good article just recently

As I am working on my new SQL Server 2008 internals book, I am finding many test situations in which I need to create...

I don't see a quick elegant solution

CURSOR will be the quickest

PIVOT may be harder with UNKNOWN # of Cities/columns per row (may involve Dynamic SQL)

Can you put the Cities...

Did you use the SQL Server builtin Management -> Maintenance Plans -> Wizard?

or SSIS?

There is a "Maintenance Cleanup Task" you can check

The Maintenance Cleanup task removes files left over from...

Google

I have like 5 similar scripts now to do index rebuild/reorganize, and I get confused all the time

Take a look at Pinal's article

http://blog.sqlauthority.com/2008/03/04/sql-server-2005-a-simple-way-to-defragment-all-indexes-in-a-database-that-is-fragmented-above-a-declared-threshold/

http://blog.sqlauthority.com/?s=index+fragment

I know in newer versions (SQL 2008 for example), it'll assign minimum rights to whatever account you use for the Server (or Service)

but I think LOCAL SYSTEM account would work...

for 1GB size, I'd suggest BCP QUERYOUT to a .csv or .txt

then import as Excel (2007) if you really want

or How to Export Data to Microsoft Office Excel 2007 Using...

What are the errors?

Have you tried importing it as Excel 97/2003 .xls format (instead of 2007)?

Also this may provide some insights (to use MS Office 12 OLE engine instead of...

I know for SQL 2008, if you enable Execution Plan in SSMS, it'll show MISSING INDEX HINTS

Although the caveat is that the index is tuned, only for that particular...

Exactly my thoughts after reading that (= something I can actually use at work in practice)

Why this SQL Server DBA is learning power shell[/url]

is a good read

Personally, even if there is directly upgrade path (e.g. install on top of CTP6), I wouldn't risk it

We upgraded from RC0 to RTM by either

1. Uninstall RC0, re-install RTM on...