Reblog: April 26 to May 2
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-03
1,080 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-05-03
1,080 reads
The SQL Server Management Studio built-in standard report for "Disk Usage" is very handy to view the performance-sucking autogrowth events...
2013-05-03
2,441 reads
This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...
2013-05-09 (first published: 2013-05-03)
2,605 reads
I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...
2013-05-08 (first published: 2013-05-03)
5,936 reads
I’m generally not a great fan of Activity Monitor which is built in with SSMS,however today I wanted to check...
2013-05-02
3,454 reads
I greatly enjoy doing presentations on a variety of topics, such as Business Intelligence, SQL Server, and personal development. If you...
2013-05-02
721 reads
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-05-02
690 reads
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the storage system to ensure what has been read from...
2013-05-02
14 reads
A checksum value is tagged with every data page in SQL Server. This is used to detect issues on the...
2013-05-02
1,944 reads
Reblogged from Prashanth Jayaram :
This article walks through how to list SQL Server configurable and non-configurable instance settings using PowerShell...
2013-05-01
2,933 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers