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 (584)

- 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)

- Kevin Conan (18)

- chopstik (18)

- Rob Earl (14)

- thatrickguy (12)

- More...
Main Categories
Search
Google Ads
Tags: sql server 2008
SQL Puzzle.. How many uppercase and lowercase characters in a column
In this week's puzzle we are going to try to figure out how many uppercase, how many lowercase characters are in a column, we are also interested in how many are neither uppercase or lowercase Here is the table and the data CREATE TABLE Puzzle…
SQL Puzzle.. Sorting results without using ORDER BY
Time for this week's puzzle/teaser. I want to return the results in ascending order but without using ORDER BY If you run this code CREATE TABLE Puzzle (Col1 varchar(20) NOT NULL PRIMARY KEY CLUSTERED, Col2 varchar(20) NOT NULL UNIQUE…
SQL Puzzle...how many even numbers are there in a row
In last week's puzzle SQL Puzzle: RIGHT without using the RIGHT function we looked at how to do a RIGHT function without using the RIGHT function. Today we are going to find out how many columns are even in a row. Before starting I want you to be aw…
SQL Puzzle: RIGHT without using the RIGHT function
I haven't done a puzzle for a long time so I figured let's do a simple one. Return the right 6 characters of the column but without using the RIGHT function. Here is what the table looks like CREATE TABLE #Puzzle(SomeCol CHAR(7)) INSERT #Puzzl…
SQL Server Database owner ~~UNKNOWN~~
Today I was checking an older server and decided to run sp_helpdb. On a bunch of databases I noticed that the owner was ~~UNKNOWN~~. The only reason I noticed this was when I tried to look at a specific database which is mirrored. I was greeted with thi…
Fixing a SQL Server could not spawn FRunCM thread error
I had to change the account that some SQL Server boxes were using to run the SQL Server services. After I changed the account on one machine from DomainName\User to DomainName\NewUser SQL Server wouldn't start up In the error log I saw the following…
Where to find the xtype info for SQL Server in a table
If you look at the sys.sysobjects view, you will see an xtype column listed Object type. Can be one of the following object types: AF = Aggregate function (CLR) C = CHECK constraint D = Default or DEFAULT constraint F = FOREIGN KEY constraint L…
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…
Messing with your friendly DBA on April Fools' Day
April Fools' Day is a day when people play practical jokes and hoaxes on each other. Why not trying to play some practical jokes on your friendly DBA :-) The first thing we are going to do is to spoof the host and program name. This is easy to do. Click on Connect, choose Database Engine, you will see the following box
Wrap inserts in a transaction for faster performance
Sometimes you have to insert a bunch of data and you can't use BCP or another bulk load method. When you do single row inserts, SQL Server wraps these inserts inside an implicit transaction. Did you know that if you use an explicit transaction that the…
:: 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.