In SQL Server, you have an instance that contains control information, scheduling, logins, etc. and then you can have multiple databases inside the instance. The instance is at a higher...

AFAIK, Gail is correct. If the columns in the NC index are not changed with an update, that index is not touched. No reason to, as there's nothing to update.

How will you run it?

You could schedule it with SQL Agent, but the Agent would need to be able to access the folder.

It doesn't matter how you write a SQL...

We did something similar in a financial system by putting in data and fields that marked as "as of" a certain date. This allowed us to join tables together based...

In addition to Eugene's notes, you can use a CASE statement to change things around.

case

When x = 5 then 1

when x = 4 then 2

end

You can't use ms_foreachdb to insert a parameter into a query that's directly executed. You need to submit a query as a parameter.

Luis has shown you how this would work.

crussell-931424 (7/3/2013)

---

What I worry about is the data getting degraded, "accidentally" changed or whatever, as it moves from one location to another. For example, in your editorial I noticed a...

Whether you agree/believe with/in religion, GWaK does raise a good point that many people that go are very giving. They feel it to be a part of their religion. Is...

Eric M Russell (6/28/2013)

---

LOL! I do recall once, in the aftermath of a delete script gone wrong, querying the transaction log for a clue about what stop date/time to use...

Hope things are well.

I didn't write this because of religion or government.

I have spoken on this before, and I do think it's important. Being a part of some sort of non-profit or...

jasona.work (7/1/2013)

---

You know, reading the end result of this topic: http://www.sqlservercentral.com/Forums/Topic1468850-2799-1.aspx, I'm wondering why MS doesn't provide a pair of radio buttons in several different places...

Radio button 1 -> MB

Radio...

Thanks, glad you liked it.

Good idea, and definitely needed. I've asked for a few items to be added to search and they've been bumped on the list. We have a few things in progress,...

batgirl (6/28/2013)

---

This is my first year in the automotive industry. I must say that for the most part, I don't like being forced to take my vacation at specfic...