Tag: SQL

Code Rules: SQL: Only Use Table Aliases if They Increase Clarity

12/13/2023 6:45:11 PM

SQL

Code Rules

SQL: List Sizes and Row Counts of All Tables in a Database

12/7/2022 4:23:04 AM

SQL

SQL: Join First Table On the Top 1 Row of Second Table For Each Unique Id Using CROSS APPLY and OUTER APPLY Instead of INNER JOIN and LEFT JOIN

12/5/2022 10:17:07 PM

SQL

SQL Server

SQL: List All Tables and Get Count of Columns Within Each Table

12/17/2021 7:16:22 PM

SQL

SQL Server

MySQL: Determine the Size of Each Database on a Server

2/15/2021 8:06:23 PM

SQL

MySQL

MySQL: Determine the Size of Each Table in a Database

2/15/2021 8:04:56 PM

SQL

MySQL

SQL: Check For Temp Table and Drop Temp Table If It Exists

11/26/2019 8:13:36 PM

SQL

SQL Server

SQL: Give ALTER SCHEMA Permissions to a User

5/9/2018 9:08:17 PM

SQL

ALTER SCHEMA

Drop Table

SQL: Check if Table Exists and Drop if it Does

5/9/2018 9:06:41 PM

SQL

Recreate All Views in a Database with a SQL Query

6/26/2017 6:23:50 PM

SQL

SQL Views

Add Column to Table Using SQL

6/26/2017 6:22:18 PM

SQL

SQL Server: List all Users and Roles

10/19/2016 7:35:13 PM

SQL

SQL Server

SQL Server: Find Orphaned or Missing Users Between Server and Database

8/4/2016 7:17:22 PM

SQL

SQL Server

SQL: Search Recently Run Cached SQL Statements

5/2/2016 2:44:01 PM

SQL

Simple SQL Row_Number Example

2/9/2016 8:36:24 PM

SQL

ROW_NUMBER

SQL Paginate

SQL JOIN on Sub Query and Only the First Row

1/27/2016 11:48:30 PM

SQL

SQL JOIN

SQL Sub Query

SQL: Create SQL Server Trigger

9/7/2015 8:55:01 PM

SQL

SQL Trigger

SQL: Change the Collation of a Table Column to Case Insensitive or Case Sensitive

7/15/2015 8:39:17 PM

SQL

SQL Collation

SSRS: Show Row Count in SSRS Label

7/8/2015 2:17:15 PM

SQL

SSRS

SQL: Alter a Column in a SQL Server Table

6/29/2015 2:51:53 PM

SQL

SQL: Search All Stored Procedures and Functions for Certain Text

6/24/2015 2:59:01 PM

SQL

SQL: SQL Server ROW_NUMBER Using PARTITION to Group Row Numbers

5/19/2015 3:08:59 PM

SQL

SQL Server

SQL ROW_NUMBER

SQL: Simple SQL Server Cursor

5/19/2015 2:55:09 PM

SQL

SQL Server

SQL Cursor

SQL: Create a SQL Index

4/30/2015 5:52:58 PM

SQL

Indexes

SQL: Add an Identity Column to an Existing Database Table

4/21/2015 3:40:32 PM

SQL

Drupal: Create/Recreate the media_filter_usage Table

1/8/2015 12:37:36 AM

SQL

Drupal

Create SQL Server Index

10/7/2014 9:41:46 PM

SQL

Indexes

Alter SQL Table Column

7/22/2014 2:18:49 PM

SQL

SQL: Create Rerunnable Script to Insert Default Data Into a Table

5/14/2014 2:54:45 AM

SQL

SQL Scripts

SQL: Show Row Record Counts or List Rows With Duplicates

5/7/2014 7:21:41 PM

SQL

SQL Server

List SQL Server Table Columns and Data Types

5/5/2014 1:40:34 PM

SQL

SQL Server

Get Size of Tables in SQL Server

12/10/2013 5:57:16 PM

SQL

SQL Server

SQL Server Rebuild, Recreated, Reindex Table Indexes

12/10/2013 5:48:18 PM

SQL

SQL Server

Indexes

SQL Server Case Statement in SELECT Clause

12/4/2013 3:13:59 PM

SQL

Query

Stored Procedure

Reseed the Identity Value on a SQL Server Table

12/3/2013 1:35:24 AM

SQL

SQL Server

Shrink a SQL Server Database Log

7/7/2013 5:05:14 PM

SQL

SQL Server

Create FULLTEXT Catalog and Index in SQL Server

5/19/2013 7:57:38 PM

SQL

SQL Server

FullText Search

MySQL - Change Collation and Character Set

4/5/2013 12:45:18 AM

SQL

MySQL

PDO

PHP

SQL Server: Take Database Offline and Online

3/20/2013 12:00:22 AM

SQL

Rename SQL Server Filenames on Disk

3/18/2013 1:39:44 AM

SQL

SQL Server

Backup SQL Server Database Log

1/25/2013 1:27:07 PM

SQL

SQL Server

List Size of Database Tables

1/25/2013 12:57:38 PM

SQL

SQL Server