Table Partitioning Implementation with advanced scenarios (Part 4)

Table Partitioning Implementation with advanced scenarios (Part 4)

 

 

 

 

 

 

 

 

Check the previous and next parts :Part1 part2,Part3 , Part4

Hi  guys today i will complete my series about Table Partitioning Implementation last Post I explained some important point and today i will complete another important subject

Points covered in the last post :

  • How to implement Table partitioning Step by step (RANGE LEFT)
  • Determining the Partition in Which a Particular Row is Stored (T-SQL Script)

Points will cover in this post :

  • Special Conditions for Partitions with advanced Cases
    • Merging two partitions of a partitioned table into one partition
    • Splitting a partition of a partitioned table or index into two partitions
    • NEXT USED (Alter Partition Schema)

Merging two partitions or Splitting a partition  this is meaning (ALTER PARTITION FUNCTION)

Merging two partitions of a partitioned table into one partition:

IF you wanted to remove a boundary instead.  Let’s say you have a boundary in use that is completely empty, and you want to stop using that partition, to free it up for some reason, then you want to use the MERGE operator. The syntax is just like SPLIT, except the boundary point you pass will be removed from your PARTITION FUNCTION

Note : Merge will not remove physical filegroup from the database structure, it just do merging of two different sets into one

so let’s go now to MERGE boundary ’2009-01-01′ o will work on the Example of RANGE RIGHT Please Check part 2 to know more about our example

Spread the word

Table Partitioning Implementation with advanced scenarios (Part 3)

Table Partitioning Implementation with advanced scenarios (Part 3)

 

 

 

 

 

 

 

 

 

Check the previous and next parts :Part1 part2,Part3, Part4

Hi  guys today i will complete my series about Table Partitioning Implementation last Post I explained some important point and today i will complete another important subject

Points covered in the last post :

  • Table partitioning dependence
  • How to implement Table partitioning Step by step (RANGE RIGHT)
  • How to monitor table partitioning by T-SQL Stored Procedure

Points will cover in this post :

  • How to implement Table partitioning Step by step (RANGE LEFT)
  • Determining the Partition in Which a Particular Row is Stored (T-SQL Script)

How to implement table partitioning step by step (RANGE RIGHT):

we will work on the same database i sued it in the part 2 [DBForPartitioning] DB

Range Direction LEFT and Datetime Boundary Values

  • Create partitioning function

in this case i will do partition function with boundary_value DATETIME and

Use DBForPartitioning
GO
CREATE PARTITION FUNCTION PF_DBForPartitioning_RangeLeft (datetime)
AS RANGE left FOR VALUES ( '2008-01-01','2009-01-01', '2010-01-01');
Spread the word

Table Partitioning Implementation with advanced scenarios (Part 2)

Table Partitioning Implementation with advanced scenarios (Part 2)

 

 

 

 

 

 

 

 

Check the previous and next parts :Part1 , part2 , Part3, Part4

Dwonlad Scripts used in this Part : 1-Basic Configuration

Hi  guys today i will complete my series about Table Partitioning Implementation Last post i explain the Concept of Table Partitioning and i covered the below points let’s go today to See How we can Implement Table Partitioning by T-SQL Step by Step with multiple scenarios

Points covered in the last post :

  • What is table partitioning?
  • Why we need to use table partitioning?
  • PROS and CONS of table partitioning?
  • Partitioned Table Rules and Gotchas
  • What is difference Table partitioning Type in SQL Server?

before going to the Technical demo we should know what is table partitioning dependence

Table5

PARTITION FUNCTION:

that maps the rows of a table or index into partitions based on the boundary_value , we can build the Partition Function by two ways based on our Requirement and our business needed

  • RANGE RIGHT
  • RANGE LEFT

another thing the boundary_value we can do it on three data type

  • INT COLUMN
  • DATETIME COLUMN
  • CHAR COLUMN

PARTITION SCHEME:

that maps the partitions of a partitioned table or index to filegroups , partition scheme must be created on partition function , partition scheme can be used for one or more partitioned tables, indexes, and indexed views.

PARTITION TABLE/INDEX:

is tied to a particular partition scheme when it is created , partition table has only an indirect relationship, through the partition scheme, to the partition function at the end The relationship between a partition function and a partition scheme is one-to-many as is the relationship between a partition scheme and partitioned tables and indexes , because moving data in and out of a partitioned table usually requires modifying the partition function for more information :

let’s go now for the TECHNICAL DEMO to know How we can implement the table partitioning step by step from Scratch

