Check the logs. If you had six, you should have seven now. Cycling the error logs simply stops the logging in one log and starts it in the next, new...

Why on earth would you need more than 99 error logs? Actually, why would you need more than ten?

The thing I suggested would just show you if you had more...

Itzik Ben Gan from Solid Quality Mentors. He wrote the book, literally.

Cycle the error log:

EXEC sp_cycle_errorlog;

It's not like date fields where there are a lot of special functions. We just use decimal.

It depends (I love that answer). To me, this is a business definition. Strictly looking at data, as data, no, none of these columns help to define the Address object....

Absolutely true.

You also might want to look at having simply an Address table with a join table to associate addresses to contacts. That way when you get a married couple...

The first four of those columns you're talking about are there for auditing purposes and shouldn't have anything to do with relational integrity. The last column, the guid, I'm assuming...

Since you're not, in any way relating the data between these tables, an odd thing, you could do something like this:

SELECT 'TableA' AS TableName

,Cola AS FirstColumn

FROM dbo.TableA

UNION ALL

SELECT 'TableB' AS...

If you have to use dynamic sql, be sure to look up & understand sp_executesql as the preferred method of calling it rather than using exec 'somestring'

I'd have to go all the way to "stupid practices." If I was feeling kind, I might call it "ignorant practices." If I wasn't feeling kind, it'd be "f'ing stupid...

I find that I'm with the you need both an artificial key and a natural key camp. Usually, but not always, the artificial key is an identity. However, I also...

tymberwyld (2/10/2008)

---

Grant Fritchey (2/7/2008)

---

Nope. The one issue that we've had, and believe me the developers have howled, is that they can not simply add procedures (or drop them either). They...

Internal to SQL Server, they peform almost identically. The main difference is that OPENXML has to instantiate an XML parser that chews up a ton of memory outside of SQL...

In my opinion, this would not be a primary counter for checking performance. I'd use it once I've already identified range scans as an issue because of excessive waits or...