SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: October 2018

Lookup. Foreign Key Constraint vs Check Constraint

This post helps in deciding between choosing foreign key and check constraints in case we need to constraint the data in a field. Click here to read full article

Read more

0 comments, 87 reads

Posted in SQL Design Patterns on 16 October 2018

Extended Events Made Easy – Sorting, Grouping and Aggregation

When I’m using Profiler to analyse performance issues I often save the results to a table, or upload a trace file into a table, so that I can analyse the data. Often this involves aggregating the values for particular queries so that I can see the most resource hungry.

This… Read more

0 comments, 88 reads

Posted in Matthew McGiffen DBA on 16 October 2018

Azure SQL Database Hyperscale

At Microsoft Ignite, one of the announcements was for Azure SQL Database Hyperscale, which was made available in public preview October 1st, 2018 in 12 different Azure regions.  SQL Database Hyperscale is a new SQL-based and highly scalable service tier for single databases that adapts on-demand to your workload’s… Read more

0 comments, 72 reads

Posted in James Serra's Blog on 16 October 2018

A Play Around With Table Variable Deferred Compilation in SQL 2019

Table variables, they’re nasty, dirty little things that perform about as well as a Robin Reliant in a crosswind, right?  Well you’re not going to have me argue with you there.

But how many of us have got these little beasts floating around in their production code with absolutely nothing… Read more

0 comments, 64 reads

Posted in SQL Undercover on 16 October 2018

Conditionally Returning Rows Based On Query Results

While I normally prefer formatting my query results in a downstream app/reporting layer, sometimes I can’t get around adding some business formatting logic to my SQL queries.

Today I want to show you four different ways to conditionally output rows of data based on a SQL query.

Setting Up The…

Read more

0 comments, 64 reads

Posted in Bert Wagner on 16 October 2018

Query Memory Grants and Resource Semaphores in SQL Server

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

In today’s blog posting I want to talk about Query Memory in SQL Server, and want to… Read more

0 comments, 74 reads

Posted in Klaus Aschenbrenner on 16 October 2018

Internal Query Processor Error Debugged

In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us in very interesting cases. One of them occurred after a migration of a critical stock trading system database to SQL Server 2017. Every night, when there are no trades on… Read more

0 comments, 65 reads

Posted in Joyful Craftsmen Blog on 16 October 2018

Database Transaction log file full in the full recovery model

I am seeing in more environment the database recovery model is set FULL and there is no transaction log backup scheduled and the log files are growing bigger, until it reaches a file system space.

Me: Hello sir, May I know the reason, why we set the database in full… Read more

0 comments, 58 reads

Posted in SQL Server Blog Forum on 16 October 2018

Speaking at SQL Saturday Oregon

I am so excited and honored that I have been selected to speak at SQL Saturday Oregon on November 3, 2018.

I will be presenting my Data Types Do Matter session at 10:15 am.  I am so excited to be presenting to a kind of “home town” crowd.  I lived… Read more

0 comments, 82 reads

Posted in SQL Swimmer on 16 October 2018

Power BI Monthly Digest – October 2018

In this month’s Power BI Digest with my friend Manuel Quintana [Blog | Twitter] and I will again guide you through some of our favorite Power BI updates this month. In our October 2018 edition we highlighted the following features:

    • Search in Filter
    • DAX Editor Improvements
    • Column Profiling…

Read more

0 comments, 148 reads

Posted in Devin Knight on 15 October 2018

Regular Expressions: tagging expressions

I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take a minute to define regular expressions, explain tagged expressions, and then show you how to use it in the same line. But first, XKCD: Regular Expressions defined “A… Read more

0 comments, 75 reads

Posted in SQL Awesomesauce on 15 October 2018

SQL Pivot and Unpivot relational operatots

In this article, we’ll walk-through the SQL Pivot and SQL Unpivot operators and how they can be useful to transpose SQL Server data. Also, we’ll discuss both static and dynamic ways to use PIVOT and UNPIVOT relational operators that can … Continue reading

Read more

0 comments, 73 reads

Posted in PowerSQL By Prashanth Jayaram on 15 October 2018

Using Extended Events to Capture Implicit Conversions

Using the appropriate data type to avoid conversions or implicit conversions is a fundamental approach to good T-SQL coding practices. Implicit conversions can lead to poor performance. However, other than looking at every execution plan in your system, is there a way to see if you are experiencing implicit conversions?… Read more

0 comments, 84 reads

Posted in The Scary DBA on 15 October 2018

Highlighting sp_spaceused

I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick way to bring up the size of things. Specifically:

  • Tables
  • Indexed views
  • Service Broker queues
  • Databases

It’s the first and last that I use the most often. It’s… Read more

0 comments, 92 reads

Posted in SQLStudies on 15 October 2018

How much affects encryption to your database performance?

Transparent data encryption (TDE) helps you to secure your data at rest, this means the data files and related backups are encrypted, securing your data in case your media is stolen.
This technology works by implementing real-time I/O encryption and decryption, so this implementation is transparent for your applications and…

Read more

0 comments, 94 reads

Posted in SQL Guatemala on 15 October 2018

Generic Modifier In & Out C#

In [Contravariant]

The image is self-explanatory.

Out [Covarient]

The image is self-explanatory.

Read more

0 comments, 73 reads

Posted in Querying Microsoft SQL Server on 15 October 2018

Setting Variables in Azure Data Factory Pipelines

(2018-Oct-15) Working with Azure Data Factory you always tend to compare its functionality with well established ETL packages in SSIS. Data flow task have been recreated as Data Copy activities; logical components have found they cloud-based siblings; as well as new kids on the block, such as Databricks and Machine Learning activities…

Read more

1 comments, 135 reads

Posted in Data Adventures on 15 October 2018

My Current Training Courses on Pluralsight!

Here’s a run down of the Linux training that I have available on Pluralsight!

Just getting started! 

Understanding and Using Essential Tools for Enterprise Linux 7 – If you heard what Linux is and want to get started this is the place to be. We’ll cover installation, command line basics,… Read more

0 comments, 185 reads

Posted in Anthony Nocentino's Blog on 13 October 2018

SQL Server on Linux – External Memory Pressure with 2019 CTP2

In this blog post we’re going to revisit how SQL Server on Linux responds to external memory pressure. This is a very long post, and it ends with me not knowing exactly what’s going on…but the journey is pretty fun…let’s go!
On Windows-based SQL Server systems we’ve become accustomed to…

Read more

0 comments, 149 reads

Posted in Anthony Nocentino's Blog on 13 October 2018

Installing minikube on CentOS

In this blog post, I’ll show you how to install Minikube on CentOS. Minikube is a platform you can use to test kubernetes clusters on your local machine or in a virtual machine.

Let’s start off with a fresh Install of CentoOS 7 on a virtual machine using a minimal… Read more

0 comments, 130 reads

Posted in Anthony Nocentino's Blog on 13 October 2018

Older posts