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
691 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,477 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 Sumedang Cs 0823-74977784
Wa:082374977784 Jl. Mayor Abdurahman No.181-183, Kotakaler, Kec. Sumedang Utara, Kabupaten Sumedang, Jawa Barat 45322
Telp BCA KCP Kelapa Gading Cs 0823-74977784
Wa:082374977784 Jl, Jl. Boulevard Raya Blok FX No.9-10, RT.8/RW.13, Klp. Gading Tim., Kec. Klp....
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers