And this post makes 10,000 points. On to getting 10,000 posts.

Figured I'd break the threshold on The Thread.

It really depends on what the needs of the project are. I tend to shy away from denormalization as a plan. I usually plan on normalizing with a standard design,...

Further, employers will do internet searches based on your name. They can find this thread and will certainly be less inclined to hire someone as a trusted database manager who...

I would strongly suggest you take a look at SQL Compare[/url] from Red Gate (yes, I work for them). But, you need to know, while SQL Compare works wonders, it's...

I'm with Lutz. I think you'd be better off using an Identity column, even make that the primary key, and then have a calculated column or just put it into...

I write a lot more TSQL than I click on the GUI. I mainly use the object explorer window to keep track of all the tables & columns, but other...

nico van niekerk (2/20/2011)

---

I agree, but I don't think that there is more data to move. If a varchar(255) contains only 10 characters, say, it will only be 10+2 that...

There are a lot ways you can go about working with developers on databases in a team environment. You'll have to figure out what works best for you. The one...

WayneS (2/20/2011)

---

For those going to SQL Saturday #69 in Philly, I'll be presenting @ 2:15. I'm getting pretty excited about this!

Click here for the schedule

@Grant, Steve, Jeff - any chance...

Hard to say, I don't know your systems or the volumes involved. I would only split to another database if I thought the load required it.

To connect to that, you have to supply the machine name as well as the instance name. MachineName\SQLServer from what you showed ought to do the trick. I suspect you're...

I suspect everyone has their own best practice. I only break down schemas into either discrete security areas, where I'm going to treat some tables differently than others for security,...

Just a side note, if your reindex jobs don't finish and you stop them, isn't the problem just going to spiral? Won't every night it get, maybe, just a little...

That's the right approach, if, your client and their business model just wants the historical aggregation information. If they want more, as you say, you're stuck. I can't tell you...

Best advice I can give you is to read the documentation so you know what you're doing. It's available online here.

Do the standalone install. By and large if you accept...