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 functions 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 sqlcop ssis ssms structuremap t-sql tip unit testing vb.net visual studio 2010 windows 7
Authors
- SQLDenis (576)
- 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: sql server
SQL Server Management: Compatibility Levels
So you think compatibility levels will solve all your problems? Think again!
Unique index difference between Oracle and SQL Server
When working with different database systems you have to be aware that some things work differently from one system to another. I already blogged a couple of times about differences between SQl Server and Oracle, those post are the following Truncate r…
Another solution for my caching problem with servicestack.text, dapper and sql server.
How I would like to use servicestack.text, dapper and sql server to use as a cache.
SQL Server Licensing for Non-Production
One of my favorite movie quotes comes from Under Siege 2 (slightly altered to avoid cursing): “Assumption is the mother of all screw ups”.
When is DTEXEC installed?
Which minimal components do you need to install to run SSIS packages on a server? Let's find out!
In my Differences between Oracle and SQL Server when working with NULL and blank values post I already showed you how blanks and NULLS are handled differently between Oracle and SQL Server. Today I found another interesting tidbit. I you have a varc…
Slow source? Make your data flow buffers smaller!
This blog post describes how making the data flow buffers smaller might give a performance boost in some scenarios.
WHERE not to use FUNCTIONS
Functions can be very powerful, but used in the wrong place in a query they can show some unexpected behavior. In this post I will be using the AdventureWorks2008R2 database and I will query the Sales.SalesOrderHeader to get all the 2006 OrderDates. A…
Stupid me #1 – Locking myself out of SQL Server
The first blog post of a possible series where I describe a little problem I encountered and how I solved it.
Truncate rollback differences between SQL Server and Oracle
I wrote a blogpost about the fact that there is a common myth that you can't rollback a truncate statement in SQL this post was written on June 13, 2007 and it showed you that you could rollback a truncate. Here is some code that shows that. CREATE…
:: 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.