Full backups can't be restored to times or marks, they are always restored to the consistent point at the end of...

If they're getting denied access to just one table, then there's a object-level permission set on that table. Check the DMVs for the details, you can then use REVOKE to...

Yes it can, and that knowledgable friend is wrong, 64kb is not the ideal block size, SQL does not read and write in extents only.

http://blog.purestorage.com/what-is-sql-servers-io-block-size/

You've got a DB in full or bulk-logged recovery model and you've never backed up the log? Might want to fix that before the log fills the drive (log space...

Can't see the picture.

Shrink is how you reduce the file size, but unless there's a really good reason, and a lot of free space in the file that will never...

Any shrink to the log file only removes space to the last active VLF. VLFs cannot be...

Jeff Moden (8/19/2016)

Note that (IIRC) switching to BULK LOGGED may have an impact (as in break it) on log shipping so you may be stuck with having the log file...

szejiekoh (8/22/2016)

---

I wanted to sort this out because people are telling me that you can have a 2 node window cluster setup without any form of share disk at all....

Yes, it must be on a cluster.

As I said above, recommeded quorum model is either node majority or node and file share depending how many nodes you have (you need...

Try filtering on database_id, or is the db_id the id of the connection rather than the table?

You can check the default trace, but I'm not sure if job deletions are recorded.

Avbailability Groups do not require shared storage. Recommended quorum model is either node majority or node and file share depending how many nodes you have.

2M (8/22/2016)

---

due to this our server RAM utilization is almost 96% all the time , the moment we shut down SQL Services RAM Utlizatin drops below 5%

when we checked the...

Always On is a marketing term that encompases multiple features.

Always On Windows Failover Clustering required shared storage, just like clustered SQL instances always have.

Always On Availability Groups does not require...

Is it a clustered instance?