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
818 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
330 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
322 reads
Blogs
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Daily Coping 4 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Which configuration changes in SQL Server require a restart?
SQL Server is a complex beast, with many configuration options that can range from...
Forums
Azure SQL Managed Instance Features
Comments posted to this topic are about the item Azure SQL Managed Instance Features
Backing up SQL Express with batch file and SQL procedure.
I have a procedure to back up a SQL Express database. It works when...
Missing cmdlet in powershell module sqlserver
I have succesfully installed the module sqlserver version 21.1.18235 on my server which hosts...
Ask SSC