Short answer: Yes

Longer answer:

https://technet.microsoft.com/en-us/library/ms345392(v=sql.105).aspx

Scalable Shared Databases Overview

The scalable shared database feature allows you to scale out a read-only database built exclusively for reporting purposes (a reporting...

null

Chitown (7/14/2016)

---

When I run the select * from the table, it returns 100K records in 6 minutes. I deleted top 10 records and it took almost 50 seconds (5 seconds...

Guess how many 360 K floppies it would take to backup a 1 TB database. Also try to guess how much time it would take if you had one guy...

Fortunately nowhere near the number required to backup the database.

What was originally coined "NoSQL" should really have been NoACID, since they have since discovered that in order for their database platform to be marketable outside the realms of academia...

Jeff Moden (7/12/2016)

---

HappyGeek (7/11/2016)

---

quentin.harris (7/8/2016)

---

True. It is a difficult place to be as a developer not sitting within the DBA/BI team but interfacing with their DW.

It seems to be...

It could be that the sessions performing updates on this table as part of a larger batch transaction. Often times programming will begin a transaction, update, and then do some...

What you're dealing with is probably blocking of some time. To get to the bottom of this issue, during these occasions where query latency is extremely long, you need to...

djackson 22568 (7/11/2016)

---

Japie Botma (7/11/2016)

---

djackson 22568 (7/11/2016)

---

What could possibly be embarrassing about...

quentin.harris (7/8/2016)

---

Awesome. Though i will be seeing flying pigs before i think i will be allowed to do this as it seems it can show sensitive information such as passwords....

David.Poole (7/11/2016)

---

Japie Botma (7/11/2016)

---

What about POPI laws? (Protection of Personal Information Act). If your data is in the cloud and the whereabouts of the actual server can change with...

I have a hanful of suggestion for making smart phones more secure.

First, I understand why Apple and Samsung manufactore their phones in cheap overseas sweatshops; it's all about economics. However,...

It's funny how, just within the past few years, 2 billion regular folks around the globe are burdened with the responsibility of being an accidental system administrator for a tiny...

SQL!$@w$0ME (7/7/2016)

---

Hello Folks,

Is it a good practice to create clustered index on non-primary key columns since the primary key column is not queried at all. Please share your thoughts or...