True. I should read more carefully.

Use a datetime. Format is a function of how you retrieve the data, not how you store it.

Look up Convert for a list of the formating options for datetimes.

Could you add a TOP 1?

SELECT TOP 1 f.forumid, forumname

FROM Forums f

LEFT JOIN Threads t ON f.forum_id=t.forum_id

LEFT JOIN (SELECT forum_id, MAX(postdate) as last_postdate FROM Threads GROUP By...

Despite its name, the timestamp datatype has nothing to do with times. It's a binary rowversion.

It you're wanting to store the date that the rows was inserted, then you need...

In SQL 2005's profiler's create trace dialog, on the second tab (event selection) there's a button at the bottom 'Column Filters' That will let you set whatever filters you like.

You...

The name that you get from sysindexes.

No need to do anything with any logs if you're emptying data files

Books Online...

Since they are the same filegroup, you probably need to run the DBCC SHRINKFILE with the EMPTYFILE option.

EMPTYFILE migrates all data from the specified file to other files in...

It's not possible of SQL 2000. To use profiler, you must have sysadmin rights

Probably not with SSIS.

Are there different filegroups, or are all the files part of the same filegroup?

Import the trace into a DB table, then query it for any rows where TextData Like '%alter%' and TextData Like '%database%'

It may take a while, but it'll be faster than...

Please can you post the table structure, some sample data and the expected results. It makes it much easier for us to answer your question.

Ref: http://www.sqlservercentral.com/articles/Best+Practices/61537/

Thanks

😀 I'm gonna be thinking of Star Wars every time I look at SQL 2008 now.

I foresee a while new set of abuses of query hints coming up soon.

I should have thought of that earlier.

Those aren't indexes. They're automatically created column statistics. The query optimiser creates those to better know the data distribution within a column.

You can drop...

I know you haven't created any inde3xes. I'm trying to identify what the entries in sysindexes are and how they got there.

Please run the following query and post the results...