Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "indexing"

1

Indexes in MongoDB: A quick overview

This is my Fourth MongoDB post, in the first post we looked at how we can install MongoDB as a Windows Service, In the second post we looked at how we could do UPSERTs with MongoDB, In the third post we looked at how to sort results in MongoDB
This pos…

Read More...
0

SQL Advent 2012 Day 21: With VLDBs it matters what you do and how you do it

This is day twenty-one of the SQL Advent 2012 series of blog posts. Today we are going to look at Very Large Databases

Read More...
0

SQL Advent 2012 Day 15: Benefits of Indexes

This is day fifteen of the SQL Advent 2012 series of blog posts. Today we are going to look at indexes

Read More...
2

SQL Advent 2012 Day 3: Sargable Queries

This is day three of the SQL Advent 2012 series of blog posts. Today we are going to look at sargable queries. You might ask yourself, what is this weird term sargable. Sargable comes from searchable argument, sometimes also referred as Search ARGument…

Read More...
2

Find all the tables and indexes that have data compression

I took a backup of one of our test databases today and gave it to someone so that it could be restored on one of their servers.

I got back the following in an email from the person who tried to do the restore

Date 11/16/20…

Read More...
0

SQL Advent 2011 Day 24: Index REBUILD and REORGANIZE

Today we are going to look at how to recreate and defragment indexes. Back in the SQL Server 2000 days you would do a CREATE INDEX WITH DROP_EXISTING/DBCC DBREINDEX or DBCC INDEXDEFRAG. To check fragmentation, you would use DBCC SHOWCONTIG. To check fragmentation in SQL Server 2005 and up, you now can use the Dynamic Management View sys.dm_db_index_physical_stats. To rebuild an index, you use ALTER INDEX IndexName REBUILD; to defragment and index, you use ALTER INDEX IndexName REORGANIZE;

Read More...
1

SQL Advent 2011 Day 20: Indexes with Included Columns

Today we are going to take a look at Indexes With Included Columns

SELECT * INTO Test2 FROM sys.objects

CREATE INDEX ix_Test1 ON Test1(type,is_ms_shipped)

SELECT type,is_ms_shipped
FROM Test1
WHERE type = ‘s’
AND is_ms_shipped = 1

plan1

SELECT type,is_ms_shi…

Read More...
2

SQL Advent 2011 Day 19: Filtered Indexes

Today we are going to take a look at Filtered Indexes. A filtered index is an optimized nonclustered index, the filtered index will be based on a WHERE clause, thus this index will cover your query if your query has the same WHERE clause

Read More...
0

Do you use disable index or drop index when running your ETL processes in SQL Server

There are certain operations where dropping an index, loading data and then again creating the index can speed up data loading. SQL server 2005 introduced a way to disable an index. Let’s take a look, first create this table Create table TestIndex (id int, somecol varchar(20)) Insert a little bit of data insert into TestIndex […]

Read More...
3

T-SQL To find Out If An Index Is Clustered Or Non Clustered

I saw this question in in Google Analytics from a Google search that hit our site. So, how can you determice if an index is clustered or not? There are two ways, you can use either the INDEXPROPERTY function or the sysindexes/sys.sysindexes system table/view To see how it works we will create a table with […]

Read More...
Next Page »