70-457 Reviewer #02, What is Columnstore Index?
Columnstore index is the new type of index introduced in SQL Server 2012. It is a column based non-clustered index...
2013-07-10
820 reads
- Interests: cooking, F1 grand prix, internet, mobile apps
Unlocking “Lock Pages in Memory” Option
Consider this scenario; Your production database server is new and with super configuration of 32 CPUs, 64G RAM, SAN Storage,...
2013-07-08
331 reads
So how was your weekend?
It’s Sunday night now, weekend is almost over and was it just a few moments ago that it was Friday?...
2013-07-07
323 reads
Blogs
Registered for the Data Community Summit
By Steve Jones
I was reminded this week that I needed to get registered for the Data...
Daily Coping 5 Oct 2022
By Steve Jones
Today’s coping tip is to choose to see your mistakes as steps to help...
Restore HEADERONLY and FILELISTONLY
By gbargsley
Good day reader. This post is coming to you from a busy week in...
Forums
Change tracking - Date a row changed
We have change tracking enabled on one of our databases and I am looking...
Grant user permissions to a view but the base tables live in another database
I have two databases on the same server. I have a service account I...
The ORDER BY clause is invalid in views
Hi, I'm trying to run the below SQL code but I'm getting this error:...
Ask SSC