X-XMLA: vi. Processing and Out-of-Line Bindings in XMLA
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
809 reads
In this post, I will progressively go through processing a partition from full process, to incremental process, and finally to...
2012-09-19
809 reads
Tomorrow Brian Knight and I will kick off 24 hours of PASS with a session on Choosing a Microsoft Reporting...
2012-09-19
1,189 reads
Querying Microsoft SQL Server : Defining Variables: Defining Variables in SQL Server: Like other programming languages T-SQL allows to defining your...
2012-09-19
766 reads
Upgrading fulltext data from a SQL Server 2005 database to SQL Server 2012 by restoring a database backup.
The full database...
2012-09-19
933 reads
SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases...
2012-09-19
2,405 reads
This last year or so I have been backing up my important files to cloud. I started using SkyDrive and...
2012-09-19
661 reads
Imagine that you use a piece of software as part of your work, but it’s not what you consider the...
2012-09-19
717 reads
Today we got an escalation where on one of the servers ‘Agent XPs’ was in a disabled state. And when...
2012-09-19
433 reads
Last Friday Lenovo told me my new laptop would ship this Monday, or “much much sooner”. Monday I called to...
2012-09-19
812 reads
Today I have uploaded my 3rd SQL Server Quickie to YouTube. In this episode I’m talking about Allocation Units in...
2012-09-18
621 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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