LincolnBlog.net – Page 8 – …my observations in the world of SQL Server, PowerShell, Linux and PostgreSQL etc…

SQL Server Video Training

Posted on 06/26/201406/26/2014 by Lincoln Bovee'

Here are a few links that provide video training on SQL Server. PluralSight is very well known for it’s quality videos. However there…

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

SQL Server Index Design Best Practices

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

This post is consisted of mostly direct quotes from the article posted at the bottom of the page. I put them here to…

Primary Key Best Practices

Posted on 06/02/2014 by Lincoln Bovee'

I follow a few rules: 1. Primary keys should be as small as necessary. Prefer a numeric type because numeric types are stored…

SQL Server coding and naming conventions and best practices and guidelines

Posted on 05/30/2014 by Lincoln Bovee'

Here is a good blog post on SQL Server coding and naming conventions: Database coding conventions, best practices, programming guidelines Views – 2978

Finding Deprecated Command Usage via Traces and Extended Events

Posted on 05/30/201401/21/2019 by Lincoln Bovee'

Below is my posting on dealing with upgrading your SQL Server to either 2012 or 2014 and having to deal with databases that…

Reseeding and Updating the INDENT_CURRENT Value in SQL Server

Posted on 05/09/201412/06/2016 by Lincoln Bovee'

This code will do the following: 1. Display the current INDENT_CURRENT value for the identity column for the specified table. This value should…

Syncing SQL logins and database user accounts across servers with SIDs

Posted on 04/22/201401/21/2019 by Lincoln Bovee'

Here is a good article on syncing SQL logins across servers with the same SIDS to log-shipped databases will propagate the correct access…

How to take a database offline

Posted on 04/21/201404/21/2014 by Lincoln Bovee'

Here is one way to take a database offline. This will prevent any reads, writes or even a connection to it (including any…