SQL Server Service Broker – Sending and Receiving
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-04-19 (first published: 2016-04-12)
1,924 reads
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-04-19 (first published: 2016-04-12)
1,924 reads
It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about...
2016-04-18 (first published: 2016-04-12)
1,696 reads
Happy Tuesday . Here's the latest technology based blogs and articles I have been reading this week. Mainly SQL Server themed...
2016-04-12
391 reads
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-04-12
115 reads
It finally comes to this date, 12th April 2016, the end of support for SQL server 2005! SQL 2005 is...
2016-04-12
692 reads
SQL Server 2005 is now out of support. I remember going to a SQL Server 2005 launch event at the...
2016-04-11
406 reads
One of my blog reader requested me to get the DB details(Server,DBName,Size,SpaceAvailable,LogSize,PercentUsed Log Space,compatiblilty mode, recovery model etc:-) using PowerShell...
2016-04-18 (first published: 2016-04-11)
1,501 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-04-15 (first published: 2016-04-11)
2,354 reads
I spoke at Visual Studio Live in Vegas on two topics. While the presentations have been uploaded to the site and were...
2016-04-11
426 reads
var sum = 0; db.getMongo().getDBs()[“databases”].forEach(function(x) { sum += db.getMongo().getDB(x.name).stats().dataSize }); print(sum );
OR
db = db.getSiblingDB(“admin”);
dbs = db.runCommand({ “listDatabases”: 1 }).databases;
var sum1=0;dbs.forEach(function(database) { sum1+=db.getMongo().getDB(database.name).stats().dataSize }); print(sum1);
2016-04-11
449 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