Monday, December 30, 2013

Can we commit inner (or nested) transactions?– SS SLUG Dec 2013 – Brain Bashers - Demo IV

›
This post is related to the presentation “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This speaks about committing n...
Sunday, December 29, 2013

Best way to pass datetime values to SQL Server – SS SLUG Dec 2013 – Brain Bashers - Demo III

›
This post is related to the presentation “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This speaks about different wa...
Wednesday, December 25, 2013

How SQL Server interprets two-digit years as four-digit years – SS SLUG Dec 2013 – Brain Bashers - Demo II

›
This is based on the presentation titled “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This discusses the way SQL Ser...
Tuesday, December 24, 2013

Filtering DateTime values – SS SLUG Dec 2013 – SQL Brain Bashers - Demo I

›
This is based on the presentation titled “SQL Brain Bashers” I did at SQL Sever Sri Lanka User Group Meeting. This discusses a tricky (or er...
Monday, December 16, 2013

Finding pages (or physical location) of records: %%PHYSLOC%% and fn_PhysLocCracker

›
There are many instances which we need to find the physical location, specifically the page, related to a record. Good example could be find...
Sunday, November 24, 2013

Quick Note on SQL Server 2012 Licensing Cost

›
When it comes to purchasing Microsoft SQL Server, I know for a fact, many finds difficulty on selecting the edition and calculating the cost...
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...