Spread the word

Table Partitioning Implementation with advanced scenarios (Part 1)

Table Partitioning Implementation with advanced scenarios (Part 1)

 

 

 

 

 

 

 

 

 

Check the next parts :part2 , Part3, Part4

HI …. Today I will write in very wonderful topic SQL Server Partitioning and my post will be as Repository for the beginner and for Expert because I will cover the main and most important point and the most cases can be happened by Partitioning , Partitioning Is big story with big history and no one can cover avery thing on it but i will do my best to cover the most important point in Table Partitioning.

Agenda and overview 

  • What is table partitioning?
  • Why we need to use table partitioning?
  • PROS and CONS of table partitioning?
  • Partitioned Table Rules and Gotchas
  • What is difference Table partitioning Type in SQL Server?
    • Vertical Partitioning
    • Horizontal Partitioning
  • How to Implement Partitioned Tables Step by Step With Multiple Scenario
    • Create File Group
    • Create partitioned Function (Range Right / Range Left)
    • Create partitioned Schema
    • Table Partitioned for new Table
    • Partitioned Existing table
    • Index Partitioned
  • Check partitioned Function and Schema using T-SQL
    • List all Partitions
    • get partition id with Partition Number
    • partitioned Columns
    • Partition table Detail
    • FileGroup Detail
  • Special Conditions for Partitions with advanced Cases
    • MERGE
    • Split
    • SWITCH OUT / SWITCH IN
  • Manage multiple partitions in multiple filegroups
  • Table partitioning  improvement in SQL Server 2014
  • Performance Benefits with Partitioning
  • References

What is table partitioning?

Concept of data Partitioing

Table partitioning consists in a technique adopted by some database management systems to deal with large databases. Instead of a single table storage location, they split your table in several files for quicker queries. If you have a table which will store large amounts of data (I mean REALLY large amounts, like millions of records) table partitioning will be a good option. Queries that access only a fraction of the data can run faster because there is less data to scan.

Spread the word

Secrets of SQL Server Execution plan (3/5)

Secrets of SQL Server Execution plan (3/5)


So for we have saw some limitations of execution plan, some alarming signs which tell us about the need for update statistics etc on my previous blogs. Now we will see how to analyse some more complex execution plans. As usual we will start with tip. It is always better to set the IO Statistics on while optimizing the query, which gives some clear picture about your query. While working with very big execution plan it will be little bit hard for us to check whether our indexes are used are not. for such situation just wright click anywhere on the plan and click “Show Execution Plan on XML” then you can use CTL+F to find any specific index. Also generating a XML plan has lot more benefits, such as memory fractions, parameters list used while optimization etc..

Also we should keep in mind the execution plan distributes the cost across the operators,  you may saw high number on Key lockups which require covering index. And you may saw warning symbol over hash match join etc.. which are all just instigators. There is no one rule fits all in query optimization which is the reason why we don’t have a query tuning robot yet.

planing

Now we will move further to analyse a query deeply.

Using AdventureWorks as an example, the Production.Production ListPriceHistory table maintains a running list of changes to product
price. To start with, we want to see what the execution plan looks like not using a derived table so, instead of a derived table, we’ll use a
subselect within the ON clause of the join to limit the data to only the latest versions of the ListPrice.


SELECT p.Name,
 p.ProductNumber,
 ph.ListPrice
FROM Production.Product p
 INNER JOIN Production.ProductListPriceHistory ph
 ON p.ProductID = ph.ProductID
 AND ph.StartDate = (SELECT TOP (1)
 ph2.StartDate
 FROM Production.ProductListPriceHistory ph2
 WHERE ph2.ProductID = p.ProductID
 ORDER BY ph2.StartDate DESC
 ) ;

fig6
Using AdventureWorks as an example, the Production.Production ListPriceHistory table maintains a running list of changes to product
price. To start with, we want to see what the execution plan looks like not using a derived table so, instead of a derived table, we’ll use a
sub select within the ON clause of the join to limit the data to only the latest versions of the ListPrice.

What appears to be a somewhat complicated query turns out to have a straightforward execution plan. Reading it in physical operator order, there are two Clustered Index Scans against Production.Product and Production.ProductListPriceHistory. These two data streams are combined using the Merge Join operator.

The Merge Join requires that both data inputs are ordered on the join key, in this case, ProductId. The data resulting from a clustered index is always retrieved in an ordered fashion, so no additional sort operation is required here.

