Yeah, it can work. But you have to use SQL logins as well as expose the server through the firewall. From a security standpoint, I don't like it. But is...

You could try going with a slightly different approach. Set up the views under a different schema and then grant the user SELECT access to that schema.

Have you look at locks and wait states to understand why it's doing this? You should be able to at least narrow down the problem.

App code or not (and I...

At your currrent skill level, what you can honestly charge, you should be looking at local non-profits, schools, that sort of thing. Then, as you build your skills, you can...

That's similar to what I've done in the past. I always try to find a task that I'd like to get done but don't have time to do because it's...

I'm not sure why someone would say that SCOM is not good for that type of job. In fact SCOM is pretty much designed around specifically that. It would be...

If you're looking to do versions of data, you might want to take a look at this article[/url] I wrote for Simple-Talk. Better still, take a look at the comments....

The share has to be accessible, but then you just use the UNC path for it:

RESTORE ... FROM DISK = '\\servername\sharename\filename'

Since the filename is likely to be different each and...

Based on how it works, no, I wouldn't recommend it. If you already have an artificial unique identifier on the table, why do you need a second one? Does the...

Is there more slack time over weekends or is it the same schedule? You could use that time for doing full backups and then do differentials during the week. It...

One of the problems with triggers is that they're difficult to control. Based on what you've just outlined, what about having two different processes for updating the data and one...

WayneS (3/27/2011)

---

Grant Fritchey (3/27/2011)

---

Jeff Moden (3/26/2011)

---

Koen Verbeeck (3/25/2011)

---

Maybe an article on why it is not necessary to maintain indexes. Who needs them right?

(but maybe again, someone picks this up not...

Jeff Moden (3/26/2011)

---

Koen Verbeeck (3/25/2011)

---

Maybe an article on why it is not necessary to maintain indexes. Who needs them right?

(but maybe again, someone picks this up not realizing it is...

Jeff Moden (3/24/2011)

---

Grant Fritchey (3/24/2011)

---

Jeff Moden (3/24/2011)

---

Oh, very cool... I just found out that one of my favorite novels is going to be made into a movie. "The Martian...

mtillman-921105 (3/24/2011)

---

Thanks again Grant, I will have to dig into this further when I have time. I'd like to understand why parameter sniffing wasn't an issue before, but...