Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

A Technical Community for IT Professionals

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.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

DiscussShareLearn

Google Ads

2
comments
submit to reddit Digg!FacebookDotnetkicks

Now that all my server are SQL Server 2008 I use SSMS with SSMS Toolpack and Toad. I don't really use Query Analyzer anymore. The other day I found out that you can hide objects you don't want to see in SSMS by using filters. Let's first look at some code. Create a new database named test, create a new schema named Denis and then add 3 tables to the dbo schema and 3 tables to the Denis schema. Just run the code below

create database test
go

use test
go

create schema Denis
go

create  table Test1(id int);
go
create  table Tes...
Read More...
2
comments
submit to reddit Digg!FacebookDotnetkicks

Here is something interesting to think about Create this table and insert these 2 rows

create table TableName(id int, name varchar(50))
insert TableName values(1,'bla')
insert TableName values(2,'bla2')
Now if you try to do something like this
   SELECT TOP 1 ID,Name
   FROM TableName
   ORDER BY Name
   UNION ALL
   SELECT 0,''
You will get the following error Server: Msg 156, Level 15, State 1, ...
Read More...
0
comments
submit to reddit Digg!FacebookDotnetkicks

ASP.NET MVC 2 RC 2 has been released and is available for download.

For those that don't know what ASP.NET MVC 2 is. ASP.NET MVC 2 is a framework for developing highly testable and maintainable Web applications by leveraging the Model-View-Controller (MVC) pattern. The framework encourages developers to maintain a clear separation of concerns among the responsibilities of the application – the UI logic using the view, user-input...
Read More...
2
comments
submit to reddit Digg!FacebookDotnetkicks

This will primarily be an extension into the Wiki section on SQL Server Admin Hacks.

OLTP and Reporting

Reporting from OLTP (Online Transactional Processing) databases can be nothing short of difficult at times. The process of reporting of these types on databases can cause blocking, long wait times and in some severe cases, complete failure on the part of the high level operational requirements of the database. In the stage in which we consider how reporting will affect our databases and how t...

Read More...
3
comments

Th QNap TS-419P Turbo NAS

by chrissie1 on Feb 3, 2010 in category Hardware
submit to reddit Digg!FacebookDotnetkicks

Yesterday 2 QNap TS-419P Turbo NAS arrived at work for me to play with. The question of course is how did I choose a solution that will work for me? To be honest pure luck. To be honest you have too much choice and choosing the right thing isn't going to happen unless you trust to pure luck or try some things out and that takes time. So I trust to luck. And no it does not help to read reviews or the manufacturer's website since most sites will not tell you the truth anyway. Neither will I BTW I just tell you what I think is impo...

Read More...

:: Next >>