SQL Server 2014: In-Memory OLTP Optimized Tables
Salient features of In-Memory OLTP Optimized Tables.
SQL Server
Articles related to SQL Server, SQL Queries, Stored procedures, databases, etc..
SQL Server 2012 Configuration Manager in Windows 8
Launching the Configuration Manager of SQL Server 2012 or 2008 on Windows 8. Locating the sql server 2012 configuration manager.
Durable Table In SQL Server 2014 – Create Durable Table
What are Durable Tables? How to create durable table In SQL Server 2014? Durable Table is a kind of memory optimized table, which can handle In-Memory OLTP.
SQL Server 2014: Creating Table Optimized for In-Memory OLTP
How to create a table optimized for In-Memory OLTP to use the memory optimizations introduced in SQL Server 2014. Creating In-Memory OLTP table.
SQL Server 2014: Database Compatible for In-Memory OLTP
How to convert an existing SQL Server 2014 database compatible for In-Memory OLTP? Preparing In-Memory OLTP compatible database.
SQL Server 2014: Creating In-Memory OLTP Database
Creating an In-Memory OLTP Compatible Database in SQL Server 2014. Simple step by step instructions for creating a In-Memory OLTP Database.
SQL Server 2014 CTP1 is now available
SQL Server 2014 CTP1 is now available for the public to download. Ways to get SQL Server 2014 CTP1 for testing in your local computer.
SQL Server 2014: What can we expect?
What’s next? Microsoft SQL Server 2014? What can we expect from SQL Server 2014?
SQL Server: Does WITH (NOLOCK) increase performance?
Does with (nolock) increase performance in T-SQL Queries? Can you increase the performance of SQL queries by adding WITH NOLOCK? Lets find out.
Case Sensitive String Comparison on SQL Server
How to do a case sensitive string comparison on SQL Server using COLLATE. Case sensitive comparison in SQL Server 2008, SQL Server 2012, SQL Server 2014.
SQL Server Case Sensitive Search: Fetching lowercase or uppercase string
How to fetch lowercase or uppercase or mixed case, case sensitive string in SQL Server. Case sensitive search using select query. There are two simple ways .
count(*) or count (1) or count(”) Which is better in SQL server?
SQL Server: count(*) or count (1) or count(”) Which is better? Let’s do an experiment to find the better option among the count.
Does Index Improve SQL Server Query Performance?
Does Index Improve SQL Server Query Performance. Yes Index improves the SQL Server query performance to a large extend. Let’s do an experiment.
MSDB – What is msdb database?
MSDB – What is msdb database in sql server and what is it used for? Id this database important? Where is it located? Can we delete this database?
Fix for “unable to load client print control” Error
Steps to fix the error “unable to load client print control” received during printing reports SQL Reporting Services reports.
Clear Cache and Buffer of Stored Procedure in SQL Server
Professional way to clear cache and buffer of SQL Server Stored Procedure for performance testing without restarting the server or recreating the procedure.
SP_WHO and SP_WHO2
SP_WHO and SP_WHO2 – Brief description about Microsoft system stored procedures SP_WHO and SP_WHO2. SP_WHO vs SP_WHO2 which one to use when.
What is DBMS? What is RDBMS? DBMS vs RDBMS
What is DBMS? What is RDBMS? This article will give you a basic idea about SQL DBMS & RDBMS as wells as the difference between DBMS and RDBMS in tabular form.
What is SQL Server? How to get SQL Server?
Do you want to know about SQL Server and how to get it. Here is a brief article about SQL server. This article will provide you a basic understanding about SQL Server.
ASP.NET Caching with SqlCacheDependency
ASP.NET caching technology has various technique for specific caching requirements. SqlCacheDependency class is one among them.