#ReadyRoll at #SQLintheCity
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source...
2017-01-30
788 reads
When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source...
2017-01-30
788 reads
One of the other DBAs I work with noticed a warning message that was flooding the log files on one...
2017-01-30
1,898 reads
In case you hadn’t noticed, I love built in help. DBCC HELP, the script button in SSMS, even BOL. Well...
2017-01-30
691 reads
This is not an article or a script. I am posting this just to share my experience and I feel...
2017-01-30
994 reads
Wow, what a week last week was.
The biggest thing that happened was that I got a session at SQL Saturday...
2017-01-30
583 reads
Recently I was running a health check on one of my clients SQL Servers and I noticed that access to...
2017-01-30
3,126 reads
[2017-Jan-29] It came as a request from one of my customers where I had worked as a consultant to quickly compare...
2017-01-29
2,789 reads
SQLServerCentral recently published Something I learned while unemployed. Written by Rod Falanga, it has lessons worth learning about making time to...
2017-01-28
833 reads
Next table shows how SQL stands with the other technologies. The data is taken from StackOverflow.Data charted looks like in the...
2017-01-28
457 reads
I’ve seen quite a lot of usage of both functions in the T-SQL codes. However, their usage sometimes matters. The expectation from @@IDENTITY can sometimes not be the desired. This...
2017-01-27
16 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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