If you haven't heard about Hekaton by now, you should think about reading up on it. There's some information from TechNet, a keynote video, and more. Despite the ranting from Oracle's Bob Evans in 2012 that this was "vaporware", it's coming in SQL Server 2014. The latest demos don't show 100x increase in query speed, but they 30x or so numbers I've seen are very impressive.
Hekaton is an in-memory database technology, actually called In-Memory OLTP in Books Online. This isn't a re-invention of the pintable concept from SQL Server 2000. Instead it's a very well though out architecture and rather interesting in the way it's implemented. The keynote video gives you a deep overview, though to use the tables, most of us don't need to know the internals of how they work.
However we do need to look at the restrictions, err requirements. Since these tables will exist in memory, obviously you need more memory, but more than you thought. The recommendation is twice the expected table size, to account for versioning. In addition, this memory is in addition to the buffer pool and other memory your instance already needs. That means much more complex memory calculations and monitoring for DBAs.
The complexity of SQL Server continues to grow over time as more and more features are added to the product. Many of us don't need much more than the core relational database functionality for many applications, but the in-memory OLTP tables might be one feature that can help dramatically increase the speed of your application.
“With SQL Monitor, we can be proactive in our optimization process, instead of waiting until a customer reports a problem,” John Trumbul, Sr. Software Engineer. Optimize your servers with a free trial.
Generate realistic test data, fast
“In less than the time it took me to get my coffee, I had a database with 2 million rows of data for each of 10 tables.” Stephanie Beach, QA Manager. Try SQL Data Generator now.
Save 45% on our top SQL Server database administration tools.
Together they make up the SQL DBA Bundle, which supports your core tasks and helps your day run smoothly. Download a free trial now.
Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs. More »
Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan? More »
Column Store Index, which improves performance of data warehouse queries several folds, was first introduced in SQL Server 2012. Though it had several limitations, now SQL Server 2014 enhances the columnstore index and overcomes several of the earlier limitations. In this article, Arshad Ali discusses how you can get started using the enhanced columnstore index feature in SQL Server 2014 and do some performance tests. More »
Question of the Day
Today's Question (by Steve Jones):
Can you store filestream containers on compressed volumes?
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: FILESTREAM.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
SQL Server 2012 T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server 2012. It provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on. Get your copy from Amazon today.
Yesterday's Question of the Day
(by Steve Jones):
I am working in Management Studio on a SQL Server 2012 instance. I want to execute SQLCMD using the IDE. How do I do this?
Answer: Select "SQLCMD Mode" from the Query menu
There is a SQLCMD mode built into Management studio.
This is an enhancement to the sp_helprevlogin stored procedure. As a DBA I'm always asked to grant access to an account based on another and it can be difficult at times.
This procedure takes in a login name, windows or SQL, and will generate the access and authorities for the login across the SQL instance. The script generates the user's login, any server roles the login may have, database access and database roles that have been granted, and any specific permissions granted on the database and authorities granted on objects. Everything gets outputed onto the message tab. The output can be copied into a query window and with a replace of the login id, access can be quickly granted to another user.
If the login name is not provided, an error will be generated
sql jobs issue
- Hi All,
SQL nightly jobs were hung because one of the users forgot to close the application or log off from...
?? on usiong a replace on an update
I'm looking to update a field
It currently has username@domain I want to update to domain\username
for example jsmith@company should be company\jsmith
recovery model simple
- Howdy Everybody,
My database is Simple (Recovery Model) and when i generated backup, the log file was to become big 30gb)......
SQL Query - same table - same row
- Hi Guys,
I'm hoping this is "possible" but my skills are failing me...
I have this query that works fine...
shipmentitems.orderid AS Ref,
Update SQL job step
- I need to add my email address on the failure steps on SQL agent....There are hundred of jobs setup and...
select vm.VoucherTypeCode,vm.VoucherNo,vm.VoucherDate,vm.Narration, vt.VoucherType
from VoucherMaster vm
left join VoucherDetail vd on vm.VoucherTypeCode = vd.VoucherTypeCode
left join VoucherType vt on vt.VoucherTypeCode = vt.VoucherTypeCode
- Okay, a topic that has NOTHING to do with SQL . . .
Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...
Today's Random Word!
When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.