Columnstore Indexes – part 78 (“Temporary Objects”)
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
501 reads
Continuation from the previous 77 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I have decided to spend some time...
2016-03-05
501 reads
To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days...
2016-02-26
882 reads
Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...
2016-02-23
690 reads
Continuation from the previous 75 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
While playing with SQL Server 2016 CTP...
2016-02-04
791 reads
After the initial release of the SQL Server Maintenance Solution in CISL 1.1.0, I felt that a separate blog post...
2016-01-24
637 reads
Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...
2016-01-14
443 reads
After a very long waiting period, I have finally released the initial version of my Columnstore Maintenance solution for SQL...
2016-01-11
400 reads
Sometimes one receives amazing gifts at the most unexpected moment. I was beyond thrilled to find out that I was...
2015-12-30
833 reads
Another year is coming to an end and I am doing a review of which goals I have managed to...
2015-12-27
765 reads
Continuation from the previous 74 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post focuses on one of...
2015-12-26
531 reads
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers