SQL Puzzle – Prime Numbers
My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word...
2017-09-27
451 reads
Kenneth Fisher
Saving and restoring session options settings
There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations....
2017-09-25
429 reads
Uniquifier is a rather unique word isn’t it?
tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique.
Uniquifier is a rather funny name,...
2017-09-22 (first published: 2017-09-18)
1,652 reads
Do what I say, not what I do
I told you not to use NOLOCK even though I use it sometimes.I told you not to shrink databases, even...
2017-09-20
431 reads
Help! My query is too fast!
Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of...
2017-09-20 (first published: 2017-09-14)
3,219 reads
Turn on/off Azure VMs with Powershell
T-SQL Tuesday has rolled up on us yet again. This month it’s Rob Sewell’s (b/t) turn to host and picked...
2017-09-12
434 reads
Create an empty table from a SELECT statement but without the IDENTITY.
A while back I did a post about creating an empty table using a SELECT statement. Basically doing something like...
2017-09-11 (first published: 2017-08-28)
3,045 reads
There EXISTS a place where SELECT 1/0 doesn’t return an error.
Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical...
2017-09-07
651 reads
Changing the version of an SSIS package.
Of all of the annoying parts of SSIS, the major version sensitivity has to be the most annoying. Let’s say...
2017-09-06 (first published: 2017-08-23)
2,772 reads
2017-09-06
245 reads
Blogs
Denver Dev Day Oct 2024 Slides
By Steve Jones
Here are the slides from my talk today: CI in Azure DevOps If you...
Should I Learn PostgreSQL
By Steve Jones
I got asked this question recently: I constantly see PostgreSQL on Microsoft slides, email,...
A New Word: Hickering
By Steve Jones
hickering – n. the habit of falling hard for whatever pretty new acquaintance happens...
Forums
Are We Dinosaurs?
Comments posted to this topic are about the item Are We Dinosaurs?
how to solve a conversion failure error
Sample query reply appreciated Getting the following error: Conversion failed when converting the varchar...
Why does SSMS always pop up this window every time I get into it?
For the last few weeks every time I get into SSMS 20.2 I am...
Question of the Day
Code Blocks
What happens with this code:
DECLARE @Iteration INT = 0;
WHILE @Iteration < 10
SELECT CustomerName,
CustomerStatus
FROM dbo.Customer
WHERE CustomerID > 3;
SET @Iteration += 1;
See possible answers