How did you end with a 12 GB mssql ERRORLOG file, if that's what you're talking about?

Anyhow, there are some Hex editors like HxD or XVI32 that can browse and...

sqlenthu 89358 (9/14/2016)

---

Table is not partitioned and also...

djackson 22568 (9/13/2016)

---

I think more people than those at the...

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...