THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Kalen Delaney

Geek City: Q&A


I’ve done it again… I’ve neglected my blog so long that my name has been removed from the list of SQLBlog contributors on the right-hand side of the main page.  So I need to fix that.

I have been accumulating a list of questions that have come up during my 5-day SQL Server Internals classes, that I cannot immediately answer. Sometimes I can figure out the answer myself with just a bit of research or a simple test, and sometimes I can ask one of my Microsoft contacts for help. (Other times, I actually know the answer, but I just space out on it when asked, after being on my feet talking for 5 straight days. Smile )

I kept hoping that I would eventually get answers to ALL the questions on the list, but I realized I should wait to post what I have. And that will get me back up on this blog site.


1. Can memory-optimized tables use BPE (Buffer Pool Extensions)

No, BPE is only for data read from disk and stored in memory buffers. Memory optimized tables do not use pages or buffers.


2. What if a plan guide references a table that is specified in a query without a schema name, and there are two different tables, in different schemas, with the same name?

For a plan guide of type ‘SQL’, all that matters is the TSQL-statement that is included in the plan guide. The same plan guide could be invoked when accessing different tables with the same name.


3. Why does the Native Compilation Advisor complain about the EXEC command?

In SQL Server 2014, EXEC is never allowed in Natively Compiled Procedures. In SQL Server 2016, we can EXEC a Natively Compiled Procedure or function from within a Natively Compiled Procedure, but we can’t EXEC a non-native module, and we can never EXEC a string.

4. Can we replicate a memory-optimized table?

Memory-optimized tables can be subscribers for transactional replication, but that is the only supported configuration. See this MSDN page for more details:


5. Does auditing work on memory-optimized tables?


6.  Are the values in sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats reset when an index is rebuilt?

YES, just as if you had restarted your SQL Server Service.


7. When do I need to use the option ‘scan for startup procs’?

This configuration option is related to the procedure sp_procoption, that allows you to mark a stored procedure as a ‘startup’ procedure, to be executed every time your SQL Server service starts. However, the configuration option to tell SQL Server to scan for these procedures doesn’t see too useful.  When the first procedure is marked for startup, this option is turned on automatically, and when the last one is unmarked, it is turned off. So there is really no need for the configuration option, unless you suspect a problem and want to inhibit the startup procedures.


8. When are SQL Trace and the SQL Profiler going away?

They’re still available in SQL Server 2016 CTP 2.4, so I assume they will still be in SQL Server 2016 RTM. After that, I think no one knows yet.


That’s all I’ve got for now.


Published Thursday, October 15, 2015 3:57 PM by Kalen Delaney

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



D. Michael said:

So, you don't want to give up that sidebar space to someone else who's actually blogging, eh?

See you in another three months, I suppose.

October 15, 2015 6:05 PM

Kalen Delaney said:

Thanks for your input D. Michael. A blog post is not like a tweet, which is very ephemeral. There is some content I posted years ago, that I still get comments about and that is still referred to by others. Having my name in this list confirms that this is my blog's home.  And of course, I don't always go 3 months between posts. How often do you think is often enough to actually be said to be blogging? Is one little trivial post a week better than a very technical post every couple of months? I could start treating my blog like FaceBook. Would I be blogging then?

October 15, 2015 6:46 PM

RichB said:

I think you should definitely blog about blogging.  

October 15, 2015 9:46 PM

Anonymous said:

I'm glad we have the three month expiration thing because it means that you WILL blog :-)

Speaking of which, I'm not currently listed either. Tough to keep up with these things and do our day jobs and live our lives, all at the same time!

October 16, 2015 10:38 AM

zzyytt said:">">">">

May 1, 2018 7:07 PM

dongdong8 said:



June 29, 2018 3:28 AM

Yeezy 500 said:

