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 "ssms"

3

SSMS – Enabling Ctrl+R Shortcut to show or hide query results/messages pane

Do you use Ctrl+R to hide or display the query results/messages pane in SSMS? Have you installed SSMS 2012 and find that it does not work?

Read More...
3

Listing tables that are truly partitioned in SQL Server

To list all the tables that are partitioned you can use the sys.partitions view. However be aware that all tables and indexes in SQL Server contain at least one partition, whether or not they are explicitly partitioned.

If you were to do the followin…

Read More...
5

Suppressing xp_cmdshell output

Starting with SQL Server 2005 xp_cmdshell is turned off by default as a security measure. You have to explicitly enable xp_cmdshell it. If you have to move files around on a SQL Server box there are probably better ways than using xp_cmdshell, you can use SSIS,…

Read More...
2

Ten things added after SQL Server 2000 that I like the most

It is almost 8 years since SQL Server 2005 has been released, we have gotten 3 major versions since SQL Server 2000: SQL Server 2005, SQL Server 2008 and SQL Server 2012. I decided to take a look to see what I find the most useful that has been added af…

Read More...
4

Discovering new things (for me) in SSMS

One of the good things about working in technology is that you always will discover new things. The other day I created a blog post: Listing all your SQL Server databases ordered by size. Buck Woody replied to me on twitter that this is also built into…

Read More...
0

A couple of ways to convert an integer to an coordinate with SQL Server

I answered this question from a person who had to convert coordinates stored as an integer to a float

I’m receiving data on coordinates as 115949833 and I need it to output as 115.949833 because I need to be able to calculate the mileage between th…

Read More...
0

SQL Advent 2012: Recap

A recap of all the SQL Advent 2012 posts

Read More...
0

SQL Advent 2012 Day 13: Features enabled that are not used

This is day thirteen of the SQL Advent 2012 series of blog posts. Today we are going to look at servers where everything is installed and enabled.

Read More...
0

SQL Advent 2012 Day 12: Proactive notifications

This is day twelve of the SQL Advent 2012 series of blog posts. Today we are going to look at SQL Server proactive notifications

Read More...
1

SQL Advent 2012 Day 8: Foreign Keys

This is day eight of the SQL Advent 2012 series of blog posts. Today we are going to look at foreign keys

That is all for day eight of the SQL Advent 2012 series, come back tomorrow for the next one, you can also check out all the posts from last…

Read More...
Next Page »