Converting Epoch timestamp to sql server(human readable format) with localized time:
DATEADD(hh, DATEDIFF(hh, getutcdate(), getdate()), dateadd(s, myEpoch_included, '19700101'))
Log shrink nasıl olur yaz
Procedural language used by MS SQL is T-SQL
Convert Double to Int: CAST(myDoubleNumber AS INT)
Find all tables containing column with specified name
Date Comparison from string: CAST('20171231 15:13:48.593' AS DATETIME)
HOW TO IMPORT CSV TO A TABLE WITH SQL MANAGEMENT STUDIO 2016
Right click to DB: Tasks -> Import
When destionation page comes select: SQL Server Native Client.
MSSQL'e MYSQL'deki GROUP_CONCAT fonksiyonu nasıl kazandırılır?
Create Table from a select query: SELECT * INTO new_table FROM (SELECT ...) as nameIsNotImportant
To find out mssql server logs' location:
USE master
GO
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
GO