A Speaking Sabbatical
Lately I’ve been thinking about taking a break from doing presentations. Not sure what triggered it – maybe just a sense...
2016-04-20
632 reads
Lately I’ve been thinking about taking a break from doing presentations. Not sure what triggered it – maybe just a sense...
2016-04-20
632 reads
If you read the March PASS Board meeting minutes, you saw that there was a discussion around board members and...
2016-04-20
506 reads
In MongoDB we have to use either insert() or save() method to add the document to a collection
Insert Single document
> db.employee.insert(
{"employee_id":1101,
"name":"Prashanth",
"sal":90000,
"dob": newDate(1983,2,3,5,20),
"department":
[
'DB Amdin','DB Developer'
],
"Location":"New York"});
Insert Multiple...
2016-04-20
742 reads
I drove to Clearwater (and back) yesterday to attend and present to the Pinellas SQL group. Misc notes from the...
2016-04-20
529 reads
Me: I think I’m going create a new playground instance.
Myself: Make sure you use a case sensitive (CS) collation when...
2016-04-20
422 reads
I just want to write the setup I went through for using debug symbols within SQL Server to resolve call...
2016-04-20
237 reads
SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version.SQL folks in general,...
2016-04-19
1,796 reads
SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version. SQL folks in general, usually don’t take them as handy, or maybe...
2016-04-19
62 reads
SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version. SQL folks in general, usually don’t take them as handy, or maybe...
2016-04-19
33 reads
SQL Server has plenty of reports. Reports extended more with the occurrence of the SQL Server 2012 version.
SQL folks in general,...
2016-04-19
212 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