sql server{.chapter}

content

• Aggregate table strings into one csv value (with SQL Server)
• Backup restore script
• Basic data dictionary
• Bulk Comparison with Hashbytes
• Case Sensitive String Comparison
• Check if Column exists, or if constraint exists or if index exists (including spatial index)
• Collation: find it, compare it, change it
• Compare environments
• Convert a timestamp column to a varchar
• Count occurrences of string
• Create a role that gives a user permissions on a specific schema
• Create active directory user on SQL Server
• Create of alter for stored procedures and views etc
• Create Schema with Authorization
• Csv To Html function in SQL
• Delete duplicate rows
• Deleting millions of rows from SQL Server
• Ensure String Is an Integer
• Example query for bucketing up a bunch of values in SQL Server
• Find (and fix) large tables
• Find a foreign key by searching for the table or column from either end
• Find current sessions/users/who is locking
• Find missing indexes in sql server
• Find open transactions in SQL Server
• Find Tables or Columns by Name, and or Search all views functions or sprocs for a piece of text
• Find Whitespace in Object Names
• Finding unused indexes in sql server
• First (and last) day of the month
• Format DateTime as yyyy-MM-dd
• Format your queries
• Generate Change Script
• How do I Convert a Hex varchar to a Bigint in SQL Server? (solved)
• How much space does my DB use?
• How much space is left on the drives that my sql server can access?
• How to insert identity values into an identity column
• How to run sql queries, to CSV, in powershell, on the commandline
• How to use SQL Server Management Studio (SSMS) to access Windows authenticated databases across a VPN
• Import CSV using SSMS tools
• Index fragmentation and nasty page splits
• Indexing for Performance by Kimberly Tripp
• Info Message: Processing Info returned from SQL (in C#)
• Inline MIN
• List today and the last 7 days
• Log message immediately during a long running procedure
• Mismatch between estimated and actual number of rows returned in Execution Plan
• Need to delete backup files?
• Nums Table in SQL Server - a table of numbers
• Outer Apply can be very useful
• Parse varchar into DateTime
• Pivot reports with dynamic pivoted columns (by day)
• Prevent saving changes that require the table to be re-created
• R Services on SQL Server 2016+ (and Regular Expressions)
• Relative Dates
• Renaming a database - Simply - In Depth - SQL Server
• Run a command against each table
• Scalar Function in SQL that returns everything After a specified character
• Search the event log for sql server restarts with this powershell query
• See Wait Times in SQL Server
• Select top N where N is a variable
• Set a database to simple recovery model
• Sick of typing sp_heltpext ?
• Slow and long running queries
• Split string in SQL Server
• SSMS Dark Mode in SQL Server Management Studio
• Temporal Table feature in SQL Server
• Trailing Cr Lf
• Trim or zero-out a portion of a datetime
• Updating millions of rows from SQL Server
• Use Ctrl-E to execute your query
• Using Merge for upsert (update or insert)
• View statistics
• Weibull function
• What date was it on the most recent Monday (i.e. last Monday)?
• When was SQL Server restarted?
• Where does SSMS put queries before they've been saved?
• Windowed Functions in SQL Server
• WITH (common table expressions)
• Wrap an update in a transaction with this script template
• Xtype (in sysobjects)