SQL Server 2016 available June 1st!
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
670 reads
Woo hoo! Microsoft has announced that SQL Server 2016 will be generally available on June 1st. On that date all four...
2016-05-02
670 reads
There are a multiple ways to suppress and remove the first line from text file. The first scenario would be writing...
2016-05-02
7,834 reads
August two years ago I originally posted, Make the PASS Summit Work for Your Employer. After conversations at several SQL...
2016-05-02
1,006 reads
You have a database with one or more filegroups, and one or more of those filegroups has multiple files. You’ve...
2016-05-02
1,676 reads
Microsoft dropped it on us this morning:
Get ready, SQL Server 2016 coming on June 1st
https://media.makeameme.org/created/yes-finally.jpg
I read the article and was...
2016-05-02
941 reads
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide upgrade of SQL Server. Are you thinking of upgrading...
2016-05-01
13 reads
SQL Server 2005 is out of support and you might be (Or rather, you should be) planning an enterprise wide...
2016-05-01
3,100 reads
As Bala Narasimhan from PernixData and I discussed in a webinar last week, SQL Server 2005 hit end of it’s...
2016-05-01
564 reads
[2016-Apr-30] I don't work with box plot charts very often, however when I do then it becomes a very interesting experience. First,...
2016-04-30
4,374 reads
Entity Framework (EF) is Microsoft's object-relational-mapping tool (ORM) that allows programmers to easily map database objects to C# object models. What attracts developers to Entity Framework is the automatic...
2016-04-30
25 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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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