SQLSACT (9/20/2012)

---

Grant Fritchey (9/20/2012)

---

19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not parameterized queries or stored procedures?...

Brandie Tarvin (9/20/2012)

---

HowardW (9/20/2012)

---

Brandie Tarvin (9/19/2012)

---

Yep.

My...

I have built a document like this before. It was a mixed success. Those who I was able to get to use it, loved it, and it made a huge...

sqlguy-736318 (9/19/2012)

---

I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat...

Have you ever looked at the databases created by Microsoft?...

I'm not sure how SQL Server is going to deal with all those correlated queries. I'd love to see the execution plan for this. Can you get the actual execution...

It's not a problem that I've run into or heard about. Are the connections being made from up to date libraries? The appropriate version of ADO or whatever? That might...

19000 out of how many plans total? What kind of queries are being run against the system? I'm assuming these are not parameterized queries or stored procedures? If so, you...

Joy Smith San (9/19/2012)

---

..Something came up my mind this morning..

Suppose a transaction was started before the backup process starts, only one transaction for example.

Backup process back up the pages.. transaction...

Brandie Tarvin (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Brandie Tarvin (9/19/2012)

---

Lynn Pettis (9/19/2012)

---

Do you ever feel that no matter how many times you tell someone what the problem may be that they just aren't...

Lynn Pettis (9/19/2012)

---

Stefan Krzywicki (9/19/2012)

---

SQLRNNR (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4....

SQLSACT (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

SQLSACT (9/19/2012)

---

Grant Fritchey (9/18/2012)

---

Just remember that sys.dm_os_performance_counters is just querying against the Performance Monitor counters. They're as accurate or as inaccurate as anything else within Performance Monitor...

Brandie Tarvin (9/19/2012)

---

Grant Fritchey (9/19/2012)

---

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4. Shrink Db

5. Rebuild...

Nothing wrong with this maintenance plan. I mean, everything is covered:

1. Check DB Integrity

2. Back Up Db Full

3. Back up Db transaction log

4. Shrink Db

5. Rebuild index

6. Update statistics

7. Reorganize...

I don't know your structure, but on a guess, I'd assume that you're actually looking at denormalized data. Can't you normalize the structure and then import the information into that...