Where I work, we like to buy Diagnostic Manager Licenses in batches. So every quarter or so I add in a bunch of new instances. When you start getting over 25 instances being monitored, it gets tricky to remember which 5 instances you just added into t…
Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
A great use of Idera’s Diagnostic Manager is to manage your SQL Job’s and knowing which jobs have failed, which ones are running long and which ones have been running for the last 10 hours. You even get to adjust the thresholds for each all of those me…
One of the great things about Diagnostic Manager is the ability to create custom alerts. This is something I believe needs a bit more work, but even in its current state, it is really useful.
SQLCop detects the following issues right now. What else would you like to see?
Procedures with SP_
VarChar Size Problems
Decimal Size Problem
This is my 400th blog post here on lessthandot and I decide to steal borrow Chrissie’s idea and ask a bunch of people if they have an interesting story to share about SQL.
Here is how I asked it
As you may or may not know I’m an avid SQL fan.
I wrote a blog post 437 days ago asking you the reader if you would be interested in a FxCop tool for SQL Server. That post can be found here: SQLCop, FxCop For SQL Server, Would You Be Interested in This?. Today I am pleased to announce that the first…
Everyone in a professional career that involves the constant evolution of computing will be successful while retaining the daily mindset that we always keep learning. This learning process does isn’t limited to what we already know or what we’ve done. What we know and have done is the foundation of where we can lift ourselves further by learning more in-depth on our knowledge and gain new knowledge of what we may have not found ourselves needing day-today yet. This assists us to better ourselves and improve upon our skills. Our learning foundation is only as good as the manner in which we look upon our accomplishments with great humility. Doing so allows us to look into our skills and learn to better them while gaining the new skills that we can continue to grow on.
What is the percentage of null values in a table for a column? This question comes up every now and then and it is pretty easy to answer this question We will start by creating the following table T-SQL1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 […]
Someone was writing some queries that brought back a lot of data (and I mean a LOT!!) and after a while he got the following message Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate new page for database ‘TEMPDB’. There are no more pages available in filegroup DEFAULT. Space can be created by dropping […]
In this blog post I will show you a couple of ways of getting the top 2 values from a set in SQL Server. The dense_rank queries will not work if you have SQL server 2000 but the other ones should. Let’s say you have a table that has this data 100 100 100 99 […]