(Santhosh Kumar J) Microsoft SQL Server 2012 Release Candidate 0 has announced 3 new inbuilt conversion and 7 datetime functions. In this article, let us see how to use those new functions with their syntax and sample queries.
Tag: sql server
SQL Server 2012: Better Business Intelligence
(Stephen Strong) Poorly performing queries are the bane of any online transaction processing (OLTP) system. You could look to improve hardware performance, but the best way to solve this is to optimize those queries.
SQL SERVER – Step by Step Guide to Beginning Data Quality Services in SQL Server 2012 – Introduction to DQS
(Pinal Dave) Data Quality Services is a very important concept of SQL Server. I have recently started to explore the same and I am really learning some good concepts. Here are two very important blog posts which one should go over before continuing this blog post.
How to Audit Login Changes on a SQL Server
(K. Brian Kelley) I’ve been charged with coming up with a quick solution to audit login changes on my SQL Servers. However, there’s no budget so I’m going to have to come up with basic scripts and the like to do the work. Is this tip we cover a solution for you to audit login changes.
SQL Server Data Tools – An Introduction
(John Pertell) SQL Server Data Tools (SSDT) was introduced as a replacement to the old Business Intelligence Development Studio that’s been around since SQL 2005. But it does more than just create Integration Service or Analysis Service projects. Microsoft has taken the old BIDS and combined it with
T-SQL Window Functions – Part 2: Ranking Functions
(Steve Hughes) This is part 2 in my series on SQL window functions. In this post, we will explore using ranking functions. SQL Server support four different ranking functions which are supported in SQL Server versions 2005 and forward. All of these functions require the use of the OVER clause.
Getting Started with the New Column Store Index of SQL Server 2012
(Arshad Ali) Column Store Index is a new feature in SQL Server 2012 that improves performance of data warehouse queries several folds. Unlike regular indexes or heaps, which store data in B-Tree structure (in row-wise fashion), the column store index stores data in columnar fashion and uses compress
When I Use Nested Joins
(Michael J. Swart) I want to explain how I avoid RIGHT OUTER joins in favor of LEFT OUTER joins and how I avoid OUTER joins in favor of INNER joins.
SQL Server Memory per database
(Jaime Tarquino) Recently we experienced some issues with not having enough memory in some of our lab machines where we were running tests in a Single Box.
SQL SERVER – DQS Error – Cannot connect to server – A .NET Framework error occurred during execution of user-defined routine or aggregate ‘SetDataQualitySessions’ – SetDataQualitySessionPhaseTwo
(Pinal Dave) Earlier I wrote a blog post about how to install DQS in SQL Server 2012. Today I decided to write a second part of this series where I explain how to use DQS, however, as soon as I started the DQS client, I encountered an error that will not let me pass through and connect with DQS clie