SQL Tips and Tricks Archives - Page 197 of 536 - SQL Authority with Pinal Dave

SQL SERVER – Roundup Post – Notes from the Field – Year 2013 – Performance Tuning and Database Health

December 26, 2013

One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology…

SQL SERVER – Overall SQL Server Performance – Not Just Query Performance – Notes from the Field #008

December 25, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a new episode of Notes from the Field series. When SQL Server is slow we think we can improve the performance of the server by just increasing the performance of queries. However, sometimes the queries are already doing good and there is no increase in…

SQL SERVER – Learning More About SQL Wait Stats

December 23, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Wait Stats

I was recently visiting my customer for my day job in Delhi. During the meeting, I had a great time to meet a few of the technical domain experts of the leading organization. We discussed lots of different things while we were there and much of the conversation was surrounding…

SQL SERVER – What Permissions I have on Database I am Connected to?

December 22, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

Here is the first thing I do when I get access to any new server – I check what are different permissions I have with respect to the database I am connected with. The matter of the fact is that most of the database consultants and administrator want to know…

Developer – Nine Things Developers Hate to Hear

December 21, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Humor

1. Uh oh… No one likes hearing this – not parents, not repairmen, not developers. They don’t like hearing others say it, and they don’t like hearing it come out of their own mouths. It usually means bugs. 2. Can you fix my computer? This question is the bane of…

SQL SERVER – Redundant Indexes Good or Bad – Final Wrap – Part 7

December 20, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index

This is the seventh part of a series regarding Redundant Indexes. If you have not read the earlier parts – there is quite a good chance that you will miss the context of this part. I suggest that you should quickly read the earlier four parts. On my production server…

SQL SERVER – SQL Server Alerts and How to Use Them – Notes from the Field #007

December 19, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

[Note from Pinal]: This is a seventh episode of Notes from the Field series. The biggest issue any DBA have with their server is the health of it. We all want to configure our server optimally and know any issue with it if it faces one. This is one of…