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 "sql server denali"

5

Microsoft SQL Server, codename “Denali”, will be the last release to support OLE DB, ODBC is the new new thing

According to the Microsoft SQLNCli team blog, SQL Server, codename “Denali”, will be the last release to support OLE DB.

Here is what they are currently saying

The next release of Microsoft SQL Server, codename “Denali”, will be the last release t…

Read More...
5

Watch all the Tech·Ed North America 2011 SQL Server videos

If you missed Tech·Ed North America 2011, I have compiled a list of all the SQL Server videos for you.

Each one links directly to the video, have fun watching it all

Microsoft SQL Server Code-Named “Denali” AlwaysOn Series,Part 1: Introducing the…

Read More...
5

Dealing with The row value(s) updated or deleted either do not make the row unique or they alter multiple rows errors

Someone asked about this error this morning and I decided to turn it into a blog post. Basically the person was using the designer/editor in SSMS to delete a row, the table didn’t have a key and the rows were not unique, he got the following error: The…

Read More...
1

SQL Server Denali CTP1 Announced at PASS

Today at PASS the SQL Server team has publicly announced the first Community Technology Preview of the next version of SQL Server code named Denali. You can download it here: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=6a04f16f-f6be-4f92…

Read More...
0

The new Dynamic Management Views in SQL Server Denali

With SQL Server Denali CTP1 come 20 new dynamic management views, this brings the total number of dynamic management views to 155

Here is a list of the new dynamic management views, included is also the type of the dynamic management view…

Read More...
0

Playing around with sys.dm_exec_describe_first_result_set and sys.dm_exec_describe_first_result_set_for_object

If you have a stored procedure which returns two result sets up till now there was now way to get the meta data easily about the first result set. Let’s take a look what is new in SQL Server Denali, first create this very simple stored procedure.

cre…

Read More...
2

Don’t install Denali BIDS side by side with a 2008 instance

If you already have a SQL Server 2008 or a SQL Server 2008 R2 instance then do not install SQL Server Denali as a named instance. If you do so then your current SSIS development environment will be broken. There is a reason there are virtual machines, I…

Read More...
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...
Next Page »