Date Tables are Great for Users, but Not So Great for Performance
If you haven’t used a date table before, here are a couple of primers on how to create one and use it.
2020-08-27
If you haven’t used a date table before, here are a couple of primers on how to create one and use it.
2020-08-27
In this tip we look at how to move SQL Server tables from one filegroup to another filegroup.
2019-10-30
One very important design aspect when creating a new table is the decision to create or not create a clustered index. We will take a look at a few points to help with the decision.
2019-07-19
In this article, Fikrat Azizov describes the different approaches to maintaining statistics and shows how you can use the data from your servers for intelligent statistics updates.
2016-06-01
3,273 reads
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,665 reads
From SQL Server Management Studio it's hard to look through the first few rows of a whole lot of tables in a database. This is odd, since it is a great way to get quickly familiar with a database. Phil tidied up a SQL routine he uses to investigate databases quickly in a browser. He explains how to use it, how it works, and how to use it from PowerShell.
2014-08-20
10,983 reads
There are some aspects of tables in SQL Server that a lot of people get wrong, purely because they seem so obvious that one feels embarrassed about asking questions. Robert Sheldon reckons that no questions about SQL Tables are off-limits, and deserve frank answers.
2014-07-03
9,666 reads
List all tables in a SQL Server database with the details of them.
2015-10-13 (first published: 2013-02-20)
4,521 reads
Simple script which create a list of all the tables and rows of the selected DB.
2013-02-11 (first published: 2012-12-21)
1,083 reads
2008-09-09
1,058 reads
By Steve Jones
I love Chicago. I went to visit three times in 2023: a Redgate event,...
By Brian Kelley
I have found that non-functional requirements (NFRs) can be hard to define for a...
You can find the slidedeck for my Techorama session “Microsoft Fabric for Dummies” on...
Hello, I have a question regarding Availability group server architecture. A little background: We...
Testing with AG on Linux with Cluster=NONE. it was all going ok and as...
Hi, I have two tables: one for headers with 9 fields and another for...
Let’s consider the following script that can be executed without any error on both SQL Sever and PostgreSQL. We define the table t1 in which we insert three records:
create table t1 (id int primary key, city varchar(50)); insert into t1 values (1, 'Rome'), (2, 'New York'), (3, NULL);If we execute the following query, how will the records be sorted in both environments?
select city from t1 order by city;See possible answers