How to Edit Read-Only Non-clustered Columnstore Data
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,139 reads
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,139 reads
As I’ve discussed in some of my previous posts, there are quite a few data types that cannot be part...
2014-07-08
780 reads
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...
2014-06-03
2,222 reads
SQL Server 2012 introduced non-clustered columnstore indexes, and SQL Server 2014 gave us clustered columnstore indexes. Both share the same...
2014-05-20
1,866 reads
First introduced in SQL Server 2012, the Columnstore index is a new in-memory feature that allows for the creation of...
2014-04-29
5,671 reads
When I first started poking around in SQL Server 2012, I noticed an extended event session called “system_health” was created...
2014-04-21 (first published: 2014-04-08)
4,085 reads
Have you ever needed to restore a large database while someone is standing over your shoulder asking “How long is...
2014-03-04
3,262 reads
Where do I begin? First let me say, WOW what an experience!
How it All Began
When I first heard about SQL...
2014-02-11
1,390 reads
In a previous post, Collecting Historical Wait Statistics, I discussed how you can easily collect historical wait stats by using...
2013-12-17
1,491 reads
As a DBA, I'm sure you've heard many times to always check the sys.dm_os_wait_stats DMV to help diagnose performance issues...
2013-12-16 (first published: 2013-12-11)
2,532 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
I wrote about this several years ago but will contribute again a life hack...
Hi I have this query that is slow during the 'not in' part of...
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