Merge Joins create a worktable to complete the operation. The creation of a worktable adds a great deal of cost to the operation because it will mean writing data out to tempdb. However, the Merge Join operation will generally still be less costly than the use of a Hash Match join, which is the other choice the query optimizer can make to solve the same type of join.

The two data streams are then joined through a Nested Loops operator, to produce the final result. On my next blog we will travel to the next level to explore other operators on the execution plan. To read my previous post click the links below. Thanks your time on my blog

1 2 

Spread the word

Walk inside DMV Stacks (12/100)

Walk inside DMV Stacks (12/100)

 

 

 

 

 

 

 

 

By the last blog , I explained DMV stacks that are used often to configure mail profile and use it for mail notifications for different purposes either SQL Server alerts, jobs failures alerts …etc , now I will turn to very trickier subject which is backup and restore ,of course I am not gonna to write about backup policies or how to configure scheduled backups jobs , this is not our subject of discussions here coz I have talked about this subject before but my words here are about backup monitoring while and after backup/Restore executions as follows:

1-      How monitor backup/restore executions ..?

Simply you can find out if any backups or restore execution run on your DB server and moreover you can determine its start time, session ID (of course you can get more info about user , machine , backup tools ..etc ) , elapsed time, estimated remaining time ,percentage of completion and end time using the below script :

 
Spread the word

Create Clustered ColumnStore index for All tables

 

 

 

 

 

 

 

Problem :

we are working in big project SQL Server 2014 upgrade and SQL Server 2014 Performance this project our role to test the new feature in SQL Server 2014 from the performance wise so we decide  to deploy the new Enhancement in SQL Server 2014 (Clustered ColumnStore index ) CCI so i take backup from one database in my work environment and restored it again with prefix _2014 .

this new type of index to create it on the table this table should be no index on it so i drooped all the index from all the tables but the Problem now How can i create the Clustered columnstore index on all tables( tables supported CCI) by one Click.

Solution :

i do one script to create Clustered columnstore index on all supported tables and here the description of the Script

1- to create CCI on any table we have some limitations one of this limitations the data type of the Columns CCI not supported Some data type.

2- I inserted the data type not supported by CCI in temp Tables

</pre>
CREATE TABLE #CCI_DataType_Limitation ( DataType NVARCHAR(MAX) )
 INSERT INTO #CCI_DataType_Limitation
 VALUES ( 'text' ),
 ( 'timestamp' ),
 ( 'hierarchyid' ),
 ( 'Sql_variant' ),
 ( 'xml' ),
 ( 'geography' ),
 ( 'geometry' )
Select * from #CCI_DataType_Limitation
<pre>
Spread the word

New Permission in SQL Server 2014

New Permission in SQL Server 2014

 

 

 

 

 

 

 

Hi Dears as we know SQL Server 2014 come with more new features and more improvements in the Performance today we will take about the new Feature in SQL Server 2014 in particular in SQL Server security SQL Server 2014 come with three new permission really amazing permission it will help any DBA in his work to can grant simple permission in All Databases in the server in the minimum time this operation it will not take from him one second lets go for the scenario and for the DEMO.

in SQL 2012 and we can see 31 permission whereas SQL 2014 has 34 permissions. These permissions are listed under Server properties >  permissions tab.

New Permission in SQL Server 2014:

  1. CONNECT ANY DATABASE Permission.
  2. SELECT ALL USER Securables Permission.
  3. IMPERSONATE ANY LOGIN Permission.

New permisions

 

Spread the word

Breakthrough in SQL Server 2012 Security fixed by SQLServer 2014

Breakthrough in SQL Server 2012 Security fixed by SQLServer 2014

 

 

 

 

 

 

 

Hi dear we have big bug in SQL Server 2012 security this from my personal view it’s Breakthrough in SQL Server 2012 Security in SQL Server 2012 can the user IMPERSONATE another user and take his privilege and do what he need What !! what i am saying is fact in SQL Server 2012 but it’s fixed in SQL Sever 2014 let’s go for demo:

Open your SQL Server 2014 and open 2 sessions

First Session : Create sysadmin user and read user

1- Sysadmin user


USE [master]
GO
CREATE LOGIN [adminuser] WITH PASSWORD=N'admin', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER SERVER ROLE [sysadmin] ADD MEMBER [adminuser]
GO

2- Read user


USE [master]
GO
CREATE LOGIN [Readeruser] WITH PASSWORD=N'P@$$w0rd'
GO

Spread the word

How to Grant Show Plan Privilege

 

 

 

 

 

 

Showplan Privilege it’s granted for any one need to see the execution plane for SQL Server query to check the performance of the index or doing index analysis.

Grant Showplan for one user in one database  :


GRANT Showplan TO [DominName\username]

Grant Showplan for one user in All databases in one SQL instance:


<strong> EXEC sp_MSforeachdb N’IF EXISTS
(
SELECT 1 FROM sys.databases WHERE name = ”?”
AND Is_read_only <> 1
)
BEGIN
print ”Use [?]; GRANT Showplan TO [DominName\username]”
END’;</strong>

After the execution take the Print scripts and run it in another session.

to check the Source go here To See all my posts you can go here  View all my tips

Follow up us on

Facebook Page LinkedIn Group,Twitter,Networked Blogs,Facebook Group,Youtube Channel, 

Spread the word

How to check the last restart for the Server

How to check the last restart for the Server

 

 

 

 

 

 

Hi Dears i received request from the developers by the Staging DB was down yesterday evening, between 6:00 PM to 9:00 PM, can you please advice at this time to do Scientific investigation and troubleshooting so at this time you should check 2 point :

  1. Last SQL Server instance restart.
  2. Last DB server (windows services ) restart.

Last SQL Server Restart :

we can check it easily and by the Easiest ways (SQL Query)

SELECT sqlserver_start_time FROM sys.dm_os_sys_info
SELECT ‘Statistics since: ‘ + CAST(sqlserver_start_time AS VARCHAR) FROM sys.dm_os_sys_info
Server Restart
Spread the word

SQL Gulf#1 Memories and Excerpts (1/3)

SQL Gulf#1 Memories and Excerpts (1/3)

 

 

 

 

 

 

 

 

2 weeks passed since SQL Gulf #1 so far and we are still in conjunction with its cheerful memories , they are really memory stuck and we can never ever each single beautiful moments either with speakers or audience , indeed they were the energy of SQL Gulf #1 and could resurrect the event from the first moment till the last moment of the event therefore I am going to share with you sequential portfolios of SQL Gulf#1 memories along with the upcoming weeks to keep them memorized , also you can download now all presentations and demos of all speakers as below :

 Hugo Sessions

Satya Sessions

kamal Session

Omar Seession

Shehap Sessions

Spread the word

A Wonderful Weekend in Riyadh, for SQLGulf #1, at Alfaisal University

A Wonderful Weekend in Riyadh, for SQLGulf #1, at Alfaisal University

 

 

 

 

 

 

 

 

 

 

 

 


Thanks to the perseverance of SQL MVP Shehap El-Nagar’s invite last year, this brave man from the Saudi Ministry of Higher Education, managed to organise a great inaugural event.  After the longest visa request process in my life, and twice, since originally his goal was to host this event
in December 2013, it finally happened: – the 1st SQLGulf event held in Riyadh, K.S.A. this past Saturday at the beautiful new campus of AlFaisal University, Riyadh.
Spread the word

SQL Gulf #1 event at Riyadh on 30/8/2014 http://www.asysg.com.sa/sql/

SQL Gulf #1 event at Riyadh on 30/8/2014 http://www.asysg.com.sa/sql/

 

 

 

 

 

 

 

 

 

 

After long waiting time and eager passion of our audience and followers to see a real series of SQL Server events in the middle east to resurrect SQL Server love in the Gulf region we are much glad to unveiled about this new brand name of events “SQL Gulf “ which is indeed the power house of SQL Server Administration , development and BI for every .net developers , Database administrator and Analysts to fancy their knowledge capitals about SQL Server  through a variety of 10 interesting sessions leaded by Top notch experts from different countries worldwide Canada , UK, Jordan , India and Saudi Arabia..etc , SQL Gulf is coming first at Riyadh on Saturday 30/8/2014 at Al –Faisal University to be the first SQL Server 2014 in the middle east that will unveiled about SQL Server 2014 myths and legends and performance dreams of 10x-30x, your esteemed presence is really a pride for us so don’t wait more and go directly now to register at http://www.asysg.com.sa/sql/ 

http://sqlserver-performance-tuning.net/wp-includes/js/tinymce/plugins/wordpress/img/trans.gif

Spread the word

Auto Identity Column Value Jump Issue

Auto Identity Column Value Jump Issue

 

 

 

 

 

 

 

 

 

Issue Introduction 

SQL Server 2012 Version coming with bug SQL Server 2012 once it restarted the identity column jumped by 1000 or 10000 record based on the Column data type.if it is integer (int) data type, then jump value is 1000 and if big integer (bigint), then jump value is 10000 and this Special case only in SQL Server 2012 not in the last versions (2005,2008,2008R2) or in the new version (SQL Server 2014), and from point view of Microsoft this Feature rather than a bug and in many scenarios it would be helpful.but in our daily work not accept this Feature because this bug from my point view.

Spread the word

Configuring Copy Database Wizard

Configuring Copy Database Wizard

 

               

                                      

 

 

 

 

 

 

As we all are well known about the different techniques used to copy or move the databases from one location to another.

Let us now focus on a Copy Database Wizard type.

Prerequisites and Limitations for CDW:

  1. SQL Server Agent should be running on Destination instance (i.e., secondary server).
  2. Only User databases are allowed.
  3. SQL server edition should not be Express Edition.
  4. Databases in CDW should be in online state.

Using CDW we can Copy, Move, Upgrade Databases including different parameters like

  1. Stored procedures from Master Database
  2. SQL Server agent Jobs
  3. User Defined Error Messages
  4. Endpoints
  5. SSIS Packages
  6. Logins

Please let me illustrate the steps in order to Copy database from one instance to another.

Spread the word

Backup index in SQL Server with covering Special Cases

Backup index in SQL Server with covering Special Cases

 

 

 

 

 

 

 

 

Hello Dears Backup index in SQL Server with covering Special Cases , this the subject of my post of Today HOW ..? i think any one will read the subject he will say it is very easy definitely right it’s easy but here in my post i will cover Special Cases it’s easy but it’s take Time so let’s go to explain deeply the Problem and How we can solve it.

Problem :

Any DBA or DB Analyst do clean up for unused index from Production but HE/SHE should take backup from this index because may be this index after deleted it will affect potentially Negatively on the Database Performance so at this time you will need to return back one index or all index based on your case. so when you go to backup this index before delete it will take time for Manuel Solution and if you have 2 index in one table and other index in multiple tables it will be hard and it will eat your time.

Solution :

at this time we should have solution to cover all our cases in this point and it should be Automatically to can do it faster  with a good result so i searched more and more but didn’t found one Script cover all what i need only i found Script to backup all index Exist on all tables in Database. i take this Script and do Special Customization on it to Cover the below Special Cases and in the next update i will update the SP to can backup Multiple index Exist in Multiple databases.

Spread the word

Performance Improvements in SQL 2014(3/4)

Performance Improvements in SQL 2014(3/4)

Hi dears, so for we have seen about the incremental update statistics and index enhancement on our previous blog post.

Now we will see about, how SQL server 2014 can cache temp tables.  Before we move further into the subject, will see about temp tables in crisp. These are the tables created at the run time and  these tables are created within the “tempdb” database.  To identify a table as a Temporary Table within the SQL statement, prefix the table name with the “#” character. And also we should know one more fact the caching is not per procedure , the caching is per objects.

SQL Server 2014 has given us some room, by which if we make our temp table in a proper way the temp table can be cached. We will see how this is possible.

Click here to continue 

Spread the word

New SQL Server 2014 permissions chart is available

New SQL Server 2014 permissions chart is available

Hello My Followers as usual our Community share the new Subject and the new news so Today i need to say for ALL DBA don’t worry from the Security part you are working in Microsoft Product.

Microsoft created new chart for all New Permission in SQL Server 2014  It includes the 3 permissions that are new in SQL Server 2014. also you will find Poster for SQL Server 2012 Security Chart and Azure SQL Database Chart

Download the poster from here. Everyone should have this in their workplace.

Spread the word

Durable vs. Non-durable tables: In-Memory OLTP

Durable vs. Non-durable tables: In-Memory OLTP

Hello followers Today i will explain very important point Durable vs. Non-durable tables SQL Server 2014 when come for us with In-Memory  Feature come with 2 Kind of tables Durable and Non-durable tables The default one is Durable Table. One cool feature besides the durable in-memory tables, is the possibility to create non-durable in-memory tables. As you realize, you can get a lot of performance improvement with the in-memory solution, but what is the benefit with non-durable tables as the data will be lost in case of failure? Well, one option is to use non-durable in-memory tables as staging tables in your ETL solution as you don’t care about the staging data in case of a system crash. do you have Temporary data ? do you have data you are OK to lose the data due to SQL Server restart at this time you can think in Non-durable tables, 

