(Grant Fritchey) Lots of people are confused by how to deal with bad parameter sniffing when it occurs. In an effort to help with this, I’m going to try to make a decision flow chart to walk you through the process. This is a rough, quite rough, first draft.
Tag: sql server
Difference Between Rebuild and Reorganize Index in SQL Server| Fill Factor| Fragmentation in SQL Server Part 3
(Neeraj Prasad Sharma) This article helps you to understand the difference between Rebuild and Reorganize, how they are different, when to choose Rebuild the Index or Reorganize the Index, what is fill factor and what it does and more importantly we will understand all these things with Demo.
SQL SERVER – FIX: The Log for Database Cannot be Shrunk Until All Secondaries Have Moved Past the Point Where the Log was Added
(Pinal Dave) While preparing for a demo for a client I was hit with an interesting error in AlwaysOn Availability Group backup and restore scenario. In my lab setup, I had four nodes SQLAUTH1 to SQLAUTH4 and I have always on high availability turned on SQL Server 2016.
Setting up SQL Server R service (In Database) and R Server(Standalone)
(Don Castelino) Recently, I had worked on a requirement to install R services during the SQL 2016 installation. In this blog, I am covering the steps followed to install and configure R services (In database). Also, I have included steps to install R server (standalone) shared feature as part of SQL
Obscure MDX Month: Recreating The Star Ratings Measure In MDX Using Excel Functions
(Chris Webb) I still love MDX, but I’m aware that I blog about it less and less – which is a shame, I know. Therefore I’ve decided that for the next four weeks I’m going to write about some obscure MDX topics that hopefully will make all you SSAS MD diehards out there feel less neglected… even if th
Presenting a New Training Class on Architecting a Data Lake
(Melissa Coates) I’m very excited to be presenting an all-day session on Architecting a Data Lake on Friday, October 13, 2017. It is a pre-conference session as part of the annual SQLSaturday event in Charlotte, NC — which means the price is a bargain.
SQL Server Proportional Fill Algorithm Example
(Simon Liew) I have a SQL Server user database with single file group containing two data files. If I were to insert 1GB worth of data into this database, does it mean each data file will always get 500MB worth of data because of Proportional Fill algorithm in SQL Server?
SQL Server – So you like to shrink do you?
(Arun Sirpal) If you do – shame on you and shame on me because I do.
SQL SERVER – Caution: Adding Node in AlwaysOn Availability Group
(Pinal Dave) It is interesting to see that in the past few days I have seen a similar pattern of an issue hit by three clients. All of them contacted me for a short engagement for the same issue.
Connect Logic Apps to Data Lake Store using a service principal
(Jorg Klein) Since a couple of months Azure Logic Apps offers an Azure Data Lake Connector that can perform the following actions on an Azure Data Lake Store: