Skip to main content

Isolation Levels in SQL server

Types of isolations available in SQL Server.
  • READ COMMITTED
  • READ UNCOMMITTED
  • REPEATABLE READ
  • SERIALIZABLE
  • SNAPSHOT
Labels:

Comments

Post a Comment

Popular posts from this blog

Data Science and Data Scientist

Data Science:- When we combine domain expertise and scientific methods with technology, we get Data Science. Data Science Data Scientist:- Data Scientists collect data and explore, analyze, and visualize it. They apply mathematical and statistical models to find patterns and solutions in the data. Data Scientist
Post a Comment
Read more

Darts: Time Series Analysis made easy

  Dart: Sci-kit learn for Time Series Analysis It comprises all the API required for Time series analysis and its primary goal is to simplify the time series machine learning experience. Darts in not inbuilt, so install it using " pip install u8darts" In [4]: import pandas as pd from darts import TimeSeries Like pandas has DataFrame, Similarly, Darts has TimeSeries In [7]: df = pd . read_csv ( '../input/air-passengers/AirPassengers.csv' ) Series = TimeSeries . from_dataframe ( df , 'Month' , '#Passengers' ) This timeseries is univariate, containing only one variable. Splitting the series into training and validation TimeSeries In [9]: train , val = Series . split_before ( pd . Timestamp ( '19580101' )) Models All the time series models: Exponential smoothing, ARIMA & auto-ARIMA, Facebook Prophet, Theta method, FFT (Fast Fourier Transform), Recurrent neural networks (vanilla RNNs, GRU, and LSTM variants), Temporal Convol...
Post a Comment
Read more

Class Weights for Handling Imbalanced Datasets

In scikit-learn, a lot of classifiers come with a built-in method of handling imbalanced classes. If we have highly imbalanced classes and have not addressed it during preprocessing, we have the option of using the class_weight parameter to weight the classes to make certain we have a balanced mix of each class. Specifically, the balanced argument will automatically weigh classes inversely proportional to their frequency. import numpy as np import pandas as pd import seaborn as sns import warnings from imblearn.over_sampling import SMOTE from imblearn.pipeline import make_pipeline from pylab import rcParams from sklearn.linear_model import LogisticRegression from sklearn.metrics import accuracy_score from sklearn.metrics import precision_score , recall_score from sklearn.metrics import f1_score , roc_auc_score , roc_curve from sklearn.model_selection import train_test_split from sklearn.model_selection import GridSearchCV In [2]:...
Post a Comment
Read more