Bug with STATISTICS TIME?
I love the STATISTICS IO and STATISTICS TIME commands. They are such a powerful and easy way to be able...
2017-10-17
531 reads
Blog Posts
How to Make SQL Server Act Like A Human By Using WAITFOR
Photo by Fischer Twins on Unsplash
You probably tune your queries for maximum performance. You take pride in knowing how to add indexes and refactor code in order to squeeze out every last...
2017-10-17
29 reads
How to Make SQL Server Act Like A Human By Using WAITFOR
Photo by Fischer Twins on UnsplashYou probably tune your queries for maximum performance. You take pride in knowing how to add indexes and...
2017-10-17
214 reads
Linked Servers and Stats
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and remote servers. There is a time and a place for...
2017-10-17
257 reads
Linked Servers and Stats
Linked Servers
A linked server is a fabulous feature in SQL Server to help accomplish various data tasks between local and...
2017-10-17
1,524 reads
Microsoft Ignite Big Data Presentations
There were so many good presentations at Microsoft Ignite, all of which can be viewed on-demand. I wanted to list...
2017-10-17
1,490 reads
Monitoring SQL Server database status changes using T-SQL and PowerShell scripts
Monitoring a SQL Server database is a critical component of database administration. Ninety percent of the organizations expect the number...
2017-10-17
921 reads
Performing in-database predictions in SQL Server 2016 & 2017
Starting from SQL Server 2016 Microsoft put a lot of effort into integrating various languages used in machine learning and...
2017-10-17
2,069 reads
Power BI Custom Visuals Class (Module 72 – HTML Viewer)
In this module you will learn how to use the HTML Viewer. The HTML Viewer allows you to display the...
2017-10-17 (first published: 2017-10-09)
1,824 reads
Quick SQL Prompt Updates in a Pattern
I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things...
2017-10-17
1,158 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