I agree with Todd - it would be a lot easier to identify things if the MAC address looked like what is getting broadcast on the network, wouldn't it?

Jasmine D. Adamson (4/1/2008)

---

I think I was connected to a wrong version of SQL Server. It was saying syntax error near '('...

You could easily give the PK a name... the...

SQLZ (4/3/2008)

---

JohnG (4/3/2008)

---

I got caught with this in a trigger referencing the deleted table. It was a syntax error that SQL Server should have caught and thrown an error....

SQLZ (4/3/2008)

---

Here's another good reason why not to use IN:

Run this on the AdventureWorks database in SQL 2005:

begin tran

delete Sales.SalesOrderDetail where SalesOrderId in (select SalesOrderId from Doctor)

rollback tran

Whoops! You've...

Have your hardware folks taken a look?

Did they start sharing any of the SQL LUN's with other applications? How's the IO looking on the SAN?

We had something...

Did you actually check whether the error message you're getting is accurate? Meaning - some of the column names are duplicated or missing?

Also - since you're exporting to DBF,...

I think your colleague is onto something. WMI is designed for this kind of stuff (remotely querying and possibly modifying settings, using WQL). Of course - I have...

Angela S. (3/31/2008)

---

OK I may have gotten the master copied over, not sure. Another question I do have. In my databases that run through the ODBC on the...

Maybe I'm not thinking of this right, but - why? The purpose of the web services is to allow for exposing specific things, so why would you introduce extra...

Marios Philippopoulos (4/2/2008)

---

Thanks Matt.

Here is another interesting test from http://microsoft.apress.com/asptodayarchive/74019/sql-clr-best-practices:

Comparing Performance

Gert now presented some performance comparisons. He took two custom UDFs, one of which summed over a long series of...

That's an entirely different issue. You're dealing with a ragged file.

Don't go custom. The data you gave me fits through a derived column calculation (as long as you...

I'd respond...

Just for giggles - I just set a quick one up. If I click on the "keep nulls" in the final transform (to the SQL table), it keeps nulls...

Guts N Glory (4/2/2008)

---

It is something that my company is considering too. Is it true that we need 2 license of SQL Server 2005 to do this setup (one for...

Put a conditional split in there. If you use the conditional split - you can set up different rules as to what should happen when that column is null...