MSDB– cleanup is necessary
Recently I have been asked to work on the task which is to reduce the size of MSDB database. The...
2013-10-21
990 reads
is count(1) faster than count(*)?
Recently I saw a post regarding the count(1) and count(*)
http://www.sqlservercentral.com/articles/T-SQL/102474/
the post said "You know that doing COUNT(*) on a table with...
2013-10-28 (first published: 2013-10-20)
5,808 reads
Summit 2013 Review!!! plus SQLSaturday #237 Charlotte BI Edition
The week is over and I waiting for my flight home. I did not to get to as many sessions...
2013-10-20
967 reads
PASS Summit Report #16 (Mentoring)
A couple years back Steve Jones and I started The Mentoring Experiment. Our first experiments to see how effective non-local...
2013-10-19
889 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
421 reads
PASS Summit 2013-Blogger Interview With PASS Officers
On Thursday the PASS bloggers were given the chance to meet with the PASS officers and I participated along with...
2013-10-19
692 reads
PASS Summit 2013 – Day 5: SQL Server Internals Day
This is a summary of my last day in the PASS Summit. I have already written about my first, second,...
2013-10-19
440 reads
Cumulative SUM in SQL Server
Sometimes we need to find sum of first and next row in cumulative way.
Create table and insert data:
CREATE TABLE [dbo].[testsum](
...
2013-10-25 (first published: 2013-10-19)
41,478 reads
PASS Summit 2013 Report #15
Slower day today, fewer notes!
Most of my morning spent on mentoring and some networkingLunch today was Birds of a Feather,...
2013-10-18
667 reads
PASS Summit 2013–Board Q&A
PASS Board Q&A just starting. Session is being recorded – transcript will be published, no decision on whether recording will be...
2013-10-18
718 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Alamat Telp BCA KCP Benhil +62 838-4945-0961
Wa:083849450961 Jl. Bendungan Hilir No. 44/I, RT.8/RW.1, Bend. Hilir, Kecamatan Tanah Abang, Kota Jakarta...
Alamat BCA KCP Tanah Abang Blok B Telp:0821°8200°233
Telp/Wa 628218200233 Gedung Pasar Tanah Abang Blok B Lantai 5 Kios Nomor 3, 5,...
Alamat BCA KCP Juanda III Telp:0821°8200°203
Telp/Wa 628218200203 Jl. Ir. H. Juanda 3 No.34, Kb. Klp., Kecamatan Gambir, Kota Jakarta...
Question of the Day
PostgreSQL psql Meta Commands: Databases
Which of the following meta commands (sometimes called backslash or slash commands) within psql will provide you with information about the databases on the cluster?
See possible answers