Yes, pulling just the data you need is really important.
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
2019-04-24
343 reads
I was asked the other day why a customer was having performance issues on a table. A simple SELECT that ... Continue reading
2019-04-24
343 reads
This is my second interview! This time with Andre who is a cat lover and great speaker! Here you can find the interview!
2019-04-24
56 reads
I got a question recently about a panel discussion on Database Development Disasters at SQL in the City Streamed. I had framed a question as, “how fast should development...
2019-04-23
30 reads
My certification came in! I’m now accredited to provide training for the Certified Information Systems Auditor (CISA) certification. It’s not the Microsoft Certified Trainer (MCT) accreditation I once had...
2019-04-23
46 reads
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for every value they join on....
2019-05-07 (first published: 2019-04-23)
1,775 reads
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
29 reads
Watch this week's video on YouTube
Correlated subqueries provide an intuitive syntax for writing queries that return related data. However, they often perform poorly due to needing to execute once for...
2019-04-23
23 reads
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
45 reads
It was an Easter Monday yesterday and I thought it was not a good time to prepare a blog post. It was a time to rest with the family...
2019-04-22
27 reads
I am happy to announce that I will be speaking at SQL Saturday Raleigh this Saturday, April 27, 2019. I have been part of the organizing team for this...
2019-04-22
35 reads
Recently, in an attempt to thwart leechers (1990s kids will know), I added some...
Once upon a time I had a series about some cool stuff in Snowflake:...
By Steve Jones
“Most overnight successes – in fact any significant successes – take at least 5...
Comments posted to this topic are about the item Why Successful SQL Server Backups...
Comments posted to this topic are about the item Adding Bits II
Comments posted to this topic are about the item An Unlimited Token Budget
I have a table, dbo.bittest, where I am testing an application response. This has this structure:
CREATE TABLE [dbo].[BitTest] ( [insertdate] [datetime] NULL CONSTRAINT [DF__BitTest__insertd__300F11AC] DEFAULT (getdate()), [a] [bit] NULL ) ON [PRIMARY] GOMy application runs this code:
INSERT dbo.BitTest
(
insertdate,
a
)
VALUES
(DEFAULT, true)
GO
See possible answers