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
892 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,291 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,382 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
763 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
925 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,497 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,424 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,593 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,747 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,065 reads
Blogs
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers