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
backup bigdata book business intelligence database denali functions gotcha how to howto indexing mongodb nosql performance 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 t-sql tip
Authors
- SQLDenis (404)

- Ted Krueger (onpnt) (252)

- Jes Schultz Borland (grrlgeek) (102)

- George Mastros (gmmastros) (40)

- Naomi Nosonovsky (23)

- David Forck (thirster42) (20)

- Koen Verbeeck (19)

- Axel Achten (axel8s) (16)

- Kevin Conan (15)

- Eli Weinstock-Herman (tarwn) (12)

- Christiaan Baes (chrissie1) (12)

- sqlarcher (10)

- emtucifor (7)

- Alex Ullrich (6)

- ptheriault (6)

- More...
Main Categories
Search
Google Ads
Category: Microsoft SQL Server
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…
Deploying Database Changes with PowerShell
Recently, while working on a personal project, I found myself needing a lightweight way to deploy database changes to multiple environments. In the past I have used a wide range of methods, ranging from applying the changes manually to applying changes via a diff tool (SQL Compare), to automatically applying manually created change scripts, to automatically applying diff scripts that were automatically generated, to working directly in production..er, pretend you didn't see that one.
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…
SQL Server Baseline Collection
SQL Server baseline collection is an important task that is too frequently overlooked. Collecting information on how SQL Server is both providing data services and reacting to how those data services are being utilized, creates a foundation for efficie…
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…
:: 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.