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 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 ssrs structuremap t-sql tip training 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: how to
Using a Dedicated Administrator Connection via SSMS
If you need to use a Dedicated Administrator Connection (DAC) via SSMS, you can't just use the Connect Object Explorer, if you try you will get the following error Dedicated administrator connections are not supported via SSMS as it establishes multi…
Using WITH RESULT SETS with stored procedures that return multiple resultsets
Yesterday I blogged about using WITH RESULT SETS with the EXECUTE command here: Use WITH RESULT SETS to change column names and datatypes of a resultset. Naomi Nosonovsky left the following comment Can you use this feature to get result sets from the s…
Use WITH RESULT SETS to change column names and datatypes of a resultset
SQL Server 2012 has added WITH RESULT SETS to the EXCECUTE command. You can now override the data types and names that the resultset is returning EXEC ('SELECT name FROM sys.tables' ) WITH RESULT SETS ( (TableName nvarchar(100)) ); Table…
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, 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…
Find all the tables and indexes that have data compression
I took a backup of one of our test databases today and gave it to someone so that it could be restored on one of their servers. I got back the following in an email from the person who tried to do the restore Date 11/16/20…
Why do you need additional privileges for truncate table compared to delete?
One of the people on my team wants to have the ability to truncate tables on the staging database while this person is testing, why are special permissions required compared to a delete?
If you installed Windows 8, you might be wondering how to shut down or restart this operating system. There is no more start button so where do you start? There are a couple of ways to shut down the operating system 1) Hit CTRL + ALT + DELETE and…
Don't put a return statement in a stored procedure inside a transaction
I answered the following question earlier this evening: Return an output parameter from SQL Server via a stored procedure and c# Here is the proc in question, take a good look at it, do you see the problem? ALTER PROCEDURE [dbo].[Insert_UnknownCus…
You don't need to shrink a database to get a smaller backup
Last weekend I decided to do some maintenance on one of our database to see if I can get some freespace back. I use compression for some of the older tables and also reindexed the tables with a higher fill factor. After I was done, I got over 200 GB of…
:: 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.