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,839 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

New Job -> Week 2 -> Creating a Checklist

By

This is part of a series of new job blog posts. You can find...

SQL Server 2022 Administration Inside Out

By

SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...

WIT/DEI Mental Health and Wellness Day Challenge to Present

By

Back in December 2019, I started presenting my session on mental health with lots...

Read the latest Blogs

Forums

Get a Date Time Stamp of table when another columns value changes.

By lalitprg2017

I am having Below Table i want to get Result as shown in the...

how to write a query by using some filter patterns in SQL Server?

By maifs

what I want is to apply some filter patterns to search the data. For...

Tsql query to show currently running sql agent jobs

By vsamantha35

Hi All, Using Tsql query I want to know currently running sql agent jobs...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers