I am in the same boat now...

We have a number of systems that are either:

- production-by-stealth (start as a PoC and then remain in a Dev environment while being forced...

I agree with [Robert Sterbal-482516] regarding being critical.

I received the email and wondered if PASS had thought to consider the possibility that being in a country on the other side...

Yes, definitely a practice that should not continue but it is something that I have seen continuously since getting into SQL Server (from DB2) back in about 2003.

It is not...

One of my many gripes is the thoroughly lazy vendors who write their installation processes to use only the SA account and won't change it regardless of how bad the...

Firstly: What a thoroughly EXCELLENT article.

If there is something I like, it is writing that makes you question your personal dogma... something that makes you become introspective and wonder if...

This article was very interesting for me from the angle that I am in a role which makes me the Technical Lead for database problem-solving as well as indicating where...

I started to write a comment and somehow managed to hit the tab key which blew it all away so now I have to start again. In this period...

My thoughts are that someone saying that to hire this person to do the job because others become dependent on her is a smoke-screen.  There is something else at play...

There are a lot of things that can contribute to whether you are successful at an interview or not.  Sometimes there is a better person who comes along - it...

OK, so it is about 4 years after this post but I have the same issue and none of the solutions worked - after numerous attempts.

I was down to pulling...

I quite like the idea of the create/rename solution as it makes sense do do it that way and the outage time is much less. Apart from the issue...

Yes, it would be pertinent to unload everything and reload it but the application itself has been doing a yo-yo during the last week and the bosses won't allow any...

I knew I would forget something pertinent to this.... 🙂

Table is going from roughly 11,000,000 rows down to about 2,500,000.

I'm not comparing char-with-char in the WHERE clause (which I picked...

I can empathise with the position that you are in as I've been in similar situations myself (not exactly the same though...) and most often I'm the other side of...