There are a few ways to accomplish this. Here are some examples...

Example 1

Declare @Table Table (id int, animals varchar(10))

Insert Into @Table

Select 10, 'cow' UNION ALL

Select 10, 'chicken' UNION ALL

Select...

I have used trigger files for things like this in the past. Not sure if it is the best way, but it works. You can run your job (say...

It doesnt look like that feature got carried forward. I ran a trace with profiler to get the script and the same script seems to work in 2008. ...

If you want to see the reserved disk space and the unallocated space you can use the sp_spaceused stored procedure.

You cannot backup the tempdb. It gets recreated every time SQL Server is restarted.

You can use the following stored procedures in the msdb database to get job information.

sp_help_job

sp_help_jobhistory

sp_help_jobschedule

sp_help_jobstep

If the job runs over the start time, it will miss the schedule for the next day. I have seen this behavior for transaction log backups. Let's say you...

Yep. ...

You can find the text in the syscomments table. You can search for your specific table name in the text column.

Select *

from sysobjects A

JOIN syscomments B

On...

Not necessarily. You just need to put whatever measures in place that make you feel comfortable...

Jack is right. I played around with this a little last night. The xquery is just parsing the xml plan looking for an index scan. You probably...

By default SQL Server creates a clustered index on the primary key.

If your database is on the same server, you just need to specify the database name in the query. The syntax below assumes that the table is in the...

You have to convert one of the columns... Try this.

select ceiling(5/2.0)

You may need to use round depending on your requirements. For example, ceiling will always round up.

select Ceiling(2.1), ROUND(2.1,0)

Ok. I played around with it a little more. Try this one.

Select DISTINCT b.rowcnt, A.*

FROM INFORMATION_SCHEMA.TABLES A

JOIN sysindexes B on OBJECT_ID(TABLE_SCHEMA + '.' + TABLE_NAME) = B.id