Columnstore Indexes – part 116 (“Partitioning Specifics”)
Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/
After delaying for a couple of years...
2017-12-28
527 reads
The case of the missing database backup file
Exploring the wonderful case of a missing database backup.
I was working on a client’s site today, setting up database backup...
2017-12-27
579 reads
Power BI Custom Visuals Class (Module 83 – ChartAccent – LineChart)
In this module you will learn how to use the ChartAccent LineChart Custom Visual. This visual is a custom line...
2017-12-27
1,261 reads
No moving parts, the story of persistent memory
In November 2017, during the PASS Summit keynote, Microsoft’s Bob Ward (Principal Architect) demonstrated a “diskless database” running on Hewlett-Packard...
2017-12-27
384 reads
Message in a Bottle of XE
Considering this "feature" for everything that is SQL Server related, does this mean that all Extended Events related messages are accessible in sys.messages?
Related Posts:
Implicit Conversion Fail May 31, 2019...
2017-12-27
11 reads
Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
191 reads
Message in a Bottle of XE
One of the age old features that most probably take for granted in SQL Server happens to be the error...
2017-12-27
945 reads
Restoring a Copy Only Backup–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-12-27
747 reads
What is impersonation for?
I was doing some research on impersonation the other day, and among other things, I ran across a forum question...
2017-12-27
807 reads
Precon at SQLKonferenz 2018
One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz,...
2017-12-27
372 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan Resmi BCA KCU TEGAL Telp:0821°7555°651
Telp/Wa 628217555651 Jl. A. R. Hakim No.2, Mangkukusuman, Kec. Tegal Tim., Kota Tegal, Jawa...
Kantor Resmi BCA KCU SALATIGA Telp:0817°825°533
Telp/Wa 62817825533 Jl. Diponegoro No.15, Salatiga, Kec. Sidorejo, Kota Salatiga, Jawa Tengah 50711
Question of the Day
Switching Schemas 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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers