Fix for index corruption issue || SQL Server 2012 Service Pack 2
ISSUE : FIX for Data loss in clustered index occurs when you run online build index in SQL Server 2012
Microsoft release...
2014-06-24
889 reads
Rohit Garg
SQL Server 2012 || Contained Database
Contained databases are the new feature in SQL Server 2012 and are defined on BOL (http://technet.microsoft.com/en-us/library/ff929071.aspx) as below :
A contained...
2014-06-23
9,285 reads
ColumnStore Indexe with SQL Server 2012 & 2014
ColumnStore Indexes (Run By Microsoft’s VertiPaq technology) as described by BOL (http://msdn.microsoft.com/en-IN/library/gg492088(v=sql.110).aspx) :
“An xVelocity memory optimized ColumnStore index, groups and...
2014-06-16
2,378 reads
Happy Anniversary!
Today, http://mssqlfun.com/ completed 2 precious years with your support & acknowledgment. It’s wonderful time enriched with fun & learning.
Please keep liking us...
2014-06-12
761 reads
Mainstream Support Ending Soon || SQL Server 2008 and SQL Server 2008 R2
Microsoft declares to release last & final service packs for SQL Server 2008 and SQL Server 2008 R2 very soon.
Mainstream Support...
2014-06-12
923 reads
SQL Server 2012 Service Pack 2 (SP2) RTM Is Now Available !
SQL Server 2012 Service Pack 2 (SP2) RTM is now available for download at the Microsoft Support site. Service Pack...
2014-06-12
1,491 reads
SQL Server 2014 – How to Add node to failover cluster ?
Steps for SQL Server 2014 Cluster Installation – Add Node to Failover Cluster:-
1) Lunch SQL Server Installation Center
2) Enter Product Key
3)...
2014-06-09
2,422 reads
SQL Server 2014 Cluster Installation Steps
Steps for SQL Server 2014 Cluster Installation :-
1) Lunch SQL Server Installation Center
2) Enter Product Key
3) Accept License
4) Check Global...
2014-06-03
12,591 reads
Database Backup Encryption with SQL Server 2014
A brand new & long awaited feature “Backup Encryption” along with SQL Server 2014. Microsoft reveled this upcoming feature in PASS...
2014-05-26 (first published: 2014-05-19)
5,743 reads
How Database Mail works in SQL Server ?
Database Mail is email feature in SQL Server from SQL Server 2005 onwards. This feature used for mailing alerts, notification,...
2014-05-26
1,048 reads
Blogs
T-SQL Tuesday #193 - Notes to Self
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
T-SQL Tuesday #193 – Notes to my past self and from my future self
By DataOnWheels
It has been a while since my last T-SQL Tuesday blog. When I saw...
T-SQL Tuesday #193 – Notes to past and future me
The last T-SQL Tuesday of the year is hosted by my good friend Mike...
Forums
What is the PRODUCT
Comments posted to this topic are about the item What is the PRODUCT
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Metadata Driven Pipelines (Incremental Load): The Fabric Modern Data Platform
Comments posted to this topic are about the item Metadata Driven Pipelines (Incremental Load):...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers