Sorry, Jeff. I just don't see it. As far as I can tell it's the same as it ever was. The technology may change, but people are...

Lynn Pettis (3/9/2009)We know that they aren't willing to pay. That is why they are contacting us via SSC. Hey, it's free help, let's try them. I...

Actually, in D&D they do, St. Cuthbert being the "cannonical" example.

😀

K. Brian Kelley (3/9/2009)

---

RBarryYoung (3/9/2009)

---

Great article, Brian. Is the Client_Host ip information still available about a session later on, or would I need to store it from a Logon...

Brandie Tarvin (3/9/2009)

---

Case statements. You do a "CASE MyStatus When 'A' Then 1 When 'C' Then 0 When 'Z' Then 0 End as StatusCount".

You HAVE to group by MyStatus even...

Right, Brandie. I should have also mentioned that that Registered Servers serves as a kind of shortcut-linking facility so that you do not have to type in the server's...

SQL Guy (3/9/2009)

---

I need to create (or alter ) a stored procedure to be placed in a non-primary file-group. The reason for this is our database is periodically restored from...

OK, that's true, Brandie. But the solution isn't to add DISTINCT like this:

Select DISTINCT a.StoreID, a.DistrictNumber, b.ProductNumber

from TableA a

join TableB b

on a.StoreID = b.StoreID

Group By a.StoreID, a.DistrictNumber, b.ProductNumber, b.Quantity

Which...

Great article, Brian. Is the Client_Host ip information still available about a session later on, or would I need to store it from a Logon Trigger like yours if...

Show it where?

There's nothing wrong with Views. It's how you use them that matters.

The solution that I usually implement when I have a customer or situation that demands this ability (which is to emulate transportable-tablespaces from Oracle) is to actually put the stored...

What is the configuration of the server that this is running on?

How much space does this 150 million rows occupy?

What is the disk configuration of the source DB's, TargetDB, and...

AFAIK, there is no built-in way to do this.

You might be able to do it with the VS-IDE Add-In trick, but that would involve some serious programming.

Ah, mystery solved. Here's an explanation from the site http://www.16-9.dk/2007-02/side11_inenglish.htm:

Soon after the opening credits of Annie Hall (1977), Woody Allen tells the "Resignation Joke" while facing the camera (fig.2),...