yeezy v 2の販売,환상 판매,La vendita Yeezy V2,Yeezy V2 de vente,En el mercado yeezy V2. Yeezysupply Yeezys For Sale Yeezys Boost 350 V2 Yeezys Boost 350 Yeezy Cream Yeezy Boost Yeezy 750 Boost Yeezy 750 Yeezy 700 Yeezy 500 Yeezy 350 V2 Yeezy 350 Boost V2 Yeezy 350 Boost Yeezy 350 Yeezy 2018 Yeezy White Yeezys White Yeezy Where To Buy Yeezys Ultra Boost Adidas Ultra Boost 4.0 Ultra Boost Supreme Yeezy Real Yeezys Cheap Yeezy Adidas Yeezys Adidas Yeezy V2 Adidas Yeezy Shoes Adidas Yeezy Boost 350 V2 Zebra Adidas Yeezy Boost 350 V2 Adidas Yeezy Boost 350 Adidas Yeezy Boost Adidas Yeezy Blue Tint Adidas Yeezy 350 Adidas Yeezy Adidas V2 Adidas Us Adidas UltraBoost Adidas Ultra Boost Men Adidas Ultra Boost Adidas 500 Adidas Yeezys Adidas Yeezy V2 Adidas Yeezy Adidas V2 Adidas UltraBoost Adidas Ultra Boost Men Adidas Ultra Boost Yeezy V2 Boost Yeezy V2 Yeezy Boost V2 Yeezy 350 V2 Yeezy 350 Boost V2 New Yeezy V2 Adidas Yeezy V2 Adidas V2 Yeezy V2 Boost Yeezy V2 Yeezy For Sale Yeezy Cream Yeezy Boost V2 Yeezy Boost 750 Yeezy Boost 700 Yeezy Blue Tint Yeezy Blue Yeezy Beluga 2.0 Yeezy Beluga Yeezy Adidas Yeezy 2018 Yeezy White Yeezys White Yeezy Where To Buy Yeezys Ultra Boost Adidas Ultra Boost 4.0 Ultra Boost Supreme Yeezy Zebra Yeezys Zebra Yeezy Yellow Yeezy Yeezys Boost 350 V2 Yeezys Boost 350 Yeezys Adidas Yeezys Yeezy'S Yeezys Yeezy Zebra Yeezy Yellow Yeezys Boost 350 V2 Yeezys Boost 350 Yeezy V2 Boost Yeezy V2 Yeezy Boost V2 Yeezy Boost 750 Yeezy Boost 700 Yeezy Boost 350 V2 Yeezy Boost 350 Yeezy Boost Yeezy Beluga Supreme Yeezy New Yeezy V2 Adidas Yeezys Adidas Yeezy V2 Adidas Yeezy 350 Adidas Yeezy Adidas V2 New Yeezys New Yeezy V2 New Yeezy Cheap Yeezy Blue Tint Yeezy Black Yeezys Black Yeezy Beluga Yeezy Uk Moncler Coat Uk Moncler Moncler Uk Online Moncler Uk Moncler Uk Outlet Moncler Uk Moncler Jacket Outlets Moncler Jacket Moncler Uk Jackets Moncler Jackets Goose Down Jackets Canada Goose Uk Nfl Jerseys Nfl Jersey Cheap Nfl Jersey Nfl Jersey Cheap Nfl Jersey Nfl Cheap Jerseys Cheap Nfl Jerseys Cheap Nfl Jersey Nhl Jerseys 2018 Nfl Jerseys For Sale Nfl Jerseys Cheap Nba Jerseys Cheap Nba Jerseys 2018 Nba Jerseys Cheap Jerseys Cheap Jersey 2018 Us Cheap China Jerseys Air Max 2018 2018 Nike Air Max 2018 Air Max Nike Vapormax Nike Air Vapor Max Vapormax Vapor Max Nike Vapor Max Vapormax 2018 Vapormax Vapor Max Nike Vapor Max 2018 Worldcup 2018 World Cup Soccer 2018 World Cup Russia 2018 World Cup Russia World Cup Football 2018 World Cup Football World Cup 2018 Warriors Jersey Nba Warriors Golden State Warriors Michael Kors Factory Sale Michael Kors bags Michael Kors Jordan Air Cheap Jordan Shoes Air Jordan Shoes Air Jordan Asics Shoes Asics Cheap Fitflop Fitflop Clearance Fitflop Sale Clearance Discount Fitflop Fitflop Outlet Fitflop Clearance Outlet Clearance Fitflop Cheap Pandora Charms Pandora Charms Sale Clearance Pandora Charms Wholesale Pandora Jewellery Pandora Wholesale Pandora Jewellery Wholesale Pandora Jewelry Pandora Outlet Pandora Charms Outlet Pandora Rings Pandora Bracelets Canada Goose Canada Goose UK Down Jackets For Women Canada Goose UK Jacket Canada Goose Jacket UK Canada Goose Jacket

