I wrote articles on auditing and logging, including a lot of options. They're here: http://www.sqlservercentral.com/articles/Auditing/63247/ and (part 2) http://www.sqlservercentral.com/articles/Auditing/63248/.

The discussions include a lot of good data on the subject.

Have...

Jack Corbett (12/17/2010)

---

I've used VirtualPC, but its lack of 64 bit guest support is annoying. I know several others who use VritualBox and if I had a machine on...

select destemail + ';'

from [dbo].[DESTINATARIO]

where tmailid = 11

for xml path('');

The only thing I can think of, besides getting the author to change the code, would be to use a resource throttle on it. That's only available in Enterprise,...

You would need to generate either a real or virtual table of valid combinations, and join to that.

If, for example, "1,2,null" is valid, you need a row in your "valid...

Do you prefer this test?

SET NOCOUNT ON;

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP TABLE #T;

IF OBJECT_ID(N'tempdb..#T2') IS NOT NULL

...

The XML tools are what I see used the least where they could be used more. Both XQuery and For XML have a myriad of uses and improvements over...

vinothraj (12/17/2010)

---

I'm working in linked server but you might be working in your own. i just told it based upon the average of ten times but i would like to...

When you say "assign", are you selecting something, or updating a table?

Also, are the "trade lanes" stored somewhere, or are you constructing them from string snippets in the columns of...

I think I'd need to know more about the business rules and the data being modeled before I could suggest more on either design or coding against it.

For one thing,...

So, basically, we've concluded that there are three ways to get this done:

The Ceiling way, which does it easily, simply, correctly, and efficiently

A wide number of Round ways which all...

CirquedeSQLeil (12/16/2010)

---

Paul White NZ (12/16/2010)

---

I just typed this successfully in 2008 SSMS with Intellisense on (which it always is):

SELECT...

WayneS (12/16/2010)

---

What are your preferences for VM machines - VMWare or VirtualPC?

I've been using VMWare for years (and am happy with it), but to install a 64-bit Windows 7 and...

Jack Corbett (12/16/2010)

---

GSquared (12/16/2010)

---

I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help,...

CirquedeSQLeil (12/16/2010)

---

GSquared (12/16/2010)

---

I like the Red Gate intellisense more than the SSMS default, but I have to admit, they both get in the way as often as they help, till...