Don, doesnt normalized imply the chance of one to many...maybe dba's should prefer one to one relations? Or maybe you're living large!

Nice write up.

I've seen too many things fixed by a reboot not to give it a try when Im stumped!

On the customer side, there are a couple cases. The first is that you wanted to buy the item, knew about the discount, and then at checkout the price was...

I dont have immediate access to the snippet, but we used to use an Access module that would relink all the tables based on a provided database name - that...

Bursting is pretty common to advanced reporting systems (Cognos, Crystal), this seems interesting to move that to a more loosely coupled design.

I've never dug deep enough to know for sure. Might be interesting to dig, but given that a copy of the table works fine, I think it makes sense to...

Absolutely you can have old info still on the pages when you drop a column, it's one of the tricks SQL does to speed up table changes. For example, if...

No easy answers. Mostly it's about trust and credibility, takes forever to earn, about 5 mins to burn. I'll stereo type a bit and say that most IT people suffer...

Im spoiled, all my repl work has been inside a domain!

There are some options:

- SQL 2005 has a web option for merge you might look at

- You can use http://FTP...

Nice comments Kathi!

I dont do a lot of merge repl, but I know for sure that restarting a server using transactional with updating subscribers does not request a new range. Doesn't seem like...

Generally the REPL folder goes on the publisher/distributor, but it doesnt really matter as long as the drive has enough space for what you need to do and both servers...

Paul,

See my earlier reply too (about 2 back) but the biggest think I dont like about concatenated strings is that you have to always handle embededded sinqle quotes. Miss one...

These articles are from a ways back, Steve decided to re-run one of them - still relevant! Here are links to the others:

Connection Object:

http://www.sqlservercentral.com/columnists/awarren/introductiontotheadoconnectionobject.asp

Recordsets:

http://www.sqlservercentral.com/columnists/awarren/introductiontoadopart2recordsets.asp

Part 4 - http://www.sqlservercentral.com/columnists/awarren/introductiontoadopart4combiningitall.asp

I think its a bit Zen;-)

First, I hate the idea of storing empty strings in a database. Whether you convert them to null client side or server side, I think...