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 c# community continuous delivery database denali gotcha how to howto indexing java linq mongodb nancy nhibernate nosql performance powershell restore 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 t-sql tip training unit testing vb.net visual studio 2010 windows 7
Authors
- SQLDenis (577)
- Christiaan Baes (chrissie1) (527)
- Ted Krueger (onpnt) (332)
- Jes Schultz Borland (grrlgeek) (139)
- Eli Weinstock-Herman (tarwn) (116)
- Alex Ullrich (51)
- George Mastros (gmmastros) (46)
- Naomi Nosonovsky (27)
- Axel Achten (axel8s) (23)
- David Forck (thirster42) (22)
- Koen Verbeeck (20)
- Kevin Conan (18)
- chopstik (18)
- Rob Earl (14)
- thatrickguy (12)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: t-sql
Why avoiding multiple code blocks in a Stored Procedure
It was a little remark from Bob Beauchemin (B|T) during the Belgian SQL Server Days that started me writing this post. Showing cached Execution Plans In this post I’m going to use information from the following Dynamic Management Views and Functions t…
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from bad things. But, we all make mistakes. It could be because we're on a time crunch, or we're lazy (which I'm guilty of by…
T-SQL Tuesday #38 – Resolving an SSIS package performance problem
This is my contribution to T-SQL Tuesday #38: Standing Firm. I describe how I resolved an SSIS package performance issue.
Why you shouldn't use SELECT *
A customer's DBA team created a checklist for the development teams with some best practices for writing proper T-SQL and asked me to write some contributions for their tips document library. So if I do the research and write the documents I might as we…
Dealing with the Column name 'TEXT()' contains an invalid XML identifier as required by FOR XML; '('(0x0028) is the first character at fault error
I had to deploy a user defined function I was given yesterday, when I tried to I got the following error Msg 6850, Level 16, State 1, Procedure fnGetBooks, Line 8 Column name 'TEXT()' contains an invalid XML identifier as required by FOR XML; '('(0x…
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…
Book Review: Microsoft SQL Server 2012 T-SQL Fundamentals
With a basis as a system engineer, I became a DBA. And DBA's don't often write real DML queries. I can read a query, understand what it's doing but when I need to read one I need BOL the help me out. Taking the 070-457 Transition Your MCTS on SQL Server…
T-SQL CASE functions
With the CASE statement you can add conditional logic to your T-SQL code. T-SQL 2012 has certain functions that can be seen as CASE shortcuts. With these functions you can quickly use some CASE functionality and as a surplus, because they are functions…
T-SQL Tuesday #31 - Logging Simple Things
How big are your core databases right now? Do you know how they got that way? Is that normal? These questions are impossible to answer just by looking at the database options dialog in SSMS. They are also questions I've had to try to answer in several d…
:: 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.