Is it essential that the table be available for users during this bulk load operation, and is the table partitioned?

ChrisM@Work (9/13/2016)

---

Eric M Russell (9/12/2016)

---

4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will need to remain...

The NSA is going to poop their pants if Gary Johnson is elected as the next US president.

Ralph Kimball has said everything there is to say, past and future, about accumulating snapshot fact tables. All the wisdom is enshrined in his website and books.

http://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/accumulating-snapshot-fact-table/

http://www.kimballgroup.com/2014/06/design-tip-167-complementary-fact-table-types/

All forum discussions boil down to a debate over clustering keys. 🙂

DML operations (INSERT, UPDATE, DELETE, and MERGE statements) hold an active transaction until the operation completes. When you have a DML operation that combines a complex SELECT with JOINs, then...

How was your high CPU utilization related to the network?

David.Poole (9/12/2016)

---

I get a bit frustrated with the latest fanboy shiny ball that seems like the previous shiny ball with 10% of the features fixed and 10% of what worked...

If someone were to choose only one programming language with which to learn and stay updated, I'd suggest SQL. Not only does most every corporate IT project require a SQL...

4 million rows is actually not a lot, but it depends on the speed of your storage system and whether the table will need to remain online and usable while...

Even when a VCS has been installed within the organization, I guess some teams are reluctant to checkin code, because they are not sure where exactly where to checkin or...

If a resume that is nothing but a boiler plate cover, a list of past employers and schools I've never heard of, and a tag cloud of unsubstantiated skills, then...

That's why...

I'm not sure if this approach would be flexible enough for your needs, but it would leverage some built in features of SQL Server, rather than attempting to code your...

Maybe somtimes veteran forum members make invalid assumptions about the technical expertise of new members, so called "grasshoppers", who quite possible know more in actuality than any of the regulars....