Quick Way to Rebuild SQL Server Master Database
All the system-level configuration settings and login account information of SQL server are stored in the corresponding SQL Master Database...
2018-05-29
20,689 reads
Azure PowerShell – List Virtual Machine Sizes
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that you need to get right but are unsure of...
2018-05-29
144 reads
Azure PowerShell – List Virtual Machine Sizes
For those who use PowerShell to do things in Azure you will know that occasionally there is a parameter that...
2018-06-07 (first published: 2018-05-29)
1,805 reads
What Does The GO Command Do?
Watch this week’s episode on YouTube.
When I started working with T-SQL, I thought the GO command was optional, kind of...
2018-06-08 (first published: 2018-05-29)
3,776 reads
What Does The GO Command Do?
Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...
2018-05-29
38 reads
What Does The GO Command Do?
Watch this week's video on YouTube
When I started working with T-SQL, I thought the GO command was optional, kind of like semicolons. It appeared in plenty of SSMS generated...
2018-05-29
29 reads
Introduction to Biml – Webinar
On Thursday June 7th I’ll be giving a webinar for MSSQLTips.com (7PM UTC). The topic is Introduction to Biml – Generating your...
2018-05-29
259 reads
Triggers vs. Default Constraints: Choose Wisely
Triggers can be really useful in your database but you have to be careful with them. We often use them to record history to a separate table (at least,...
2018-05-29
49 reads
Interview questions: What’s the first thing you would do if a user reports slowness.
We’ve been doing a fair amount of interviewing recently and one of our big questions is What do you do...
2018-06-08 (first published: 2018-05-28)
4,104 reads
Monday morning comic 2018-05-28
It always seems that when I give a talk on performance there are 100+ people packed in the room but...
2018-05-28
277 reads
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