I would change the SFound thing to an If Exists or If Not Exists. It should, however, work as written, and this is a minor change and not critical.

The...

This sounds like a test question to me. Or an interview question. Do you have a specific situation you are trying to resolve?

Jeremy Brown (8/6/2008)

---

Sure you can! Put a clustered index on the table.

Ok, I know...

Per Books Online:

It's under "SET STATISTICS IO".

Well, you'd have to select a list of tables, and their rows, then create a dynamic export script to create the files and export to them.

I don't think it's a...

What kind of connection are you trying to establish? What application? Are you on the other side of a firewall from the server?

Since I'm over 30, and "learned me some SQL" from someone over 30, I guess you should disregard anything I have to say on this, but here goes:

Spend time on...

You can either use exec(@qrystr) or use sp_executesql. Tend towards sp_executesql, since it at least slightly reduces the dangers of dynamic SQL (which is what this is).

I'm going to hazard a guess that either one of the servers has the wrong date on it, or someone set the calendar ahead one day to test something (or...

Jeff Moden (8/6/2008)

---

From the description of things, it sounds like you have some code somewhere that makes tomorrow's database today... maybe, in more than one spot. I'm thinking that...

declare @DHire datetime

select @dhire = '6/2/2008'

select

case

when datepart(day, @dhire+30) = 1 then @dhire + 30

else dateadd(day, -1 * datepart(day, @dhire+30), dateadd(month, 1, @dhire+30))+1

end

Test it with a few dates. Should...

cast(replace('2007/01/01', '/', '') as int)

If you cast/convert a datetime value to Int, you'll end up with the number of days since 1/1/1900, not the format you're looking for. The...

It's a service. Right click "My Computer" or "Computer" (depending on your server version), select Manage, go to Services, make sure it's running and is set to start using...

Both turned on, and scheduled maintenance plans to update stats periodically and rebuild certain indexes.

Start by running DBCC CHECKDB on the database.