Skip to content

LincolnBlog.net

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

  • Home
  • SQL Server
    • Administration
    • Diagnostics
    • Performance
    • Security
    • T-SQL
    • Tools
  • PowerShell
    • Remoting
    • Tools
  • Linux
  • .Net Development
    • Visual Studio
    • C#
    • MVC
    • ASP.NET
  • Servers
    • IIS
    • SharePoint
    • Hyper-V
    • MSMQ
  • Windows

Category: Design

About Collations in SQL Server

Posted on 04/10/201904/24/2019 by Lincoln Bovee'

This post will be fore the purpose of documenting all my findings regarding Collations in SQL Server, including changing the collation on an…

Read More

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…

Read More

Why using GUIDs as Primary Keys on a Clustered Index (Table) is not a good idea and some alternative approaches

Posted on 12/11/201505/23/2018 by Lincoln Bovee'

Here is a great blog post by Kimberly Tripp on why using GUIDs as a PRIMARY KEY on a CLUSTERED index is a…

Read More

Why use of VARCHAR(MAX) should be avoided

Posted on 11/09/2015 by Lincoln Bovee'

Here is a good blog post on a comparison of VARCHAR(MAX) versus VARCHAR(N): Performance comparison of varchar(max) vs. varchar(N) Views – 1680

Read More

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…

Read More

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…

Read More

Recent Posts

  • About TempDB and the Version Store 07/16/2019
  • Using PowerShell to Failover Availability Groups and WFC Cluster Nodes 05/21/2019
  • About Availability Groups Database Seeding 04/19/2019
  • About Collations in SQL Server 04/10/2019
  • PostgreSQL vs. SQL Server Notes 02/13/2019
  • Restoring a database using STOPATMARK 01/11/2019
  • Availability Groups: Things to remember 12/07/2018
  • Properly Taking a Cluster Offline for Disk Maintenance 08/14/2018
  • Building an AlwaysOn Availability Group SQL Cluster 03/07/2018
  • Some database design guidelines and best practices 01/29/2018

RSS Paul Randal’s Blog

  • The Curious Case of… eager writing and minimally-logged operations 04/12/2022 Paul Randal
  • The Curious Case of… random failing log shipping restores 03/09/2022 Paul Randal
  • The Curious Case of… data compression caching 02/07/2022 Paul Randal
  • The Curious Case of… tracking page compression success rates 01/12/2022 Paul Randal
  • Crazy, crazy end-of-year sale! 12/01/2021 Paul Randal

RSS Brent Ozar’s Blog

  • [Video] 300-Level Guide to Career Internals at SQLBits 08/18/2022 Brent Ozar
  • [Video] Office Hours at the End of the World 08/17/2022 Brent Ozar
  • Download the Current Stack Overflow Database for Free (2022-06) 08/16/2022 Brent Ozar
  • [Video] Office Hours: Speed Round Edition 08/11/2022 Brent Ozar

RSS Richard Siddaway’s PowerShell Blog

  • Time for cube calculation 01/29/2020
  • Spheres 01/29/2020
  • Recent releases 01/28/2020
  • Circles 01/28/2020
  • VScode improvement 12/31/2019

RSS SQLBlog.com Posts

RSS MSN PowerShell Blog

  • Archive Module 2.0 Preview 2 08/10/2022 Sydney Smith
  • Announcing the release of Get-WhatsNew 08/08/2022 Jason Helmick
  • PowerShell Extension for Visual Studio Code July 2022 Update 07/31/2022 Steve Lee
  • PowerShellGet 3.0 Preview 16 07/28/2022 Sydney Smith
  • Archive Module 2.0 Preview 1 07/26/2022 Sydney Smith
Powered by Newp WordPress Theme. © 2022 LincolnBlog.net. All Rights Reserved.