create index

SQLServerCentral Article

Some T-SQL INSERTs DO Follow the Fill Factor! (SQL Oolie)

  • Article

With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]

5 (9)

2019-08-08

5,766 reads

External Article

SQL Server Index Properties in Management Studio

  • Article

Understanding indexes and how they work can be complicated enough for a Jr. DBA, but throw in all the different options and properties and an index can soon be overwhelming. Brady Upton takes an introductory look at creating an index in SQL Server using SQL Server Management Studio. He explains what each index property is meant for and the various options presented.

2013-11-19

4,619 reads

Blogs

Daily Coping 7 Oct 2022

By

Today’s coping tip is to be willing to share how you feel and ask...

T-SQL Tuesday #155 –The Dynamic Code Invitation

By

Apologies for the late invitation. A minor snafu has me hosting again. This is...

Daily Coping 6 Oct 2022

By

Today’s coping tip is to remind yourself that you are enough just as you...

Read the latest Blogs

Forums

Any reason to use AWS WAF over Cloudflare?

By obalikawa

I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...

OP identification

By kaj

In lengthy discussions and in developing trial and error scenarios I sometimes find it...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers