Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

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.

Browsing "sql"

0

Diagnostic Manager Quick Tip – New Server Tag

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…

Read More...
0

Diagnostic Manager Quick Tip – Job Messages

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…

Read More...
0

Diagnostic Manager – Custom Alerts

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.

Read More...
4

Would you be interested in an information section for SQLCop?

SQLCop detects the following issues right now. What else would you like to see?

Detected issues

Code

Procedures with SP_
VarChar Size Problems
Decimal Size Problem
Undocumented Procedures
P…

Read More...
1

Anecdotes about SQL AKA post 400

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’m…

Read More...
17

SQLCop A Tool To Highlight Potential Problems With Your Database

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…

Read More...
2

T-SQL Tuesday #008: Gettin’ Schooled “Pushing others into learning and teaching”

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.

Read More...
2

Calculating The Percentage Of Null Values In A Column With Transact SQL

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 […]

Read More...
0

Dealing with the could not allocate new page for database ‘TEMPDB’. There are no more pages available in filegroup DEFAULT error message

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 […]

Read More...
4

A couple of ways of getting the top 2 distinct values from a set in SQL Server

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 […]

Read More...
« Previous PageNext Page »