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

sqlguy-736318 (12/6/2016)

---

I'm trying to understand relative sizing for design conversation purposes. For example, in this context, would it be reasonable to state that?:

* Selecting 1 row from 1 table...

krishnaroopa (12/6/2016)

---

Hi all

I have a table "test" in my "testdb" database. There is a user "user1"

The user has access to all tables in the database.

For this particular table...

This has actually been a recurring theme in my career, and my nature is a multi-phased blend of all three mentioned approaches: passive, then systemic, and finally nuclear. The first...

sqlguy-736318 (12/5/2016)

---

I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a typical SS configuration, what type of response time...

I don't need any stimulus when I'm writing code or troubleshooting. It's the slower mundane days when I need caffeine.

Total response time will depend on the client and network. For a web application, you may have 2 - 3 seconds of user perceived latency on top of a query...