MMartin1 (3/2/2016)

---

Without the try_convert function built in, I just did a simple

select convert(varchar(1), 234523); and got back the asterisk. What the meaning was when deciding to do this, I...

I am sorry to say that you are absoltuely right on that.

It's your choice obviously, but I will comment on some of your...

"First" by which criterium?

The word "first" only has a meaning if...

Sean Lange (3/3/2016)

---

Shall I repeat the concrete example yet again? You have a column in step 3 that is required. That column cannot be made NOT NULL in the design...

I see a lot of discussion about whether or not there are normalization errors in the design you posted. There might or might not be, but that's something only you...

I've never heard of sp_sqlagent_refresh_job. There are a few hits on Google which I'll leave to you to investigate.

If it's a system stored procedure, you can usually still look at...

Not sure what you mean with that question,

If you want to know how to learn how to come up with a good design, then google...

Hi Talvin,

Sounds like you already have most of the algorithm figured out. After step 3 (in my previous post), check if you have hit the limit. If you have, fine....

I do...

There are lots of those tools available. I do not recommend any of them, for the reasons specified in my previous post.

But if you want to use them, google to...

Wedding

If you decide to use SSIS (and note that some important remarks about this have been made...

Precious

Not as far as I know.

However, when you work in SSMS you can drag theh "columns" entry from object explorer on the SSMS query window, and it will drop a...

Enabling (or disabling) service broker requires an exclusive lock on the database, unfortunately. (In my opinion a major flaw in the design).

You will have to ask everyone to disconnect their...