webmaster@sqlservercentral.com

I'm not sure what you mean by embedded here. Is it your deployment?

SQL Server licensing is the same, AFAIK, for any application. SQL Server licenses by CAL or processor, though...

Are you going to default the old rows of data to some value in the new columns?

DBCC MEMORYSTATUS will show you a number of clerks that are in use. Do you have columnstore or MOT tables? Those use memory outside the buffer pool.

Not quite sure what you're doing here. Perhaps you can explain a bit more about the problems you're having and what you want to achieve. Haven't used log4net, but I...

I struggle with this myself as well. When I'm in a hurry, tired, or busy, I tend to lean on experience. It's hard to know how often to try something...

Nice, glad you got to meet. I hope to go to Providence at some point.

Send a note to the webmaster with this request and your email. Likely at some point your email server started refusing the messages and they bounced a few times, at...

If you're trying to do this incrementally, then you need some way to determine what data has changed. SSIS is likely the best choice here as you need to do...

Nope, I see people replacing hardware as needed these days. Sometimes they work on a lease arrangement (3-5 years), sometimes they keep it around if it meets the workload.

No reason...

Are you asking is there a reason not to re-used hardware? If so, no if it meets your needs for resources.

Also, please show the results you expect, or some of them. Format this as plan code, using the code sample button in the toolbar.

I assume this is because you might be doing some refactoring, and perhaps want to point a routine to the specific place while you're using a temp table in place...

crowdsourcing is on the list. We allow tags (now) in the forums, which helps. Content needs more tags, though we had issues allowing random tags on the old site. Need...

Hmmm, keyword searches are definitely hard, and I wish we had something more layered. There are tags for sure that can help, but organizing to get all of xxx is...