Brandie Tarvin (9/16/2011)

---

Gianluca Sartori (9/16/2011)

---

WayneS (9/16/2011)

---

Question for those that blog (preferably with WordPress) and post code on their blog - what code syntax tool do you use? I'm using WP-SynHighlight,...

Do a search on the web site here. This question comes up all the time, There are a lot of discussions about it.

I'll suggest two books. First, Itzik Ben-Gan's Introduction...

I would assume performance for querying is going to start degrading, but honestly, I've never seen a system with 150,000 tables before, so I couldn't tell you when.

I suspect, really...

Erik Hansson (9/15/2011)

---

I have a server with 4 processors. Two instanses of SQL Server 2008 R2 is installed on the server. Now I want to dedicate two processors too one...

I'm at a bit of a loss here. Common and best practices are to split up tables, apply unique constraints, primary key constraints, foreign key constraints and build clustered indexes....

That's just a set of processes. There is lots of information there, but little data.

Personally, I don't like using that because it's so messy. Instead I run queries against the...

That's one of the tougher ones to set up. You need to capture statement level events. When capturing statement level events, you're going to get lots and lots of data....

Excellent stuff everyone, thanks. I especially liked the DTA & the Profiler GUI. Excellent stuff.

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

You combined Jeff & FLOAT. You're going to get the lecture now about the evils of the DECIMAL data type. I'm sorry, but you've brought this on...

mtillman-921105 (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the...

Changing the topic for a moment, I'd like to beg some ideas from the group, again.

I'm tasked with writing another article. This one is all about the scary, crazy stuff...

bobznkazoo (9/14/2011)

---

Grant Fritchey (9/14/2011)

---

That depends, do you know that the values are unique across systems? If not, you will hit problems.

Bigger question for me, why are you storing numbers in...

The syntax is simple, right?...

That depends, do you know that the values are unique across systems? If not, you will hit problems.

Bigger question for me, why are you storing numbers in a varchar field?

I'm with you. I think it makes a lot of sense. Especially when you consider how small this particular data set seemed to be. The one big issue for me...