Installing SQL Server 2008 on a machine with .NET Framework 4.0? Read this.
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,073 reads
The SQL Server Premier Field Engineer blog has a post about an issue with installing SQL Server 2008 on a...
2013-09-23
2,073 reads
MDX with SSAS 2012 Cookbook
by Sherry Li and Tomislav Piasevoli
Packt Publishing 2013
The book is now available in both paperback...
2013-09-22
1,409 reads
I don’t have a definition of what is considered a large SQL table. I am pretty sure, however, that a...
2013-09-22
5,059 reads
For many organizations, data is the lifeblood that keeps them in business. If the data becomes imperiled, the very existence of the organization is threatened. The folks entrusted with...
2013-09-22
25 reads
For many organizations, data is the lifeblood that keeps them in business. If the data becomes imperiled, the very existence of the organization is threatened. The folks entrusted with...
2013-09-22
16 reads
For many organizations, data is the lifeblood that keeps them in business. If the data becomes imperiled, the very existence...
2013-09-22
523 reads
I don't know why, but I never "got" LinkedIn and I ended up leaving it in frustration as I was...
2013-09-21
729 reads
Don’t forget that most holiday’s aren’t work days.
Recently while working with a client I was faced with some seriously convoluted...
2013-09-21
1,875 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-09-20
892 reads
I have been working recently in making sure that max memory is configured for the hundred plus database servers I...
2013-09-20
1,172 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