SQL Query Result Order
Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...
2013-06-05
659 reads
Every time an SQL query is run without the ORDER BY clause, the sort order of the results returned is...
2013-06-05
659 reads
Some of you may recall in January I ran a series of interviews entitled “New Year Aspirations”. This interview was...
2013-06-05
878 reads
Easy way to generate a restore script.
I was asked today if I had a canned restore script handy. I don’t....
2013-06-05
1,011 reads
Let’s get started with the next step in the series: installing SharePoint. We will install only the software, but we...
2013-06-10 (first published: 2013-06-05)
2,302 reads
SQLSaturday 200 is already looking further away in the rear view mirror, but it was a great event!
Joey D'Antoni, Sebastian...
2013-06-05
971 reads
This is my reinterpretation of the documentation on NuGet.org, modified to remove the public publishing steps, and to add local...
2013-06-05
25,189 reads
I'm processing through my notes for the 2013 Techno Security Conference, which is finishing up today with post-cons. Of all...
2013-06-05
1,169 reads
The CHOOSE command is new in the T-SQL as of SQL Server 2012. I hadn’t ever had the chance to...
2013-06-04
1,372 reads
SQL Saturday Baton Rouge Call for Speakers is open through June 6 (closes June 7 at midnight).
This year's pre-conference banquet...
2013-06-04
680 reads
Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of...
2013-06-04
2,808 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