Additional Articles

All authors

External Article

The Basics of Inserting Data into a SQL Server Table

Before data can be read from of a SQL Server database table, the table needs to contain rows of data. One of the most typical ways to get data into a table is to use the INSERT statement. One row or multiple rows can be inserted with a single execution of an INSERT statement. You can even use the output of a stored procedure to insert rows. In this article, I will explore the basics of inserting data into a SQL Server table using the INSERT statement.

2022-10-19

Technical Article

SQL Server Internals: Reading Pages

The I/O from an instance of the SQL Server Database Engine includes logical and physical reads. A logical read occurs every time the Database Engine requests a page from the buffer cache. If the page is not currently in the buffer cache, a physical read first copies the page from disk into the cache.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2022-10-17

External Article

Finding the Version of a Flyway-managed Database Using SQL

Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime, using just SQL. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. No more desultory quests, when dealing with support issues, or when bug fixing, to find which database version was running when the bug happened.

2022-10-14

All authors

Blogs

Simple Talks Episode 7

By

The season 1, seventh episode of Simple Talks is out. Check it out, with...

A New Word: the McFly effect

By

the McFly Effect – n. the phenomenon of observing your parents interact with people...

Key mappings in Visual Studio Code

By

At a recent conference I was asked how I executed code during my presentation....

Read the latest Blogs

Forums

SSMS V20 encryption  vs  SQL Server SSL Encryption

By tonytiger5812

I assume SSMS V20 encryption and SQL Server SSL encryption are different. I have...

Enable a Disabled Index

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Enable a Disabled Index

Diving Deeper into the Import Extension in Azure Data Studio

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Diving Deeper into the Import...

Visit the forum

Question of the Day

Enable a Disabled Index

I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?

See possible answers