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.
Your profile
Tag cloud
.net android asp.net asp.net mvc azure backup bigdata book business intelligence c# community continuous delivery database denali excel gotcha how to indexing java linq mongodb nancy nhibernate nosql performance powershell ruby security silverlight sql sql advent 2012 sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sql server 2012 sql server denali ssis ssms ssrs structuremap syndicated t-sql tip unit testing vb.net visual studio 2010 windows 7
Authors
- SQLDenis (584)
- Christiaan Baes (chrissie1) (528)
- Ted Krueger (onpnt) (332)
- Jes Schultz Borland (grrlgeek) (140)
- Eli Weinstock-Herman (tarwn) (117)
- Alex Ullrich (51)
- George Mastros (gmmastros) (46)
- Koen Verbeeck (31)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (23)
- David Forck (thirster42) (22)
- chopstik (18)
- Kevin Conan (18)
- Rob Earl (14)
- thatrickguy (12)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: ssms
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?
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…
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,…
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…
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…
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…
SQL Advent 2012: Recap
A recap of all the SQL Advent 2012 posts
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.
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
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…
:: Next >>
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.