Category: SQL Server

• 24.10

  SQL Azure DB – Creating a Restricted User in Azure SQL Who Owns Only Their Schema

• 16.05

  Determine which version and edition of SQL Server Database Engine is running

• 23.03

  SQL SERVER – Generate script of All the indexes in a database

• 02.03

  SQL SERVER – How to select only Second row from a table?

• 16.02

  SQL SERVER – Select the minimum value from several columns?

• 01.12

  SSRS – Conditional Formatting for SQL Server Reporting Services Reports

• 20.11

  SQL SERVER – Server ‘xxx’ is not configured for RPC

• 08.10

  SQL SERVER – Get the Month Name from a Date

• 08.10

  SQL SERVER – How to get the first and last date of the current year?

• 08.10

  SSRS Chart Does Not show all Labels on Horizontal Axis

• 22.09

  SQL SERVER – Prevent SSRS Slow Startup

• 21.09

  SQL SERVER – How many CPUs are used?

• 15.09

  SSRS Report Builder – Change regional setting

• 15.08

  AX / D365FO – Force a Select Query to use a specific index with Index Hint

• 10.08

  SQL SERVER – Getting the second occurrence from charindex function

• 02.06

  SQL SERVER – Create a SQL Server Linked Server to Azure SQL Database

• 30.05

  SQL SERVER – Convert a given date from UTC to your time zone and daylight savings time

• 23.05

  SQL SERVER – Copy more than 65535 characters from result grid Column

• 17.05

  SQL Server – How to identify blocking session

• 10.03

  SQL SERVER – Troubleshoot high-CPU-usage issues

• 27.02

  SQL SERVER – Update top n records in sql server

• 27.02

  SQL SERVER – How to get last char in a string in sql server

• 12.02

  SQL Server – Row Count for all Tables in a Database

• 12.02

  SQL SERVER – Format numbers in SQL Server

• 12.02

  SQL SERVER – Format Dates with FORMAT Function

• 12.02

  SQL SERVER – COnvert Datetime to Date

• 12.02

  SQL SERVER – Add or remove days to a Date

• 12.02

  SQL SERVER – Automatically Defrag indexes based on a given fragmentation percent

• 12.02

  SQL SERVER – Execute dynamic SQL

• 12.02

  SQL SERVER – Reorganize all indexes in a table

• 04.02

  SQL SERVER – Remove Milliseconds from Datetime in T-SQL

• 03.02

  SQL SERVER – Get records from last hour

• 31.01

  SQL SERVER – How to see query history in SQL Server Management Studio

• 20.01

  SQL SERVER – Remove special characters from string

• 20.01

  SQL SERVER – Get numeric values from string

• 27.12

  SQL SERVER – Find Index Fragmentation status using the T-SQL statement

• 25.09

  SQL SERVER – Use Change Data Capture for track table changes

• 21.09

  SQL SERVER – Find where specific table or view is used in SQL Server database

• 05.09

  SQL SERVER – Auto Generate INSERT Statements For A Table In SQL Server

• 28.08

  SQL SERVER – How to increase the maximum number job history logs

• 28.08

  SQL SERVER – HOW TO : TEMPDB won’t shrink even if there is unused space available

• 27.08

  SQL SERVER – Create an Alert for TEMPDB Growing out of control

• 15.08

  sql server – Free disk SPACE USING SHRINK

• 07.08

  AX / D365FO – Create index with “Included columns”

• 06.08

  SQL SERVER – Concatenates rows fields into a single string with STRING_AGG()

• 06.08

  SQL SERVER – DROP TABLE IF EXISTS

• 03.08

  SQL SERVER – enlarge FOnts results in SSMS

• 30.07

  AX / D365FO – How to identify the SQL Server version and edition

• 30.07

  AX / D365FO – SQL Server password for user “axdbadmin” in locally deployed D365 for Operations environments

• 29.07

  AX / D365FO – How TO find a text inside a stored procedure – SQL SERVER

• 06.12

  AX – D365FO – Connect to UAT database through SSMS (SQL Server management studio)

• 27.11

  SQL SERVER – How to : “The database could not be exclusively locked to perform the operation”

• 19.11

  AX – D365FO – Connect to Your Non-Production Database (UAT, etc..) with SQL Server management studio (SSMS)

• 11.11

  SQL SERVER – Update a DateTime field

• 11.04

  SQL SERVER – Clustered and Nonclustered Indexes Described