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

2

SQL Advent 2012 Day 4: Triggers, what to do, what not to do

This is day four of the SQL Advent 2012 series of blog posts. Today we are going to look at triggers. Triggers are a great way to keep your database in a consistent state. There are two types of triggers, DML triggers and DLL triggers. DML triggers res…

Read More...
2

SQL Advent 2012 Day 3: Sargable Queries

This is day three of the SQL Advent 2012 series of blog posts. Today we are going to look at sargable queries. You might ask yourself, what is this weird term sargable. Sargable comes from searchable argument, sometimes also referred as Search ARGument…

Read More...
4

SQL Advent 2012, here is what is coming

I decided to do a SQL Advent series of posts this year as well, this year I will focus on best practices. In case you are interested in last year’s posts, all of them are listed here: SQL Advent 2011 Recap

Here is what the preliminary 25 posts will l…

Read More...
2

Downloading SQL Server Sample Databases much improved with new CodePlex changes

Today Microsoft has improved the experience of downloading the sample databases for SQL server. As you can see from the image above, you can now quickly see all the different versions and all you have to do is click on the database that you are interest…

Read More...
0

SQL Advent 2011 Recap

Here is a recap of all the 24 SQL Advent 2011 posts
Day 1: Date and time
In this post I covered the new date, datetime2 and time datatypes

Day 2: System tables and catalog views
In this post we took a look what the replacements are for the all s…

Read More...
1

Returning a value inserted in a table with a newsequentialid() default on a uniqueidentifier column

This question came up yesterday and I decided to do a little blog post about it. Someone wanted to know if there was something like @@identity/scope_identity() for a uniqueidentifier column with a default of newsequentialid(). There is not such a functi…

Read More...
1

SQL Server Denali CTP1 Announced at PASS

Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named Denali. You can download it here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92…

Read More...
0

The new Dynamic Management Views in SQL Server Denali

With SQL Server Denali CTP1 come 20 new dynamic management views, this brings the total number of dynamic management views to 155

Here is a list of the new dynamic management views, included is also the type of the dynamic management view…

Read More...
0

Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object

If you have a stored procedure which returns two result sets up till now there was now way to get the meta data easily about the first result set. Let’s take a look what is new in SQL Server Denali, first create this very simple stored procedure.

cre…

Read More...
2

Don’t install Denali BIDS side by side with a 2008 instance

If you already have a SQL Server 2008 or a SQL Server 2008 R2 instance then do not install SQL Server Denali as a named instance. If you do so then your current SSIS development environment will be broken. There is a reason there are virtual machines, I…

Read More...
Next Page »