SQL Homework – August 2017 – Create a table
If you didn’t see it last month I’ve started doing monthly SQL Homework. The first month was backups, this month...
2017-08-02
429 reads
Blog Posts
SQL Server Unique Constraints With Where Conditions
Imagine we have the following table
Users
FieldTypeIdINTUsernameNVARCHARDeletedBITThen imagine we want Username to be unique for non deleted users. Normally we would...
2017-08-02
72 reads
Training and tips to get certified with Microsoft (Part 1)
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions from collegues, asking questions such as How do you...
2017-08-02
19 reads
Training and tips to get certified with Microsoft (Part 1)
In the last weeks, while I was preparing for one of the certification exams, I got a lot of questions...
2017-08-02
162 reads
Are your indexes being thwarted by mismatched datatypes?
In this series I explore scenarios that hurt SQL Server performance and show you how to avoid them. Pulled from my collection of "things I didn't know I was...
2017-08-01
28 reads
Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1
Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...
2017-08-01
499 reads
Manually updating Statistics
Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...
2017-08-01
2,458 reads
Power BI Custom Visuals Class (Module 60 – Drilldown Player)
In this module you will learn how to use the Drilldown Player Custom Visual. The Drilldown Player acts like a...
2017-08-01 (first published: 2017-07-18)
1,729 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in SQL Server using regex, and now I’m showing how...
2017-08-01
229 reads
RegEx in SQL Server for replacing text
In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...
2017-08-01
60,104 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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