Friday, October 18, 2013

In-Memory OLTP: Inserting 3 millions records in 3 seconds

›
One of the sessions we delivered with SQL Server Sri Lanka User Group Meeting – October 2013 was related to SQL Server 2014: In-Memory OLTP....
1 comment:
Thursday, October 17, 2013

SQL Server 2014 CTP1: Error 41342 - The model of the processor on the system does not support creating filegroups with MEMORY_OPTIMIZED_DATA….

›
You might have already faced for this, or you will be, if you try to create a file group for your in-memory optimized tables. The reason for...
Wednesday, October 16, 2013

SQL Server 2014 CTP2 is available for downloading

›
SQL Server 2014 CTP2 is available for downloading; http://technet.microsoft.com/en-us/evalcenter/dn205290.aspx Few important things to r...
Sunday, October 6, 2013

SQL Server 2008 R2 Error: Login failed for user ''. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

›
I started experiencing above error with my SQL Server 2008 R2 instance when trying to connect and spent about 2 hours for sorting it out. It...
Saturday, October 5, 2013

Indexing with SQL Server – SS SLUG Aug 2013 - Presentation

›
Here is the presentation used for discussing SQL Server indexing. This discusses index structures, storage patters and different implemen...

What is Columnstore Index - SS SLUG Aug 2013 – Demo V

›
If you have worked with large databases (or data warehouses), you have already seen enough of scenarios where you do not get much benefits o...
Wednesday, October 2, 2013

Analysis Services - Backup and restore errors: File '.abf' specified in Restore command is damaged or is not an AS backup file. The following system error occurred: Access is denied. (Microsoft SQL Server 2008 R2 Analysis Services)

›
If you experience this error when an SQL Server Analysis Services backup is restored, most probably the reason is Analysis Services – Servic...
Sunday, September 29, 2013

Understanding Indexed Views - SS SLUG Aug 2013 – Demo IV

›
Here is another post on a demo did at Aug meet-up. This post speaks about Indexed Views. As the name says, views can be made as Indexed Vi...
Tuesday, August 27, 2013

Understanding Index INCLUDED COLUMNS - SS SLUG Aug 2013 – Demo III

›
Indexes are added mostly based on WHERE conditions used with queries execute frequently. Once the index is added, it speeds up the search on...
Sunday, August 25, 2013

Using GUID column as Clustered Index Key– SS SLUG Aug 2013 – Demo II

›
GUIDs are commonly used in distributed applications which require “uniqueness” across the entire world. Unfortunately I have seen the usage ...
Saturday, August 24, 2013

Understanding Index Fragmentation – SS SLUG Aug 2013 – Demo I

›
Index fragmentation is something we need to monitor frequently specifically on databases that are heavily indexed. If indexes added are frag...
2 comments: