SQLRNNR (1/19/2012)

---

The reports and application, are they custom reports for the application, are they SSRS reports read by the application, is it a different product entirely?

What you describe leads me...

Each time they call or email the first...

GilaMonster (1/19/2012)

---

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

And I strongly recommend you have a look at this: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

Re memory: If you tell SQL that it can use 24 GB, it will use 24 GB. If that's...

PaulB-TheOneAndOnly (1/19/2012)

---

Lets be clear... Does the very same query, with the very same predicate, with the very same filtering/access parameters, against the very same database/set-of-tables sometimes returns in seconds and...

Yes, I will work with one of their application users to check for missing / partial data. Thanks again for all your help and advice. This has been quite the...

IT WORKED!!!! DBCC came back with only 1 inconsistancy and fixed 1 inconsistancy. It also told me the table where to find it in. I selected the audit table and...

select percent_complete from sys.dm_exec_requests

shows it's 56.85% complete

Ok after shutting down the SQL service and trying to copy the MDF file out I will still not able to b/c the database is still attached. So to get...

When running DBCC CHECKDB (emergencydemo, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS;

is there a way to see what tables were lost or at least some information on what happend...

Also, out of curiousity if we...

At first I was pretty nervous but i'm settled down now and view it as more of a challenge at this point. Plus i'd really like to come through for...

GilaMonster (12/29/2011)

---

Vertigo44 (12/29/2011)

---

Is there a way for me to tell if the database was cleanly shutdown or not? I know that the state is 'RECOVERY PENDING' since the LDF file...

This was a server that one of our customers purchased and never told us about until a week ago. It was not even located in our datacenter. They are just...

Is there a way for me to tell if the database was cleanly shutdown or not? I know that the state is 'RECOVERY PENDING' since the LDF file is missing.

I...

Bad news guys!

Well after having a closer look the .BAK files and the .TRN files we thought we had are in fact a year old. Now, what I am wondering...

I found out that since the LDF file was in use during the TSM backup, the (.LDF) file was skipped. This means no recovery to point of failure. However, I...