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 (585)
- 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: database
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
:: 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.