Counting NULLs
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...
2018-07-16
1,052 reads
Recently I was doing one of Kendra Little’s (b/t) SQL Server quizzes. Specifically the Quiz: COUNT() in SQL Server. As...
2018-07-16
1,052 reads
For this month’s homework let’s try something a bit different. SQL Agent jobs are a very powerful tool frequently used...
2018-07-13 (first published: 2018-07-02)
1,997 reads
This crossword puzzle is based on the contents of the Stairway to AlwaysOn.
2018-07-11
153 reads
I thought for the end of the month it would be fun to do another T-SQL Puzzle. In this case...
2018-07-04 (first published: 2018-06-27)
2,165 reads
A common mistake, and one I make frequently myself is to use a string in place of an identifier, or...
2018-07-02 (first published: 2018-06-20)
3,368 reads
When I think of the public role I often think of the guest database principal (user) at the same time....
2018-06-25
271 reads
For this month’s t-sql Tuesday our host Bjoern Peters (b/t) wants us to describe our experiences with Azure SQL Database...
2018-06-22 (first published: 2018-06-12)
2,393 reads
In general, the errors SQL gives are highly useful. Of course every now and again you get one that’s just...
2018-06-18
785 reads
I was talking about interviews (although not the job kind) with a friend and it reminded me of the time...
2018-06-15 (first published: 2018-05-30)
2,872 reads
tl;dr; When doing an insert across a linked server you have to include the list of fields to be inserted...
2018-06-14
310 reads
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Comments posted to this topic are about the item Enable a Disabled Index
Comments posted to this topic are about the item Diving Deeper into the Import...
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers