SQL Server Execution Plan formats
Execution plan helps in knowing how a query gets executed and troubleshooting a query which is performing poor. In SQL...
2016-09-14
842 reads
Kapil Blogs
Importance of Database Backup In SQL Server
Overview To save any organisation from any big future loss, one needs make a proper strategy or disaster plan that...
2016-09-01
482 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Sp_rename not allowed
Hi friends, one more limitation of In-Memory OLTP is SQL Server 2016 is that sp_rename is not allowed to change...
2016-07-21
495 reads
Getting started with In Memory OLTP in SQL Server 2016 – Part 1
In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP...
2016-07-18
695 reads
Limitation of In-Memory OLTP in SQL 2016 – Create Index is not supported
Hi friends, in this blog I will discuss another limitation of In Memory OLTP in SQL Server 2016. Once you...
2016-07-17
462 reads
SQL Server – How to retrieve SQL plans from Cache
Hi friends, in this blog post I will tell you how we can retrieve the SQL plan from the cache....
2016-07-13
647 reads
SQL Server – String_Escape function in SQL Server 2016
Hi friends, in SQL server 2016 another string function that introduced is String_Escape. This function can escape special characters within...
2016-07-10
1,510 reads
Microsoft SQL Server 2016 Certifications Announced
Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s...
2016-07-08
797 reads
SQL Server – STRING_SPLIT function in SQL Server 2016
Hi friends, in SQL server 2016 another new function STRING_SPLIT gets introduced which helps in splitting the character expression using...
2016-07-06
703 reads
SQL Server – Rollback transaction completely in case of error
Hi friends, I recently found an issue while inserting data into table during transactions that transaction will not completely rollback...
2016-05-26
654 reads
Blogs
Build Recovery into the Design
By Brian Kelley
It's like disaster recovery (and business continuity) planning is the end-of-term research paper that...
Want to Supercharge Your Business? SQL is Your Secret Weapon.
Look, we all know data is king these days. But having mountains of data...
What do client diagnostics in Cosmos DB mean?
This topic keeps coming up with my customers so the purpose of this blog...
Forums
how to send emails on Azure PAS server
Hi, how to send emails on Azure Hyperscale server and which sp we...
service is not available
I was trying to access SSRS report in host server browser , throwing an...
FIFO and manufacturing ... how do I get the current cost?
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
Question of the Day
Starting to Estimate Disk Storage for Memory-Optimized Tables
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers