In which we compare CISPA to Rick Astley
Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....
2013-04-20
601 reads
Wherever you click, either CISPA or Rick Astley is there…
I’m studying up on CISPA for a segment on our webshow....
2013-04-20
601 reads
Today I will discuss about an issue which was observed while creating a linked server via script.
The existing linked server was scripted...
2013-04-19
1,332 reads
I wish this were the mantra of all people, but certainly those in technology:
Filed under: Blog Tagged: career, syndicated
2013-04-19
771 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-04-19
883 reads
I have a very busy next week in the works! Here are the upcoming speaking engagements that I am working...
2013-04-19
679 reads
Both Clustered and Nonclustered Indexes have same physical structure in SQL Server. Both are stored as a B-Tree structure in...
2013-04-19
1,950 reads
The 6th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-04-19
1,693 reads
This is an off-topic post for a Friday. With Cardiff City reaching the premier league this week and all the...
2013-04-19
618 reads
If you can establish a connection to a SQL Server, but are having problems logging in to it, you will...
2013-04-30 (first published: 2013-04-18)
2,609 reads
When I first started working with Azure SQL Databases, I wasn’t sure what it would take to backup a database....
2013-04-18
1,826 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