create index

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,067 reads

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 27 Oct 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

How do I test if a linked server works using T-SQL?

By

I get that linked servers are almost as despised as the dreaded cursor or...

Power BI Monthly Digest – October 2020

By

In this month’s Power BI Digest Matt and I will again guide you through...

Read the latest Blogs

Forums

identify sql backup strategies

By mtz676

how do I identify if the dbs are getting backed up (full,diff,log) without looking...

schedule a job in CMS

By mtz676

Is it possible to schedule a sql job in CMS ? As of now...

what does it mean for the following SQL Scripts

By 892717952

in a stored procedure, I found two line sql scripts "    if @@microsoftversion > 0x07320000 exec sp_MSreplraiserror 20598...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers