Prakash Heda

Prakash Heda works as Sr. Database Administrator at Advent Software. His expertise includes Performance Tuning/Troubleshooting, high availability, SAN configuration and windows administration. He has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Prakash holds certifications for MCDBA and MCITP. His background includes administration & development using VB/ASP/SSIS using SQL Server 2000, 2005 and 2008/R2 and SQL server 2012. He is an active member of PASS, SQL Saturday. He’s a frequent presenter at user groups, SQL Saturdays, and other community events. He is also an avid tweeter, blogger and runner.
  • Interests: Computers, Chess, Reading

All authors

All authors

Blogs

T-SQL Tuesday #202: 100 Hours

By

It’s time for T-SQL Tuesday again and this is a great prompt to start...

T-SQL Tuesday

By

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search

By

How I used AI for this postChatGPT to generate images based on info specifically...

Read the latest Blogs

Forums

Alamat BCA KCP Menara Imperium Telp:0821-8200-233

By layanan_Bca88

Telp/Wa 62 821-8200-233 Jl. H. R. Rasuna Said No.Kav. 01, RW.6, Guntur, Kecamatan Setiabudi,...

Alamat BCA KCP Sejati Mulia Telp:0821-8200-203

By m4rt1n4

Telp/Wa 62 821-8200-203 Koperasi Sejati Mulia, Jl. Raya Ragunan B 1, RT.3/RW.3, Jati Padang,...

Alamat BCA KCP Graha Inti Fauzi Telp:0821-8200-174

By R4nt4u

Telp/Wa 62 821-8200-174 Gd. Graha Inti Fauzi, Jl. Buncit Raya No.22 Lt. Dasar, RT.2/RW.7,...

Visit the forum

Question of the Day

Adding new column with DEFAULT

Which number will the COUNT() return after executing the following statements: 

DROP TABLE IF EXISTS #test;
CREATE TABLE #test (id INT)
INSERT INTO #test (id)
SELECT *
  FROM GENERATE_SERIES(1, 3) AS gs
;

ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0;
go
UPDATE #test SET flag = 0 WHERE id = 1
UPDATE #test SET flag = 1 WHERE id = 2

INSERT INTO #test (id) VALUES (4)

SELECT COUNT(*)
  FROM #test AS t
 WHERE flag = 0
 

See possible answers