Maybe stretching into Amazon or GoDaddy is an option?

... If you stretch a sales database, say a 100GB database and want to move 60GB of that data away, you're going to pay at least US$930/month for the compute...

Jeff Moden (12/7/2016)

---

Eric M Russell (12/7/2016)

---

alex.sqldba (12/7/2016)

---

Hi Eric,

Whilst it is not a heap, there is a clustered index on a datetime field, I am curious as to how one would...

jim.powers (12/8/2016)

---

...

I did speak with my boss this morning. He said that permissions were taken away from all users because I created a tiny little database for another web developer...

Just out of curiosity, give us a little background information about this situation. For example, are you primarily in an IT support or DevOps position within a small company and...

By lock, you probably mean decrypt. 7Zip uses AES256 encryption. My advice would be to download the command line version of 7Zip and then write a PowerShell script to perform...

In the interim, should you get a 2AM support call, tell them to call Dick.

You can grant yourself membership to the SYSADMIN role by:

1. log into Windows host as local admin

2. stop the SQL Server service

3. restart...

alex.sqldba (12/7/2016)

---

Hi Eric,

Whilst it is not a heap, there is a clustered index on a datetime field, I am curious as to how one would go about reclaiming the space...

If this table is a heap (no clustered index) then space will not be deallocated for deleted rows.

Yes, the library analogy helps explain a lot.

For example, shrinking or expanding the book shelves to accommodate the current number of books would not only be a lot of work...

Think of a database table as a library shelf containing books. When you pull a book from the shelf, the self doesn't get smaller. It just contains empty slots where...

A quotient is essentially a computed value. If the application is working with imprecise quotients, then perhaps it's best (from an accuracy, storage, and performance) to contain dividend and divisor...

You can easily use the SSMS Import and Export Wizard for this, and then if it needs...

skeleton567 (12/6/2016)

---

TD-238967 (12/6/2016)

---

You should see the "forest" instead of the "tree". Think first, code later then you can have the best solution for your project. There so many...