July 4, 2022
  • Facebook
  • Twitter
  • Youtube
Expert-Only

  • Database
    • Create database with SQL Server Management Studio
    • Create SQL database with a script
    • Drop SQL Server database script
  • Tables & views
    • Table
      • Create SQL Server table
      • Create table with primary key
      • Create customer table
      • Alter SQL table
      • Truncate SQL Server table
      • Drop SQL table
      • Check if SQL table exists
    • View
      • Create SQL Server view
      • Alter SQL view
      • Drop SQL view
      • Create SQL partitioned view
  • Procedure & functions
    • Procedure
      • Create stored procedure
      • Alter stored procedure
      • Create procedure with parameters
    • Function
      • Manage SQL function
      • Create SQL function
      • Call SQL function
      • Alter SQL function
      • Delete SQL function
  • Indexes & partitions
    • Index
      • Clustered SQL index definition
      • Create SQL index
      • Rebuild SQL index
      • Reorganize SQL index
      • Disable SQL index
      • Drop SQL index
      • List all SQL indexes
    • Partition
      • SQL Server partition definition
      • Create SQL table partition
  • MS Office tips
    • Excel tips
      • Best cell selection shortcuts for Excel
      • Display the day in all letters with Excel
      • Excel shortcut to select an entire column
      • Disable the direct edit option in Excel
      • Turn off Excel Scroll Lock option
    • Word tips
      • Create an automatic table of contents with Word
      • Delete a horizontal line in Microsoft Word
      • Insert a comment in Word margin
  • IT concepts
    • Dimension table definition in Business Intelligence
    • DSS or Decision Support System definition
    • EPM or Enterprise Performance Management definition
    • OLTP and Transactional Databases definition
  • MS-DOS commands
  • Useful SQL
    • Insert into from a select query
    • SQL Server insert or update query example
  • Time and dates
    • Display full month name in SQL Server?
    • Time difference in hours minutes
  • Strings
    • Split text after character with SQL Server Substring
    • Remove SQL line break from text
    • Split long SQL Server text in lines
  • SQL Server
    • SQL Server Abbreviations
    • SQL Server Downloads
    • SQL Server Errors
  • DAX functions
HomePerformance

Performance

IT Concepts

EPM or Enterprise Performance Management definition

January 1, 2022

What is EPM or Enterprise Performance Management, also known as Performance Management? is a field of Business Performance Management or BPM. It considers the visibility of operations in a closed-loop model across all …

Time economy is key when you create a SQL Server partition.
SQL Server Partition

Create a SQL Server table partition

August 26, 2020

How to create a table partition in SQL Server? Let’s consider a large table with Sales data. So, this table have a column that stores the year of the sale and the table …

SQL Server Partition

What is a SQL Server table partition?

August 24, 2020

A SQL Server table partition allows to physically split the data of one table on the disk. This data division allows to access directly one unique partition instead of all the data from …

SQL Server Index

Clustered index in SQL Server

August 21, 2020

What is a SQL Server clustered index ? The definition of a SQL Server index is a structure, i.e. a file, stored physically in a disk. It’s similar to the master data file …

SQL Server Index

How to rebuild a SQL Server index?

August 18, 2020

Maintain the indexes is vital to keep a database up to speed with optimal performance. To rebuild an index, use the command to alter and rebuild. Technically speaking, the query rebuilding the index …

SQL Server Index

How to reorganize a SQL Server index?

August 17, 2020

How to reorganize a SQL Server index? This operation defragments the lower level of the indexes by reordering the pages physically, from left to right. The reorganize operation also compacts the pages of …

SQL Server Index

How to disable a SQL Server index?

August 16, 2020

How to disable a SQL Server index? To disable an index for performance reasons, use this code and adjust it to your index and table names. For instance, let’s consider a large sales …

SQL Server Index

How to drop a SQL Server index?

August 15, 2020

This article is on how to drop a SQL Server index from an existing table on a given database. It can be a relational or a transactional database. For instance, learn here why …

Follow Us

Facebook
Facebook
fb-share-icon
Twitter
Visit Us
Follow Me
Tweet
WhatsApp

SQL Server Database

  • Empty the SQL Server transaction log to fix error 9002
    January 3, 2022
  • Create SQL Server database with a script
    June 17, 2021
  • Time economy is key when you create a SQL Server partition.
    Create a new database with SQL Server Management Studio
    June 16, 2021
  • Delete SQL Server database with a script
    June 15, 2021

SQL Server functions

  • Manage SQL Server user defined functions
    October 20, 2018
  • How to create a SQL Server function ?
    October 19, 2018
  • How to call a SQL Server function?
    October 18, 2018
  • How to modify a SQL Server function?
    October 17, 2018
  • How to delete a SQL Server function ?
    October 16, 2018

SQL Server stored procedures

  • Execute SQL Server procedure with parameters
    January 11, 2022
  • Create a SQL Server stored procedure
    August 16, 2020
  • Alter a SQL Server stored procedure
    August 15, 2020
  • Create a SQL Server stored procedure with parameters
    August 14, 2020

SQL Server Tables

  • Empty a table with truncate table in SQL Server
    January 8, 2022
  • List all SQL Server tables with a query
    December 29, 2021
  • Create a SQL Server table
    June 19, 2018
  • Create table with primary key in SQL Server
    June 18, 2018
  • Create a customer table with SQL Server
    June 18, 2018
  • Modify a SQL Server table
    June 17, 2018
  • Delete a SQL Server table
    June 16, 2018
  • Check if SQL Server table exists before delete
    June 15, 2018

SQL Server Views

  • Create a view with SQL Server
    July 19, 2020
  • Create partitioned view in SQL Server
    July 18, 2020
  • How to delete a SQL Server view?
    July 16, 2020
  • How to modify a SQL Server view?
    June 17, 2020

SQL Server Indexes

  • Clustered index in SQL Server
    August 21, 2020
  • Create an index in SQL Server
    August 19, 2020
  • How to list all SQL Server indexes?
    August 19, 2020
  • How to rebuild a SQL Server index?
    August 18, 2020
  • How to reorganize a SQL Server index?
    August 17, 2020
  • How to disable a SQL Server index?
    August 16, 2020
  • How to drop a SQL Server index?
    August 15, 2020

SQL Server partitions

  • Create a SQL Server table partition
    August 26, 2020
  • What is a SQL Server table partition?
    August 24, 2020

POPULAR POSTS

  • Calculate last month value in DAX with Power BI
    September 3, 2020
  • Time economy is key when you create a SQL Server partition.
    Create a SQL Server table partition
    August 26, 2020
  • SQL Server Violation of unique key constraint
    May 31, 2017
  • Delete Windows files recursively in cmd
    January 27, 2022

LATEST POSTS

  • Delete Windows files recursively in cmd
    January 27, 2022
  • Delete a file in Windows cmd
    January 26, 2022
  • Ralph Kimball’s bottom-up business intelligence modelling
    January 25, 2022
  • Download and install the OLEDB driver for Excel 2010
    January 24, 2022

2017 - 2022 | Expert-Only.net | Learn Microsoft IT by example © All rights reserved.