It depends on what OS I'm working on.  If I'm on Windows, I use SSMS, and if on MacOS, I use ADS, as I am likely using that IDE for...

Like you, I do tend to stay with SSMS, just because I am used to it.  But I find myself using SOS more, probably about 50-50 right now.  Since I...

My two favorites:

1. Worked at one client where they stored Guid's in image datatype. At least they understood Guids are binary and not text, but still had to...

Its' interesting that those that have posted here so far are of the view on what the software company should do for me. I read Steve's article and took...

Just curious as to why residents of Tennessee, Wyoming, Northern Ireland and Quebec are not eligible?

https://www.dbainspace.com/about/dbainspace

ELIGIBILITY CRITERIA

...Only residents of the USA*, UK*, Canada*, Australia, or Germany can win the...

I have done both, with no noticeable problem either way. If it were a dedicated DB server, and running an older server OS, I would consider wiping it and...

rwilkes; Depending on the versions, it can be that simple. When the databases from the previous version are attached, SQL Server will upgrade the databases to the current...

I would suggest following Chloe's suggestion, but not necessarily with DTS/SSIS. I suspect that restructuring your query to get all of ServerB info first, then perform the join may...

I second Ed Vassie's question on the supposed JCL limitation.

I got the answer right, only because the category was SSIS and I figured that one of those two answers must...

Shoot! I had the identity increment right, but forgot about truncate table resetting the seed value.

As a consultant working at many different sites and scenarios, I often have to use what is given to me. However, if I have the choice and/or option to...

There are only 2 absolutes:

1. Vodka

2. There are no other absolutes

I have to admit to being surprised at some of the new stuff that is not in Standard edition, but I do believe that SQL Server 2008 does provide compelling...

I would let Eric stay. By Evelyn's report, he is doing a job that no one else can or wants to do. He may not be a leader...

BobAtDBS (8/12/2008)

---

Seldom is the answer "never do it this way". It often "depends". ...

Every time I read someone saying "never store blobs in the server" I wonder how...