Viewing 15 posts - 3,496 through 3,510 (of 39,768 total)
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...
August 26, 2019 at 2:47 pm
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...
August 26, 2019 at 2:46 pm
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...
August 23, 2019 at 9:06 pm
Are you asking is there a reason not to re-used hardware? If so, no if it meets your needs for resources.
August 23, 2019 at 8:16 pm
Also, please show the results you expect, or some of them. Format this as plan code, using the code sample button in the toolbar.
August 23, 2019 at 8:14 pm
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...
August 23, 2019 at 5:51 pm
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...
August 22, 2019 at 10:05 pm
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...
August 22, 2019 at 5:40 pm
We do have a site search, which does limit to this domain for google. You can also limit by content type.
Is there something you were looking for?
August 22, 2019 at 2:34 pm
The main point of the article is that we should expect data to change and allow for this. Not just with database design, but with the ETL, NULL/defaults, and more....
August 22, 2019 at 12:38 am
Congrats, Steve! How'd you like Potsdam?
I have a lot of friends who went to Potsdam.
Just as long as she doesn't root for Clarkson hockey...! 😀
It's a neat town. We...
August 22, 2019 at 12:35 am
As I see it, there is nothing wrong with "immutable" natural keys. LastName + FirstName + MiddleName as a natural key? NEVER!!!!!
The one thing I'll say in defense of...
August 21, 2019 at 3:27 pm
This is one reason I dislike many natural keys as PKs.
I don't understand how this follows from the discussion.. First, there's not a whole lot of cases where there...
August 21, 2019 at 3:26 pm
If you are doing updates, then SSIS works great. If this is a full migration each time, there is the SQL Server Migration Assistant that works well. A number of...
August 21, 2019 at 3:21 pm
Viewing 15 posts - 3,496 through 3,510 (of 39,768 total)