SQL Server – Page 6 – LincolnBlog.net

Trace Flags for SQL Server 2012

Posted on 11/03/201401/10/2017 by Lincoln Bovee'

DRAFT Here is a lot of info about SQL Server Trace Flags and their usage: Links Finding out who dropped a table using…

About Trusted Foreign Key Contraints

Posted on 10/07/201410/07/2014 by Lincoln Bovee'

I will post some of my findings about trusted foreign keys and constants here since this has become a minor issue at work.…

SQL Server Audit: Resources

Posted on 10/01/201408/25/2015 by Lincoln Bovee'

I am doing some research on how to implement auditing of schema and security changes and will use this post to track notes…

Log won’t shrink in SIMPLE Recovery mode

Posted on 08/13/201401/21/2019 by Lincoln Bovee'

I recently had a situation where a database that was set to SIMPLE recovery mode had an ever-growing log file. I had tried…

Finding Suspect Pages

Posted on 07/30/2014 by Lincoln Bovee'

Here is where SQL Server stores any pages it has identified as suspect:

SELECT * 
FROM msdb.dbo.suspect_pages sp

1 2	SELECT * FROM msdb.dbo.suspect_pages sp

Views – 2246

Database Availability State Statuses

Posted on 07/11/2014 by Lincoln Bovee'

The possible values in the State and State_Desc columns of sys.databases are: 0 = ONLINE 1 = RESTORING 2 = RECOVERING 3 =…

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…

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, Linux and PostgreSQL etc…

Category: SQL Server