July 9, 2018 5:59 AM

linying123 said:


July 16, 2018 8:40 PM

dongdong8 said:



July 23, 2018 11:45 PM

Yeezy Supply said: Jordan 11 Win Like 82 Nike Outlet Store Nike Outlet Store Yeezy Yeezy Moncler UK Yeezy Boost 350 Yeezy Boost 350 V2 Birkenstock Oakley Outlet Nike Outlet Online"> nike clearance Off White Jordan 1 Nike Air Max Yeezy Boost 350 Air Max 97 jordan 12 bordeaux Yeezys Nike Shoes Nike Outlet Air Max 2017 Moncler Jackets Yeezy Boost 350 V2 Jordan 12 Win Like 82 Jordan 11 Win Like 82 jordan 4 Nike Clearance Moncler UK Yeezy Nike Outlet Store Online Shoping Birkenstock Shoes jordan 12 ovo Nike Air Max 2017

July 24, 2018 8:26 PM

obat diabetes said:

August 1, 2018 11:15 PM

obat bronkitis anak secara alami said:

August 7, 2018 7:48 PM

obat sinusitis said:

August 10, 2018 7:21 PM

yaoxuemei said:


August 15, 2018 2:03 AM

qqq said:


August 15, 2018 11:38 PM

masker wajah alami untuk menghilangkan jerawat said: Masker wajah alami untuk menghilangkan jerawat Obat liver alami aman dan terbaik Obat herbal sinusitis kronis terbaik Obat bronkitis anak secara alami Obat Kanker Payudara terbaru 2018 Cara meningkatkan nafsu makan secara alami Obat herbal diabetes menurunkan gula darah Obat herbal kusta terbaik Obat benjolan di leher tanpa operasi Obat Herbal Kanker Otak tuntas hingga akar Obat TBC alami aman tanpa efek samping Obat radang amandel sembuh tanpa operasi Obat asam urat alami tanpa efek sampinfg Obat tetes Sariawan secara alami Cara mengobati mata bengkak dengan cepat Obat tradisional kanker lambung terbaik Obat kanker paru paru Obat usus buntu alami tanpa operasi Obat asam lambung naik cara alami

August 20, 2018 8:57 PM

chenjinyan said:


August 22, 2018 11:03 PM

shenyuhang said:


August 23, 2018 10:17 PM

obat herbal koresterol terbaik said:

August 23, 2018 10:56 PM

obat usus buntu alami tanpa operasi said:

August 24, 2018 12:19 AM

obat benjolan di tubuh said:

August 30, 2018 7:39 PM

obat wasir said:

September 4, 2018 8:25 PM

obat katarak said:

September 16, 2018 5:45 PM

obat maag said:

September 17, 2018 7:09 PM

chenlixiang said:



September 18, 2018 9:48 PM

kakakaoo said:

October 8, 2018 2:30 AM

chenjinyan said:



October 9, 2018 6:46 PM

chenqiuying said:


October 10, 2018 6:09 PM

great said:

October 17, 2018 11:59 PM

kakakaoo said:">


November 8, 2018 2:10 AM

dfvneoirnve said:

November 27, 2018 9:00 PM

qqq said:


March 27, 2019 12:59 AM

Leave a Comment


This Blog


Favorite Non-technical Sites or Blogs

Privacy Statement