Tag Archives: T-SQL
This is a code googled in panic after occasional deletion of a stored procedure. Does real magic saving hours of work that could be spent on re-writing:
There can be various reasons to extract metadata from Tabular model, for example to compose documentation or logical model diagram. The next collections are useful from architectural point of view: list of dimensions, list of measure groups and measures, list … Continue reading
After the recent news that SQL Server 2016 will support R and old news that Microsoft acquired RevolutionR I was interested if SQL Server is planned to use parallel computing (map-reduce based realisation R) or existing open-source version. Attending seninars … Continue reading
DECLARE @Dates TABLE ([Date] date) INSERT INTO @Dates([Date]) SELECT DATEADD(DAY, NUMBER, ‘1 mar 2012’) FROM (SELECT DISTINCT number FROM master.dbo.spt_values WHERE NAME IS NULL) N WHERE DATEADD(DAY, NUMBER, ‘1 mar 2012’) < ‘1 may 2013’
A useful trick for logging subsystem based on T-SQL: Found here among a number of similar solutions realised various ways.
Ten hours of rash and the simplest market simulator is ready! Gracefully composes buy/sell commands list by trend events and perfectly calculates total return of fund, Sharpe ratio and other statistical parameters. This is an example of a task it helps to accomplish: If … Continue reading
Solving a problem of how to query user information from Active Directory there were discovered the next issues: LDAP (Lightweight Directory Access Protocol) can be used in T-SQL queries only if they are ran on SQL Server installed on Domain … Continue reading