DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

New T-SQL features in SQL Server 2012 – Conversion Functions

Posted on February 5, 2012 Written by Andy Hayes Leave a Comment

SQL Server 2012 ("Denali") is nearly here and with all new releases, there are always new features to know about. I am very interested to find out more about the product and my next few posts will talk about some of the new T-SQL features of SQL … [Continue reading]

Filed Under: All Articles, SQL Tips and Tricks Tagged With: sql server 2012, t-sql

What are the differences between primary keys and unique indexes in SQL Server ?

Posted on January 7, 2012 Written by Andy Hayes Leave a Comment

differences between primary keys and unique indexes

I was recently asked, what are the differences between primary keys and unique indexes? Well, they are very similar but here are the differences. Only one primary key is allowed on a table but multiple unique indexes can be added up to the maximum … [Continue reading]

Filed Under: All Articles, SQL Server Administration Tagged With: sql server

GROUPING SETS performance versus UNION performance

Posted on January 2, 2012 Written by Andy Hayes Leave a Comment

GROUPING SETS is a way of aggregating data to produce a result set containing different sets of columns. For the SQL Server platform, it was first introduced in SQL 2008. Prior to SQL Server 2008, achieving this type of result set was possible … [Continue reading]

Filed Under: All Articles, SQL Server Performance Tagged With: performance, sql server 2008, t-sql

Database views explained

Posted on December 30, 2011 Written by Andy Hayes 2 Comments

database views

Database views are virtual tables which are built up using a SELECT query. The query may contain one or more tables. To help explain database views, here is a quick script created using SQL Server to create some tables and data. (If you want to … [Continue reading]

Filed Under: All Articles, MySQL Administration, SQL Server Administration Tagged With: mysql, sql server

  • « Previous Page
  • 1
  • …
  • 18
  • 19
  • 20
  • 21
  • 22
  • Next Page »

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • How to shrink tempdb
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright © ‘2021’ DBA Diaries built on the Genesis Framework

This site uses cookies. We assume you are happy with cookies but click the link if you are not. Close