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 server 2008 r2"

2

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...
1

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...
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...
4

Umm….No…that is not how you export a table into a file with SQL Server

Sometimes the creativity of the human species is truly amazing. Someone needed to export a table into a file from within SQL Server. Now there are several ways to do this like bcp, export wizard, Query..Results To File, SSIS etc etc. Today I noticed som…

Read More...
0

SQL Advent 2012: Recap

A recap of all the SQL Advent 2012 posts

Read More...
0

SQL Advent 2012 Day 24: Getting help

This is day twenty-four of the SQL Advent 2012 series of blog posts. Today we are going to look at how to get help

Read More...
0

SQL Advent 2012 Day 22: Testing your backup and failover strategy

This is day twenty-two of the SQL Advent 2012 series of blog posts. Today we are going to look at how to test your backup and failover strategy

Read More...
0

SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it

This is day twenty-one of the SQL Advent 2012 series of blog posts. Today we are going to look at Very Large Databases

Read More...
0

SQL Advent 2012 Day 16: Lack of database design and normalization

This is day sixteen of the SQL Advent 2012 series of blog posts. Today we are going to look at the lack of database design and normalization.

Normalize untill it hurts, denormalize until it works

Read More...
Next Page »