From Google Reader to Feedly
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
647 reads
I shifted to Reader about a year ago mainly for the ability to access my feeds on multiple devices. I’ll...
2013-05-16
647 reads
sys.dm_tran_database_transactions DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms186957.aspx
Returns information about transactions at the database level.
Some time , T-log...
2013-05-16
2,020 reads
I have always been a big fan of Xp_readerrorlog. The simple reason is that it much faster to read errorlog...
2013-05-16
1,731 reads
Ever jump on a machine to connect to a SQL Server and find out… whoops! No tools. For some reason,...
2013-05-15
967 reads
We are planning to take SSAS cube database backup since our backup tool does full file system backup in case...
2013-05-15
10,888 reads
Someone suggested Newsblur to me, and I went to their home page. Like many sites, it asks you to sign...
2013-05-15
833 reads
I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...
2013-05-22 (first published: 2013-05-15)
2,786 reads
I received an email from a connection on LinkedIn seeking some advice for architecture on a new reporting system. Although...
2013-05-15
636 reads
So I was studying for the 70-451 and ended up reading the BOL entry for CREATE SCHEMA. I honestly can’t...
2013-05-21 (first published: 2013-05-15)
4,146 reads
This info should be easier to get than it is. Keep in mind that for something to run the subscription...
2013-05-15
1,325 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