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
887 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,281 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
759 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
921 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,489 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,419 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,588 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,741 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,041 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Parameter sniffing issue with different minutes as opposed to using midnight
Hej, I'm not facing this issue but as I was working another parameter sniffing...
Some query values change when query is run but not others. Why?
Hi everyone I have a 1000 line SQL query that is too long to...
using different credentials when debugging ssis
hi, now and then i want one connection in my ssis pkgs to use...