This is assuming that's a full database backup you have there.

Open object explorer (F8), connect to your server.

Expand out the server until you see the folder Databases.

Right click -> restore...

Depends how fast your indexes get fragmented.

I've got a job that does a contig check on each table each week and records the results. It then will go and rebuild...

A proc has to be executed to appear in the procedure cache. Some of the things that can cause plans to be removed:

service restart (obviously)

sp_configure (some options when changed)

Alter Database...

I'm guessing the sysdate has a time with it? Datetimes always have a time portion that must be taken into account when comparing

You've got 2 options.

You can use a function...

Anything sharing a server with SQL is not recommended.

Start with the RPC_Completed and Batch Completed events (under Stored procs and T-SQL respectivly)

Column - Text, cpu, reads, duration, start time,...

Look up CONVERT in Books Online. There should be an appropriate style for that.

The checkDBs that SQL runs on startup are not complete consistency checks of the entire database. I suspect it's just a check of the system objects.

DBID 2 is tempDB, but...

Is the application in question running on the SQL Server, or on another machine?

I would suggest profiler. Start a trace on the SQL Server and watch what the app's doing...

Hash matches happen in memory, unless the tash table gets too big. In that case, it spils to disk. It's called a hash bailout. There's an event in profiler that...

OOps. Sorry about that. That's what I get for answeringh over lunch without checking my syntax....

It works rather badly. There's a triangular join in there, with a correlated subquery. The combination will be hell for large rowcounts

Jeff wrote a nice article on the dangers of...

*sigh* Users... 😉

Suggest to him that he scripts the data structure out and then uses BCP to export non-sensitive data. He can then send you the scripts and the exported...

Not without using dynamic SQL.

The other option is that you can use one of the split functions that are in the script library here to split the string apart into...

That's what I understood from Conor's post. It's probably a very, very...

In a where clause, yes. As part of an IN, no. What are you trying to acheive?

Coalesce is used as follows:

WHERE SomeColumn = Coalesce(@Param1, @Param2, @Param3,0)

If @Param1 is not null,...