Figure out the Blocking issue
This script will help you to get the culprit along with IP address and User name which helps us to determine the Blocking root cause.
2015-10-14 (first published: 2013-12-08)
4,413 reads
Rajib Kundu
- Interests: Movie Watch and Cricket playing
How we can move the login which has Sysadmin role.
We are using sp_help_revlogin to make login script, but it doesn't enable the login which has sysadmin role. It is very common problem during server migration. We use the this technique to solve the issue.
2013-12-09 (first published: 2013-11-29)
1,031 reads
Blogs
Monday Monitor Tips: AI Alert Analysis
By Steve Jones
We keep adding new AI capabilities to Redgate Monitor, where it makes sense. Check...
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
Forums
Bank BCA KCU Bukit Barisan telp 0817 844 112
WhatsApp CS,0817844112 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara...
Bank BCA KCU Asia telp 0817 844 112
WhatsApp CS,0817844112 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec....
Bank BCA KCU Medan telp 0817 844 112
WhatsApp CS,0817844112 Jl. Pangeran Diponegoro No.15, Petisah Tengah, Kec. Medan Petisah, Kota Medan, Sumatera...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers