Tags » T-SQL

SQL SERVER - Andy Defines Basic RDBMS: Isolation in Processes - Notes from the Field #038

: This is a new episode of Notes from the Field series. Every time I give an introductory note, however, this time there is no need of intro note. 577 more words

SQL Authority

“MSBI (SSAS) Developer” for 06 months Contract position in Redmond, WA.

Job Title: “MSBI (SSAS) Developer”

Job Location: Redmond, WA.

Job Duration: 06 months

Job Nature: Contract, Contract-to-Hire (CTH)

Required Years of Experience: 07+

Number of Positions: … 78 more words


SQL Authority News - Webinar: SQL Server 2014 In-Memory OLTP and SafePeak In-Memory Caching

In the past couple of months many of us heard about the new SQL Server 2014 and its In-Memory technologies, such as In-Memory OLTP for high-transactional application and the ColumnStore INDEX’s for BI apps. 351 more words

SQL Authority



Nasledujici kod vytvori funkci s reportem. Zavolanim funkce zjistime ktere joby v databazi bezi a ktere ne. Nakonec smaze funkci z databaze, takze se nemusite zabyvat tim, ze bude v db neco vyset. 696 more words



Nasledujici kod smaze konkretni job z databaze

DECLARE @jobName varchar(50)
DECLARE @jobId binary(16)
SET @jobName = 'test_job

SELECT @jobId = job_id FROM msdb.dbo.sysjobs WHERE (name = 'test_job')
35 more words


Why am I getting a primary/unique key violation?

This may seem like a question with a simple answer but there is a bit more to it than you might think. In fact I know of 3 possible reasons (and there may be more I don’t know) for seeing a primary key error. 711 more words

Microsoft SQL Server

Transact-SQL: Language of the Year 2013

Disclaimer: The information is based on internet statistics (and not compiled by me! Yes I’m not guilty!)

TIOBE programming community index is a measure of popularity of Turing complete languages based on search engine results. 121 more words