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

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

December 22, 2013

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…

SQL SERVER – Monitor Database via a Heatmap, Alarms List and Realtime Diagnostics for FREE

December 16, 2013

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

Dell, SQL Utility

Note: This review is based on the performance monitoring and tuning free product Spotlight on SQL Server Freemium. If you think of a DBA’s life, it has one very simple goal – their server should never go down and all the queries should always perform excellently. However, just like any…

SQL SERVER – How to Identify Datatypes and Properties of Variable

December 15, 2013

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Just another day I received very interesting question in email from Zovis and we exchanged few emails. I am converting our conversation in the chat format to understand it easily. Zovis: How do I identify the datatype and other properties of the variable? Pinal: Just check the datatype of the…

Personal Technology – How to Dress for an Interview – Guidelines and Suggestions

December 14, 2013

Pinal Dave

SQL Tips and Tricks

If you Google “how to dress for an interview,” you will get 253,000,000 results. That is how many articles there are on the internet telling you how you should and should not dress yourself to meet potential employers – and this is not counting the innumerable books, magazine articles, and…