When to use CHAR, VARCHAR, or VARCHAR(MAX)
It’s important to choose the right datatypes when designing a database. Greg Larsen explains the differences between CHAR, VARCHAR and VARCHAR(MAX).
Joining a Community
In the last week I've been actively trying to join the PostgreSQL community. It's been an interesting experience. I suspect it's going to stay interesting for a while. As part of what I'm doing, I saw this excellent video from Ryan Booz, talking about joining a new community. It got me to thinking. You have […]
Do You Still Use CHAR?
When designing a database, choosing good datatypes is important, but not necessarily all the time. Today Steve wonders if you still use fixed sting data types.
SQL Server Development Using Free Tools
You can make SQL Server database development faster and easier with a FREE toolkit!
Reporting on the Progress of a Flyway Database Development Project
This article demos a novel way to report on the progress of your Flyway development project. It provides both SQL and PowerShell versions of code that extracts information for each database version from the Flyway schema history table and then plots it in a Gantt chart.
Vertipaq optimization and its impact on columnstore compression
Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage it.
The Cloud as a Foundation
The innovations and possibilities of cloud computing are exciting to Steve.
Share your insights and help shape the Summit 2022 program
We want to hear from you! Tell us what's important to you by sharing your insights and preferences for PASS Data Community Summit 2022. Community feedback is at the heart of everything we do for Summit and your insights will help guide our planning for this year's conference, taking place online and in-person in Seattle, November 15 - 18, 2022.
Transformations by the Oracle Optimizer
To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.
PostgreSQL in Azure using the Azure Data Studio Extension
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers