Of course a postal code field should be nvarchar(4000)! You never know what the future holds.

I've been buying my own laptops for the past 15 years. The model I will buy is always better than what an employer will get for me. I favor Lenovo...

Just stop.

You wrote:

"Indeed you're not reading it write if you think that's what it says (it doesn't say that)."

And I asked if I read it write or right. You...

Am I reading it write or right?

Vila Restal (7/12/2013)

---

And I maintain my point: A DBA needs to be reliable but behind the scenes. The customer (the audience) shouldn't know they're there because the only time they...

Sometimes people show their flaws early on and sometimes they develop over time. I've worked with plenty of people that have turned in to real jerks over a lengthy period...

I'll check it out. Right now I'm thinking of a different method but I really don't want to close the door to other and possibly better options.

philcart (7/6/2011)

---

Firstly, I'd ask what is behind the requirement to run the subscription using T-SQL? That really defeats the purpose of setting up the subscription in the first place. When...

I found the cause. If anyone cares the issue is related to truncate vs. delete. I have a table (not a temp or variable) that has constraints, indexes, catalog, etc...

Maybe Windows 95 was a good name for a product at the time but other than that I'm no fan of using a year as part of a name. As...

Another major plus is if someone makes a mistake and alters or deletes something it may be possible to scrape out what I need from the DR site (assuming they...

Careful with those alerts! If you have a slower connection to your DR site or if maintenance causes larger than normal T log backup file size you will get alerts...

Yes, congrats on that. It is a very big deal indeed!

I wrote my own log shipping routines right down to duplicating the monitor report. I thought it was slick and it all worked very well but all I did was...

I don't update things simply because there is an update available and we usually plan changes in advance as the servers are 24/7 so taking one down involves a lot...