Andrew..Peterson (3/10/2015)

---

About a year ago, a big technology company started a complete re-write of their applications, with the initial hope of completely eliminating their relational database system. Their initial goal...

Disclaimer: I have no practical experience with MongoDB at this point, so if my assumptions below are wrong, then please let me know.

I can see MongoDB as an ideal...

CREATE CLUSTERED INDEX IX_UNIQUE_KEY ON MRP.Margin_Optimization_Data (UNIQUE_KEY);

If IX_UNIQUE_KEY is intended to be a unique key, then you probably want to add the UNIQUE keyword.

CREATE UNIQUE CLUSTERED INDEX IX_UNIQUE_KEY

ON...

DBA's arn't born cranky; it's an acquired attitude. It does seem to me that unqualified developers (at least in terms of database design) get the first crack at a new...

GoofyGuy (3/9/2015)

---

'Web service'.

Abstracting out the database layer from the application offers a number of advantages -- not the least of...

I wish that Microsoft would put a bit more development into the SSMS Database Diagrammer tool. It's OK, for basic modeling, but it's limitations quickly become apparent when it comes...

In recent versions of SQL Server, we now have a handful of table types to choose from: traditional row store, Heckaton in-memory (high volume OLTP), ColumnStore (data warehousing). Each table...

I'm convinced that no more than 1 in 4 IT shops, and this includes everything from two man startups to major corporations, really just don't "get" database engineering. If you've...

sqlcentral.dah328 (3/5/2015)

---

sql-lover (3/5/2015)

---

sqlcentral.dah328 (3/4/2015)

---

I ran into this same problem with SQL Server 2012 and this was one of the few places where anyone took seriously the possibility that the identity...

I'm assuming the goal here is the retreive the latest DUESTATUS and COMPSTATUS for each PERSID, and what we have to work with is a table containing one record for...

There are a lot of scenarios where SSMS table designer or a schema compare tool will want to rename / create / select / insert, when a simple ALTER TABLE...

Looking at the SQL, it appears that PERSON doesn't contain one row per person but rather multiple rows per person for each status change. I think you can leverage row_number()...

Peter Schott (3/4/2015)

---

Eric M Russell (3/4/2015)

---

For those of you who work in shops where developers make in-place changes to database objects and deployments are based on comprehensive delta scripts, how...

I'm not sure, but with a database in SINGLE_USER mode, I think it's possible for a non-sysadmin user to login and block even the DBA, or the DBA may be...

For those of you who work in shops where developers make in-place changes to database objects and deployments are based on comprehensive delta scripts, how do you implement versioned source...