Mission Accomplished – Well sort of …
Did you ever set a goal and then sort of … demolish it without realizing it? That has happened this year....
2010-08-26
347 reads
Generate Insert Query in SQL
Sometimes we need to generate the INSERT script in sql server. When, we need to insert bulk of data from...
2010-08-26
3,264 reads
PASS Elections Portal
I think the shirt says it all
If you’ve been under a rock the last few weeks you may not know...
2010-08-25
532 reads
Changing of the Guard
A few weeks ago Andy Leonard (Blog | Twitter) announced that he was stepping down from his position as PASS Regional...
2010-08-25
383 reads
Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,472 reads
You Don’t Need Log Backups
You don’t need log backups. You don’t. They aren’t required for SQL Server to function.
The place when you don’t need...
2010-08-25
747 reads
SQL Pass Voting forum
So far I have seen lots of blogs about SQLPASS regarding the Slate for this years BoD. I do not...
2010-08-25
721 reads
Book Review: The Secret Service: The Hidden History of an Engimatic Agency
I picked up The Secret Service: The Hidden History of an Engimatic Agency $13 @ Amazon) from the library, had been...
2010-08-25
650 reads
MDX Puzzle #6
As we continue with the puzzles, I will continue to introduce new MDX functions. In this puzzle the requirements are...
2010-08-25
634 reads
Mission Accomplished... Well sort of..
Did you ever set a goal and then sort of … demolish it without realizing it?
That has happened this year....
2010-08-25
362 reads
Blogs
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Forums
Alamat BCA KCP Abdul Muis Telp/Wa:08218520154
Alamat: Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I Suite 101, RT.2/RW.8,...
Alamat BCA KCP Sabang Telp/Wa:08218520154
Alamat: Jl. H. Agus Salim No.57 B, RT.3/RW.1, Kb. Sirih, Kec. Menteng, Kota Jakarta...
Alamat BCA KCP Kebon Sirih Telp/Wa:08218520154
Alamat: Plaza Pupuk Kaltim, Jl. Kebon Sirih No.6A Gedung B Lantai 1, RT.14/RW.2, Gambir,...
Question of the Day
Adding new column with DEFAULT II
Which number did the two COUNT(*) return:
DROP TABLE IF EXISTS #tmp CREATE TABLE #tmp (id INT NOT NULL) INSERT INTO #tmp (id) SELECT gs.value FROM GENERATE_SERIES(1, 5) AS gs ALTER TABLE #tmp ADD my_value INT NOT NULL CONSTRAINT df_tmp_my_value DEFAULT 1 SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1 ALTER TABLE #tmp DROP CONSTRAINT df_tmp_my_value ALTER TABLE #tmp ADD CONSTRAINT df_tmp_my_value DEFAULT 2 FOR my_value SELECT COUNT(*) FROM #tmp AS t WHERE my_value = 1See possible answers