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 asp.net asp.net mvc azure book bug business intelligence c# cloud computing database dates excel functions gemini google gotcha how to howto iis interview kanban linq madison measurement mvc nhibernate nunit performance process improvement programming rhino mocks security silverlight sql sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sqlserver structuremap t-sql tip trick unit testing vb.net vista visual studio 2010 windows 7
Authors
- SQLDenis (269)

- chrissie1 (200)

- onpnt (96)

- George Mastros (35)

- Alex Ullrich (24)

- tarwn (17)

- naomi (9)

- thatrickguy (8)

- ca8msm (7)

- damber (7)

- emtucifor (7)

- chopstik (6)

- More...
Main Categories
Search
Google Ads
Tags: database
Use alter table alter column to change datatypes for a column in SQL Server
This question popped in the microsoft.public.sqlserver.programming forum yesterday. A person wanted to change a column from varchar 500 to varchar 2000. This is actually pretty easy to do in SQL Server, you can use the alter table alter column command
Let's take a quick look at how this works
First create this table
Dealing with Cannot resolve collation conflict for equal to operation errors
This was asked on twitter recently and I gave the answer there. I decided to write a blog post about this because I can use over 140 charaters here instead.
You will see the Cannot resolve collation conflict for equal to operation error when you try to join 2 tables. let's take a look at what we need to do to resolve this. First create and populate these two tables
Review of SQL Server 2008 Administration in Action
I have finished reading SQL Server 2008 Administration in Action by Rod Colledge and below is my review of this book
I will start by saying that I truly enjoyed this book. The book is written in a casual way and is not filled with tons of code, concepts are explained well and where needed images are included to help you understand it better. I also like the fact that this is not a 1000 page monster which weighs more than ...
Someone was writing some queries that brought back a lot of data (and I mean a LOT!!) and after a while he got the following message
Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or or allowing file growth
That is not good, fortunately this wasn't one of our production machines but a dev/test box.
So what causes this? You might think that tempdb is o...
Your testbed has to have the same volume of data as on production otherwise you are not really testing anything.
This blogpost is kind of a rant after I noticed this post on Stackoverflow
I do not believe there is a problem with the create trigger statement itself. The create trigger statement was successful and quick in a test environment, and the trigger works correctly when rows are inserted/updated to the table. Although when ...
:: 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.