Performance Tuning with sp_BlitzIndex
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,309 reads
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,309 reads
New Year, new powerful SQL queries!
Start the New Year off with some great Transact-SQL training and join me for...
2015-12-07
462 reads
What's New in SQL Server 2016
Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...
2015-12-07
138 reads
Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...
2015-12-03
1,422 reads
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...
2015-12-03
23 reads
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...
2015-12-03
3,028 reads
I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic,...
2015-12-03
577 reads
This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....
2015-12-03
563 reads
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
506 reads
Yet another late night/early morning tale...
The LOG backups for multiple databases on a server failed overnight (not all databases, but...
2015-12-03
988 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Helping an English Student with...
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