Index Management
This article demonstrates an Index Management strategy to tackle day to day performance issues due to improper indexes.
2011-06-10 (first published: 2009-10-20)
25,446 reads
sql frenzy
View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,515 reads
Estimating the table size...
This is an effort to program the "Estimating the Table size" section given in BOL.
2009-07-06 (first published: 2009-06-19)
1,808 reads
2008-11-25 (first published: 2008-10-20)
1,326 reads
Blogs
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...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
BCA KCP Ngawi | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. PB. Sudirman No. 74 RT 003 RW 002, Kec. Ngawi, Kab. Ngawi...
Converting Money
Comments posted to this topic are about the item Converting Money
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
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