Question :-
How many non clustered indexes are possible in a table in SQL Server 2008R2
1) 1
2) 249
3) 999 (Correct answer)
4)...
2014-01-01
1,099 reads
Question:- Suppose we have a table named tbl_charactername have only one column say "charactername".It contains 10 rows. First 5 rows contains...
2014-01-01
602 reads
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...
2014-01-01
744 reads
This is the eighth installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...
2014-01-01
9 reads
Today I'm honored to give the final prize in a month of free giveaways here, the book; Professional SQL Server 2012...
2014-01-01
335 reads
For me, 2013 was one of the most interesting and busy years of my life. It was a good year...
2014-01-01
776 reads
Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...
2014-01-01
639 reads
In this blog, I’d like to give special thanks to the people below who have taken time to write reviews...
2014-01-01
521 reads
Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli
In my prior blog post, I discussed...
2014-01-01 (first published: 2013-12-24)
1,884 reads
Earlier this morning I received a notification from the Microsoft MVP program that I’ve been recognized as a SQL Server...
2014-01-01
656 reads
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Comments posted to this topic are about the item Adding new column with DEFAULT...
Comments posted to this topic are about the item Advanced Deployment Scenarios: Stairway to...
Comments posted to this topic are about the item You Need a DBA Pipeline
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