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 2014"

5

SQL 2014 CTP1, where is my BIDS?

Oh wait sorry, I meant SSDT. Or was it SSDTBI? To avoid confusion about the developer tool to create BI solutions, Microsoft has changed its name a few times. You know, to make it less confusing. Here’s a nice overview:

BIDS or Business Intelligence…

Read More...
3

List of new programmability features/T-SQL enhancements in SQL Server besides Hekaton

Here is a nice image of all the cool new programmability features and T-SQL enhancements in SQL Server 2014 CTP1, there are no Hekaton (In memory OLTP) features in this list

What, there is nothing there? That is right, besides the Hekaton relate…

Read More...
0

Supported and unsupported datatypes with Hekaton tables

If you are ready to use Hekaton then you need to know that there are some limitations, not all data types are supported.

The following list contains the set of supported data types in both Hekaton tables and stored procedures:

bit
All integer ty…

Read More...
5

SQL Server 2014 CTP1 native compiled Hekaton procedures are faster than regular procedures

I have been playing around with SQl Server 2014 Hekaton tables and stored procedures. I have noticed that native compiled stored procedures are between 20 and 40% faster than regular stored procedures

If you want to test for yourself, then run the fo…

Read More...
0

New Dynamic Management Views in SQL Server 2014 CTP1

There are 26 new Dynamic Management Views in SQl Server 2014 CTP1.

Here is a list of these DMVs in alphabetical order

sys.dm_db_merge_requests
sys.dm_db_xtp_checkpoint
sys.dm_db_xtp_checkpoint_files
sys.dm_db_xtp_gc_cycle_stats
sys.dm_db_xtp_h…

Read More...
0

SQL Server 2014 CTP1 Available for download

Microsoft has made available for download CTP1 of SQl Server 2014

Be aware of the following important information

Installing side-by-side with other versions of SQL Server is NOT supported.

Upgrade from other versions of SQL Server is N…

Read More...