T-SQL – LincolnBlog.net

Some database design guidelines and best practices

Posted on 01/29/201803/12/2018 by Lincoln Bovee'

Below are some best practices known within the SQL Server database community use when designing tables. 1. All data columns should be properly…

SQL documentation tools and permissions required

Posted on 01/25/201801/26/2018 by Lincoln Bovee'

Database documentation tools like Devarts’ dbDocumenter will require, at a minimum, VIEW DEFINITION rights to the login:

USE myDatabase
GO

GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup]

USE myDatabase

GRANT VIEW DEFINITION TO [DOMAIN\MyADGroup]

Views – 620

Bulk-copy SQL Server Agent jobs to new server

Posted on 03/23/201703/23/2017 by Lincoln Bovee'

The easiest way to bulk-copy all SQL Agent jobs to a new server is to follow these steps 1. Load SSMS and connect…

A Visual Explanation of SQL Joins

Posted on 06/20/201606/20/2016 by Lincoln Bovee'

A good blog-post on joins from a visual aspect. Nicely done. A Visual Explanation of SQL Joins Views – 1183

Moving the TempDB database to a new drive

Posted on 03/22/201609/16/2017 by Lincoln Bovee'

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”

Posted on 03/21/201605/10/2016 by Lincoln Bovee'

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

Posted on 10/28/201512/03/2015 by Lincoln Bovee'

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

Posted on 10/28/201502/12/2016 by Lincoln Bovee'

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

Posted on 06/23/201401/21/2019 by Lincoln Bovee'

The order in which we write T-SQL queries happen in this order:

SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY

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

Posted on 06/12/2014 by Lincoln Bovee'

Here is a nifty query that will display all the tables and columns set as IDENTITY in a given database:

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

USE AdventureWorks2012

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 –…

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

Category: T-SQL