Skip to content

Data World

Drive Into Data

  • Home
  • About Me
Data World

Month: December 2015

SQL Server -Defragment Indexes

December 17, 2015 parmsingla Uncategorized

Problem: Many a times you need to defragment indexes on SQL server. Following query is quite handy for doing this[…]

Read more

SQL Server -Find Blocking

December 17, 2015 parmsingla Uncategorized

Problem: Many a times DBA/Developer needs to identify the blocking in SQL server. Following queries will help you out. Solution:[…]

Read more

SSAS-Find blocking onSSAS Tabular server

December 16, 2015 parmsingla Uncategorized

Problem: How to find blocking on SSAS Tabular server? Solution: Option1: select *from $system.discover_locks  where lock_status=0 Option2: SELECT [SESSION_COMMAND_COUNT], [SESSION_CONNECTION_ID], [SESSION_CPU_TIME_MS],[…]

Read more

Hadoop: Check version

December 11, 2015 parmsingla Uncategorized

Problem: How to check the version of the Hadoop installed in your environment? Solution: ps -ef |grep Hadoop

Read more

Spark: Check version of Spark on CDH

December 11, 2015 parmsingla Spark

Problem: How to check the version of the spark installed in your environment? Solution: Search for “spark-shell” in file system. in[…]

Read more
Categories
  • Artificial Intelligence
  • Azure
  • Big Data
  • Certifications
  • Databricks
  • DP-203
  • Interview Questions
  • Leadership
  • LLMs
  • Machine Learning
  • Motivational
  • Performance Tuning
  • Python
  • Scripts
  • Spark
  • SQL Server
  • SSIS
  • Synapse
  • Uncategorized
Archives
  • March 2023
  • July 2022
  • September 2018
  • May 2018
  • January 2018
  • October 2017
  • August 2017
  • March 2017
  • December 2016
  • August 2016
  • May 2016
  • December 2015
  • November 2015
  • June 2015
  • August 2014
  • August 2013
  • January 2013
  • October 2012
  • June 2012
  • February 2012
  • May 2011
WordPress Theme: Poseidon by ThemeZee.
Follow by Email
Facebook
fb-share-icon
LinkedIn
LinkedIn
Share
Data World
Proudly powered by WordPress Theme: Poseidon.