Tag: SQL Server

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

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

11/26/2019 8:13:36 PM

SQL

SQL Server

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

Change SQL Server Default Database for a User

7/19/2016 9:55:38 PM

SQL Server

Bash/shell

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 Server: Run a Large Script File Against a Database and Import Data

12/18/2014 9:38:18 PM

SQL Server

Bash/shell

Command Prompt

sqlcmd

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

SQL Server Connection Strings

1/29/2014 8:21:04 PM

SQL Server

XML

ConnectionStrings

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

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

SQL Server to .NET Data Types

5/15/2013 2:41:53 PM

C#

SQL Server

Plain Text

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