Tags » T-SQL

SQL SERVER - Cardinality Estimation and Performance - SQL in Sixty Seconds #072

Yesterday I wrote blog post based on my latest Pluralsight course on learning SQL Server 2014. I discussed newly introduced cardinality estimation in SQL Server 2014 and how it improves the performance of the query.  154 more words

SQL Authority

“Java Developer (Brokerage Domain)” for 03-06 months Contract position in Seattle, WA.

Job Title: “Java Developer (Brokerage Domain)”

Job Location: Seattle, WA.

Job Duration: 03-06 months

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

Client Domain: IT Services, IT Consulting… 185 more words

Jobs

SQL Server Error Messages - Msg 8101

Sometime SQL Server error msg 8101 occurred, when anyone is trying to insert a new record into a table that contains an identity column without specifying the columns in the INSERT statement and trying to assigning a value to the identity column instead of letting SQL Server assign the value. 80 more words

Database Administrator

SQL SERVER - Simple Demo of New Cardinality Estimation Features of SQL Server 2014

SQL Server 2014 has new cardinality estimation logic/algorithm. The cardinality estimation logic is responsible for quality of query plans and majorly responsible for improving performance for any query. 473 more words

SQL Authority

How To Split Non-Empty Partitions When A Clustered Columnstore Index Exists on The Table

Another pithily titled blog post, but this one revisits the feature of SQL Server 2014 that piqued my interest the most: Clustered Columnstore Indexes. I’ve been working with Clustered Columnstore Indexes for the past few months and recently a colleague had to split a non empty partition, only for the error message below to appear. 2,929 more words

SQL

Calculating 30/360 day count convention

Calculating the number of days between two dates is a trivial matter in T-SQL if you use the DATEDIFF function. However, how many years (or rather, fractions of years) there are between two given dates is a matter of which method (day count convention) you apply. 725 more words

T-SQL