The corrected version is here: http://www.sqlservercentral.com/Forums/Topic767556-9-1.aspx

Threads can't be deleted here except by a moderator. No worries, if it happens again, just edit the first post to be a link to...

Phil Factor (8/9/2009)

---

When I was working for a national UK bank, a while back, a passenger jet crashed within half a mile of our secure data center (placed outside the...

Depends where you are sitting in the world. Where I am, backing up into the cloud is just not an option, it's not security or risk, it's simple time, bandwidth...

An SLA is something that you need to get from your...

5-year old thread alert.

Also note that indexes that have not been used at all (no seeks, no scans, no lookups, no updates) will not appear in index_usage_stats. An index has to be used...

That only works if the database has been shut down cleanly. If it has...

It's possible, difficult, but possible.

Here's another very terse question. I think...

Bob Hovious (8/7/2009)

---

Thanks, Jack. I just tried to download it again and no luck. Sounds like a fun problem, maybe someone else can help...

Performance Monitor. Look for the Transactions/sec counter.

Profiler. Look for the RPC:Completed and T-SQL Batch Completed events.

jose (8/8/2009)

---

I think I would have detach and attach single file

EXEC sp_detach_db @dbname = 'pubs'

EXEC sp_attach_single_file_db @dbname = 'pubs',

@physname = 'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'

sp_attach_single_file_db attaches...

imSQrLy (8/7/2009)

---

I was just checking on the latest posts and noticed a ranking i haven't seen before of "Mr or Mrs. 500". I never paid too much attention to the...

Easier to understand if you switch them around.

In is looking for matching in a list of values. So a where clause predicate like this one

WHERE SomeColumn IN (1,2,3,4,5)

will...

That's SQLMag, not SSC. Thread topics drift here, Steve doesn't intervene unless there are personal insults flying around, which doesn't happen often. Sometimes they drift back on topic, sometimes they...

Charles Kincaid (8/7/2009)

---

Rats! Thanks. I had seen a number of articles and posts showing the lovely check box. :pinch: It would have been so nice to...