Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by Select customerid
Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't
In June, I wrote about a parameter-sniffing incident that turned a query that normally finished in 200 milliseconds into a 90-second outage. We stabilized the system by forcing the known-good plan in Query Store, then split small and large customers into separate code paths as the permanent fix. That left me with a question: if the database had been running SQL Server 2022 or later, would Parameter Sensitive Plan optimization have prevented the incident?
PostgreSql Tasks - Interview Questions
Tasks: 1. What is the difference between WHERE and HAVING clauses? WHERE Clause: Filters rows before any grouping or aggregation occurs. HAVING Clause: Filters groups after aggregation using the GROUP BY clause. 2. What is a foreign key? A foreign key is a column or set of columns in one table that establishes a link to the primary key in another table. 3. What is the difference between UNION and UNION ALL? UNION: Combines the result of two queries and removes duplicate rows.
How to Use the SQL Server ANY Keyword for Flexible Querying
In SQL Server, optimizing query performance and writing efficient, readable code is a vital skill for any database administrator or developer. One of the keywords that can help achieve both goals is the ANY keyword. It is particularly useful when dealing with conditional logic in subqueries, offering a flexible way to perform comparisons across a set of values.
Understanding The ‘AND’ Keyword In SQL Server
Understanding query formulation in the context of SQL Server is essential to maximizing the potential of your database. The AND keyword is among the most essential parts of SQL query logic. When creating complicated queries that need several criteria to be true at once, this operator is essential. We will examine the syntax, applications, and best practices of the AND keyword in-depth in this extensive book.
A Comprehensive Guide to Master SQL Querying.
At first glance, SQL might seem simple and not hard at all, that is true until you find yourself in front of complex database structures or having to write complex queries. It does get confusing or difficult sometimes (Yes even experienced people can find themselves scratching their heads). In this guide we're gonna lay out all the concepts so you can pick up SQL in no time. SELECT basics A SELECT statement retrieves data from a table found in your database. Each table has rows and columns.
Memory Grant Feedback Persistence in SQL Server 2022 – SQLServerCentral
As a SQL Server DBA, effectively controlling memory allocations is essential to guaranteeing optimal query performance. In SQL Server 2022, Microsoft enhanced a powerful feature called , which allows SQL Server to better anticipate memory requirements for future query executions. This feature solves a common issue wherein SQL Server may overestimate or underestimate the amount of memory required for a query, resulting in less-than-ideal performance or even the failure of the query.
Best way to join and query tables without matching data.
I have a temp table (~800 rows) created by querying the customer table.
SQL SERVER - STRING_AGG Function to Concatenate Strings
During the recent consulting engagement of Comprehensive Database Performance Health Check, I noticed that my client is using a very complex logic for contacting strings from a table. We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. In SQL Server, data manipulation often involves aggregating and combining values from multiple rows into a single string.
11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes
SQL Server is a powerful database management system, but it can also be complex and prone to mistakes. Whether you’re a seasoned database administrator or a beginner just getting started, it’s essential to be aware of common mistakes and how to avoid them. This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance and ensure your data’s integrity.
The Best SQL template for Customer Lifetime Value
Reusable SQL for RFM and CLV Analysis Introduction Over the past 10 years of my career, I’ve worked on Customer Lifetime Value (CLV) models with a variety of clients, industries, and datasets. There are many different ways to solve the problem, but this article is not about that. Instead, I want to explain the data setup, which is often neglected in the blogosphere.
Randomizing the Day Inside a Month Using T-SQL – SQLServerCentral
I recently ran across an interesting situation in our development databases. We have begun to protect various PII information in our systems by running scripts in the development databases when we restore a production backup. We do this as we have had executives express concern about losing data that exists on developer laptops and other systems. During one of our development sprints, we realized that we have a process that totals up birthdays in a month for some award system.
HQL COMMANDS FOR DATA ANALYTICS
HQL or Hive Query Language is a simple yet powerful SQL like querying language which provides the users with the ability to perform data analytics on big datasets. Owing to its syntax similarity to SQL, HQL has been widely adopted among data engineers and can be learned quickly by people new to the world of big data and Hive.
Stages of Data: The DNA of a Database Developer, Part 1
Long before I started in IT, I wanted to teach. The process of learning something, then performing it, crafting it, learning from mistakes, further crafting it, and sharing that journey with others appealed to me as a great career. Rod Paddock (Editor-in-Chief for CODE Magazine) recently told me that the May/June 2024 issue of CODE would deal with databases.
Intersect, Except, Union, All and Any – SQLServerCentral
I was reviewing the Microsoft training courses for SQL2008 for a set of application developers who wanted to learn more about SQL Server. In doing so I came across some commands that I either had not heard of or had not used before. INTERSECT EXCEPT ALL ANY ALL and ANY have been around for donkeys years but INTERSECT and EXCEPT were new to me. Whenever I find a new set of commands in T-SQL I fire up my developer edition and go straight to Adventureworks to start playing around.
Display Complex Hierarchical Data with Server-Side Pagination – SQLServerCentral
Displaying hierarchical data has been made easy with Reporting Services 2008. It usually involves creating a self-referenced table with ParentID associated to the primary key (e.g., ManagerID to EmployeeID) and then setting the recursive parent in Reporting Services.
Optimizing a cursor based routine – Part 2 – SQLServerCentral
In the first article of this series, we started to deconstruct a stored procedure with the aim of improving the efficiency of it. Hopefully, you will have been able to absorb that information and are now eager to see more. The number one reason I hear for creating a cursor routine is to allow for the conditional processing on a limited number of rows.
Optimizing a cursor based routine – Part 1 – SQLServerCentral
When presented with a poorly performing stored procedure, there can be a one single statement that is to be optimized. However, more often than not this is not the case. There will be many statements each of which may perform well in isolation; the issue is the amount of times that they are executed. It’s a “Death by a thousand cuts scenario”. SQL is a language designed to work with large datasets and SQL Server works best when given instructions that exploit that.
SQL - Derived Tables – SQLServerCentral
Introduction With SQL Server you have the ability to create derived tables on the fly and then use these derived tables within your query. In very basic terms, a derived table is a virtual table that's calculated on the fly from a select statement. In concept this is similar to creating a temporary table and then using the temporary table in your query, but the approach is much simpler, because it can all be done in one step. This can be tremendously useful in certain situations.
Understanding Last_Value in SQL Server
Explore the last_value analytic function in SQL Server and its application in understanding tinyint vs int data types. The framework for autonomous intelligence The LAST_VALUE function in SQL Server is a powerful analytic function that retrieves the last value in an ordered set of values. It is often used in conjunction with the OVER clause, which allows you to define the partitioning and ordering of the data.
Understanding Tinyint Vs Int Nullable Default
Explore how nullable default values affect Tinyint and Int data types in SQL, enhancing your database design knowledge. The framework for autonomous intelligence In SQL, nullable columns are those that can hold NULL values, which represent the absence of a value. This feature is crucial for database design, allowing flexibility in data entry and storage. When defining a column, you can specify whether it is nullable or not.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with Select
Contact Select, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack