Yes

Since this is a 2008 forum, let's go with extended events or change data capture. Either of these will let you know who modified data. Triggers are incomplete and can...

Because the GUI is trying to assist you through the process. And if you haven't got the full backup, the restore is going to go south. It's only validating against...

Seriously considering dropping 2005 from my list of forums to monitor. Any driving reason why I shouldn't? I dropped 2000 a long time ago.

dt2 (9/17/2012)

---

I may of got a bit carried away too...sorry.

Yes it was in 2012. Simply a vanilla build 2008 R2 server, with vanilla sql 2012 instance.

I created a new database,...

SQLSACT (9/17/2012)

---

Grant Fritchey (9/17/2012)

---

SQLSACT (9/17/2012)

---

Grant Fritchey (9/14/2012)

---

Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can...

Not MSSQLSERVER(local). Just:

(local)

And not MSSQLSERVER.(local). Just:

.

You might also try:

yourmachinename\MSSQLSERVER

Please, I don't mean literally "yourmachinename" but rather, the name of your windows machine. Just trying to be more clear.

dt2 (9/17/2012)

---

How patronising!

I can reproduce this on a vanilla 2008 R2 server, with a vanilla SQL install.

Maybe you are just too good and i'm just a dummy, but what am...

Because you have to take an initial transaction log backup to begin that process. You're setting up log shipping. It requires you to have logs to ship. The log being...

Perry Whittle (9/17/2012)

---

Grant Fritchey (9/17/2012)

---

By the way, why bother with SQL Server clustering if we're just talking two VMs on the same virtual box. Clustering is meant as a mechanism...

rhythmk (9/17/2012)

---

Grant Fritchey (9/17/2012)

---

Thing is, those are two different queries. The IN statement can act to filter the results of ABC, but none of the columns from ABC1 are available...

yuvipoy (9/17/2012)

---

An inner join between two tables does a complete join, it checks for matches and returns rows. This means, if there are multiple matching rows in the second table,...

ISNULL and COALESCE on columns in the where clause are going to hurt performance. I still think your stats are off. I'm seeing estimated 4.5 million, actual 15,000. That's a...

SQLSACT (9/17/2012)

---

Grant Fritchey (9/14/2012)

---

Those are valid counters and will show how your system is behaving. They're the same counters you get from running Performance Monitor. You can also look at...

The SQL Server Books Online.