Columnstore Indexes – part 70 (“Filtered Indexes in Action”)
Continuation from the previous 69 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is the continuation from...
2015-10-29
860 reads
Continuation from the previous 69 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is the continuation from...
2015-10-29
860 reads
Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address....
2015-10-29
944 reads
It’s Kilt Day!
I want to give a quick assessment on how the Summit has been for me so far. Monday,...
2015-10-29
831 reads
The focus of this article will be to introduce the default sessions deployed with SQL Server. Some of these are internal and "private" while others are more "public" and...
2015-10-29
54 reads
So I have blasted through a lot of technical articles about Extended Events. There is a lot of groundwork that...
2015-10-29
1,114 reads
There were so many updates to Power BI this month I thought I’d put all the links to the information...
2015-10-29
862 reads
There were so many updates to Power BI this month I thought I’d put all the links to the information...
2015-10-29
1,067 reads
I’m going to present my session about working with parameters in PASS Summit on Thursday at 03:15pm. The title of...
2015-10-29
858 reads
So PASS officially kicked off this morning leading into the next 3 days of back to back sessions. You could certainly tell that the keynote was on… I mean...
2015-10-29
15 reads
So PASS officially kicked off this morning leading into the next 3 days of back to back sessions.
You could certainly...
2015-10-29
861 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