Login or Sign Up to become a member!
LessThanDot Site 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.

Browsing "database"

1

Find what is deprecated in SQL Server Denali by using sys.dm_os_performance_counters

With every version of SQL Server come warnings about features/code that is deprecated. You can use the sys.dm_os_performance_counters dynamic management view to find what these deprecated features are.

If you run the following query on SQL Server De…

Read More...
6

Using OFFSET N ROWS FETCH NEXT N ROWS ONLY In SQL Server Denali for easy paging

SQL Server Denali makes it much easier to do paging compared to previous versions of SQL Server. In SQL Server 2005 or 2008 you would do something like the following to skip the first 50 rows

WITH cte AS (SELECT ROW_NUMBER() OVER(ORDER BY number) AS…

Read More...
0

Debugging In SQL Server Denali

Debugging has been improved in SQL Server Denali, here is a quick video that shows you how you can set a break point hit count and then while debugging it will stop when it hits that value. Of course stuff like this has been around forever in Visual Studio, I am glad that it now […]

Read More...
0

Screenshots of the new look and feel of BIDS in Denali

If you are installing SQL Server Denali CTP 1 on a computer which already has SQL Server 2008 or 2008 R2 installed, please read: Don’t install Denali BIDS side by side with a 2008 instance. For CTP 1 BIDS is still based on VS 2008 once they switch to 2010 this won’t be a problem. […]

Read More...
2

A first look at sequences in SQL Server Denali

People have been asking for sequences for a very long time and now finally it is included with SQL Server Denali CTP 1. You don’t have to muck around with an identity table that you share across many tables anymore. A simple sequence will look like this T-SQL1 2 3 4 5 6 CREATE SEQUENCE […]

Read More...
4

First look at SQL Server Management Studio Denali

The SQL Server Management Studio that ships with SQL Server Denali CTP1 is based on the Visual Studio 2010 shell. One of the advantages you will see right away is that if you have multiple monitors you can drag a query window to another monitor. This is…

Read More...
0

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 T-SQL1 2 […]

Read More...
4

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 […]

Read More...
0

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 […]

Read More...
0

Dealing with the could not allocate new page for database ‘TEMPDB’. There are no more pages available in filegroup DEFAULT error message

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 […]

Read More...
« Previous PageNext Page »