Memory-Optimized-Table come with 2 option (DURABILITY = SCHEMA_AND_DATA) , (DURABILITY = SCHEMA_ONLY)

Durable Table          : DURABILITY = SCHEMA_AND_DATA

Non-durable tables :DURABILITY = SCHEMA_ONLY

Why would I want to use a non-durable in memory table?

These non-durable tables, are special case tables after the database engine is rebooted he table will be empty but this tables is great for filling  very very fast so this tables is very fantastic for  staging tables in data warehouses, logging tables,For production tables within an OLTP system these non-durable tables are a really bad idea. If you were to use non-durable tables in a production OLTP database, under most situations if the data was lost this would end up being a really bad idea because data would be lost when the SQL Server instance is rebooted.

Spread the word

SQL Server Restart Notification

SQL Server Restart Notification

 

 

 

 

 

 

Hi dears today we will explain How we can do Automatic notification for SQL Server Restart After the DB Server Restart Successfully and All Databases Returned and not in Recovery mode this we can say it as log or as notification to know what happened in your Server but for DB Server notification when Restart Start this another thing i am  not Cover it in this post i will Cover it in another Post

Today we don’t need for any tolls only SQL Server can do it by Small Configuration let’s Go for Demo to see How We can get SQL Server Restart Notification after Restart Success

 

  • Database Server Configuration 

EXEC sys.sp_configure N'Show Advanced Options', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'scan for startup procs', N'1'
GO
RECONFIGURE WITH OVERRIDE
GO

Spread the word

SQL Server 2012 Service Pack 2 (SP2) RTM has released.

SQL Server 2012 Service Pack 2 (SP2) RTM has released.

 

 

 

 

 

 

Hi Dears today i come with good news for all SQL Server DBA/DB Analyst and DB Developer Microsoft SQL Server team is pleased to announce the release of SQL Server 2012 Service Pack 2 (SP2).and the good thing here is this upgrade is free and doesn’t require an additional service contract.The Service Pack and Feature Pack updates are available for download on the Microsoft Download Center. This includes Slipstream installation packages that can be utilized with existing licenses to install (or upgrade to) new instances with SP2 pre-installed.

Microsoft® SQL Server® 2012 Service Pack 2 (SP2)

Microsoft® SQL Server® 2012 SP2 Feature Pack

SQL Server 2012 SP2 will release through other distribution channels (including Microsoft Update) by end of July 2014.The first Cumulative Update of SQL Server 2012 Service Pack 2 is scheduled to release end of July 2014. It will contain hotfixes that have been delivered in SQL Server 2012 Service Pack 1 Cumulative Update 10.

Bugs that are fixed in SQL Server 2012 Service Pack 2 :

Spread the word

What we Should know before going to upgrade to SQL Server 2014(4/4)

What we Should know before going to upgrade to SQL Server 2014(4/4)

 

 

 

 

 

 

Hello my Followers in the last previous post  i covered some points not supported in SQL Server 2014 in the new Technology and Feature Memory-Optimized-Table

  • Memory Optimized Table Dosen’t Support Table Without Non Clustered index or Primary Key
  • IDENTITY Feature not Supported in Memory-Optimized-Table
  • ANSI_PADDING OFF Not Supported in Memory-Optimized-Table
  • Memory-optimized tables Not Suuported as target of MERGE

and today we will Cover new points and limitation in SQL Server 2014 Memory Optimized Table

SQL Server 2014

Spread the word

Speak at SQL Saturday Cairo #321 at Microsoft smart village Egypt

Speak at SQL Saturday Cairo #321 at Microsoft smart village Egypt

 

 

 

 

 

 

 

I am travelling on next Monday to speak at SQL Saturday Cairo #321 at Microsoft smart village Egypt, I am going to talk 2 sessions about SQL Server 2014 performance dreams and T-SQL performance guiltiness for better DB stress powers , here below is more details about my sessions

http://sqlsaturday.com/321/schedule.aspx

Spread the word

Memory allocated for Memory-Optimized-Table in SQL Server 2014

Memory allocated for Memory-Optimized-Table in SQL Server 2014

 

 

 

 

 

 

 

Hi dears today i coming with small DMV but it’s very important for us to know the actually memory allocated for each memory optimized table in our SQL Server 2014 Database let’s go :

  • find allocated memory for one Memory-Optimized-Table 

select * from sys.dm_db_xtp_table_memory_stats
where object_id = object_id('dbo.students')

 

Spread the word