Table-valued parameters are a new feature introduced in SQL Server 2008. They provide a built-in way to send multiple rows of data from a client application to SQL Server in a single parameterized SQL ...

I have a need to compare multiple different versions of essentially the same SQL Server 2005+ databases and bring the table structures up to that which is in the newest version. It should compare ...

In SQL Server 2014 there were a number of restrictions on memory-optimized tables: you couldn't alter their structure after they were created; many SQL operators weren't supported (Outer Joins, ...

How to Describe Table in SQL Server. One of the essential tasks when working with SQL Server tables is the ability to describe them. You can use the sp_help command to get information about a table’s ...

Introduction: Hello everyone! Welcome back to my channel! In today's video, we’re going to learn how to visualize and query a hierarchical employee structure within a SQL Server database. This is ...

Reading the designated SQL server schema and preparing a list of tableschema objects that contain the schema for each and every SQL server table (and associated structures like indexes). Preparing an ...

Hekaton is a new database engine optimized for memory resident data and OLTP workloads. Hekaton is fully integrated into SQL Server; it is not a separate system. To take advantage of Hekaton, a user ...