Bulk-copy SQL Server Agent jobs to new server
The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…
Category: T-SQL
A Visual Explanation of SQL Joins
A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 596
Moving the TempDB database to a new drive
Often you will need to add or move the tempDB data files, either to match the core count (up to 8 as best…
Resolving “Cannot resolve collation conflict for equal to operation”
I recently had to run a query for one of our developers where the script was inserting a number of rows. All went…
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
T-SQL Querying and Query Processing Order
The order in which we write T-SQL queries happen in this order:
|
1 2 3 4 5 6 |
SELECT FROM WHERE GROUP BY HAVING ORDER BY |
however, the order the Query Processor on SQL Server processes…
How to identify IDENTITY columns tables in a database
Here is a nifty query that will display all the tables and columns set as IDENTITY in a given database:
|
1 2 3 4 5 6 7 8 9 10 11 |
USE AdventureWorks2012 GO SELECT OBJECT_NAME(object_id) AS 'table_name', name AS 'column_name', seed_value, increment_value, last_value, is_not_for_replication FROM sys.identity_columns ORDER BY 1 |
Views –…
SQL Server coding and naming conventions and best practices and guidelines
Here is a good blog post on SQL Server coding and naming conventions: Database coding conventions, best practices, programming guidelines Views – 1070
How to take a database offline
Here is one way to take a database offline. This will prevent any reads, writes or even a connection to it (including any…