RonKyle (4/10/2015)

---

As a general rule, isn't the first one more suited to

SELECT ROLE_ID

WHERE PERSON_ID = ?

while the second is more suited to

SELECT *

WHERE PERSON_ID = ? AND ROLE_ID =...

I tried once to write a parser for MS Access SQL. After 3 months (and I was doing it...

Neither index is particularly useful for a query that filters only on RoleID, see the blog post I posted.

Again, without looking at the queries that run against a table,...

Depends on the queries being run against that table, impossible to answer without knowing the queries.

This may give some insight into indexes and queries

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

Yes, they need to be restored as the last step in the restore process.

Another option is to make the archive filegroup readonly before you take the backup, but then you...

Eirikur Eiriksson (4/10/2015)

---

Especially when it's pushed forward to the day of...

No. To start with, the FROM is optional

Valid (but that your replace won't pick up)

DELETE[MyTable];

DELETE

FROM

[MyTable];

And one it...

I love finding out that I'm giving a training course from the newsletter sent out the the entire company.

Taking filegroup backups and restoring them to a consistent point requires log backups so that the DB can be brought to a consistent point in time. It's so that any...

At the time SQL started and tried to open the file, it was being accessed by another process, probably a mis-configured antivirus. Hence it couldn't open the database.

OS error 32...

I'm not a DBA. 😉

Seems like I need to concentrate...

There won't be anything in the SQL error logs.

Timeouts are a client-side error. It's the application deciding that it has waited too long for the query to complete and aborting....

You want to add the columns as include in the nonclustered index to avoid lookups.

Bear in mind, lookups may be fine, it depends how many rows are affected by the...

Brandie Tarvin (4/8/2015)

---

The...

Sure thing. I'm leaving work in the next 30 min or so, bug me in the morning (your morning is fine) and I'll check them (they're behind Outlook, so I'll...