You could also use UPDATE (restrictedColumn) this returns true or false for a particular column.

Andras

You could also look at COLUMNS_UPDATED ( )

http://technet.microsoft.com/en-us/library/ms186329.aspx

Andras

You can access the old and new values via the inserted and deleted tables. I assume you also have a PK column, so if you join these two tables on...

There are third party tools to do that (i.e. script the whole database to a set of script files, and allow you play...

You can create a synonym only to stored procedures, extended stored procedures, functions, views, and tables (plus their variants). A linked server is not in this

About the free trial I cannot say much. I have not seen one, and we are using MSDN.

About better source control systems I have more to say. Personally I think...

Alternatively, just do not care about column order at all. Access them by column name. And forget "select *"

Regards,

Andras

You could use a query with Row_Number like:

SELECT  a
FROM    ( SELECT    ROW_NUMBER() OVER ( ORDER BY a ) AS RowNr
   ...

Well, the short answer is: create table, insert into.

This is exactly what SQL Server is doing when you use the method you mention. SQL Server will most likely waste space....

For db health check have a look at "dbcc checkdb" (not GUI, but T-SQL). http://msdn2.microsoft.com/en-us/library/aa258278(SQL.80).aspx

it does not go through the error log, but writes there too if there...

Try running DBCC UPDATEUSAGE

before.

sp_spaceused depends on up to date statistics

Regards,

Andras

You are right Noel. I mentioned it in the other thread, it is 'Ad Hoc Distributed Queries' that you need to enable, which may not be allowed/you may not want...

It seems to read full pages, so it includes everything on those pages. I've created a small table with 10000 rows, all of them tiny (so about max 600 can...

If you specify TABLESAMPLE(50000 ROWS) it will first convert this to a percentage based on the estimate of the table size, and then sample the table. The tablesample is also...

Null means that SQL Server is using the default value. It is 6, as Gail said. What I do not understand is how his post got there