below86 (10/27/2015)

---

Eric M Russell (10/27/2015)

---

However, if a single column approach is more appropriate, then I still prefer not to use 1 or 0 but rather a character using a less...

I generally look to see what the most common condition is. That condition gets the zero value. The abnormal condition gets the 1 value. Then I just name the column...

I mentioned earlier that I prefer using two date columns to indicate active status like so:

ActiveDate date not null default (getdate()),

InactiveDate date not null default ('9999-12-31'),

check (InactiveDate >= ActiveDate),

However,...

When an industry...

Niko Neugebauer has written a great series of blog posts about Clustered ColumnStore internals.

Clustered Columnstore Indexes – part 36 (“Maintenance Solutions for Columnstore”)

http://www.nikoport.com/2014/07/29/clustered-columnstore-indexes-part-36-maintenance-solutions-for-columnstore/

xsevensinzx (10/26/2015)

---

Eric M Russell (10/26/2015)

---

..If you look through the jobs, many are development positions, but there are some good data ones. Data modeler, BI Analyst, Data Architect, Big Data Engineer,...

Eric M Russell (10/26/2015)

---

Besides searching across text of all database objects, another approach is to search the text of cached query plans. This will narrow the search to only those...

Besides searching across text of all database objects, another approach is to search the text of cached query plans. This will narrow the search to only those objects and statements...

Many organizations, even if they have good...

Dumb (or just inexperienced) programmers are hired to initially develop databases,...

The following operation will set database to RESTRICTED_USER mode, meaning that only SYSADMIN accounts can login. It also does a rollback and disconnect on any existing connections.

alter database <db_name> set...

I'd keep staging in a separate database, because that gives you the flexibility to set whatever recovery model, backup schedule, log truncation, and other database options are optimal for staging...

..If you look through the jobs, many are development positions, but there are some good data ones. Data modeler, BI Analyst, Data Architect, Big Data Engineer, and, of course, Data...

Wayne West (10/23/2015)

---

According to this page from the ACLU, it starts at the coastline and moves in. I wrongly assumed it would have started at the international water boundary,...

My database server has the new omnistate Solipsistic CPU which insures all bits assume the ideal value desired by each observer at all times.