February 1, 2023
  • 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
Home2022January

Month: January 2022

Excel Tips

Excel shortcut to select an entire column

January 7, 2022

How to select an entire column of data with Excel, i.e. all the way down fron the top the end? To select the current column down to the last cell, you can use …

SQL Server Strings

Split text after character with SQL Server Substring

January 6, 2022

How to split a text after a particular character with SQL Server… like for example a file name: “file.txt” to separate the file name from its extension. Indeed, it is obvious that splitting …

Excel Tips

Disable the direct edit option in Excel

January 5, 2022

With Microsoft Excel, how to deactivate the direct modification option to edit spreadsheet cells? That is, the function of automatically modifying the content of a cell when it contains a formula? Indeed, by …

Useful SQL

Insert into from a select query in SQL Server

January 4, 2022

How to write an Insert into query from a Select with SQL Server? There are three solutions for running an INSERT INTO query with a SELECT in SQL Server. The first solution is …

SQL Server Database

Empty the SQL Server transaction log to fix error 9002

January 3, 2022

Microsoft SQL Server database is slow, or the available disk space is getting abnormally small? To solve this problem, it is sometimes enough to empty the SQL Server transaction log and reduce the …

Word tips

Insert a comment in Word margin

January 2, 2022

How to insert a comment in the margin with Word, that is, a visible remark? This Word tip applies to versions 2003, 2007, 2010, 2013 and also to the most recent Word versions. …

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 …

Posts navigation

« 1 2 3

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