Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

Count_Big() function

Learned new function for count while going through the channel 9 video for salva. where for a very big table...

SQL in the City is coming Feb 28

The next edition of the SQL in the City broadcast is coming Feb 28, and I’m planning travel now to...

WIT: A Quick Thought

I recently had the opportunity to be a Dungeon Master (DM) at a gaming convention. It was my first time....

What’s dbo?

Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...

Learn Different Options for Importing Data Into SQL Server

Most of the time users need to import their data into SQL Server for its proper management. Select from the...

Perfecting my presentations

After a considerable amount of “umming and ahhing” last year I decided to start presenting full hour long sessions. Well,...

What is VMware vSAN?

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

Introduction to System-versioned temporal tables – New database feature of SQL Server 2016

System-versioned temporal tables is new database feature of SQL Server 2016. Another improved version of table level auditing with some...

Object Explorer Details (Day 21)

The Object Explorer Details windows (from the View menu, or the keyboard shortcut F7) displays detail information about the objects...