SQL Server and Hyper-threading
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
6,060 reads
This post is about the CPU utilisation in the Standard, Web and Express editions of SQL Server because there is limitation...
2016-12-20
6,060 reads
In this article I explore the basics around how to determine when a database was last restored.
Related Posts:
Changing Default Logs Directory - Back to Basics January 4, 2018
SQL...
2016-12-20
61 reads
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-12-20
687 reads
One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk...
2016-12-19
1,384 reads
I’m pleased to announce a new collaborative whitepaper with ScaleArc entitled “Improving uptime and performance of legacy apps on Microsoft...
2016-12-19
357 reads
“Microsoft Technet Guru – Gold Medal Winning Article- Nov, 2016”
Abstract
Monitoring disk space utilization of server(s) is the critical and important job for...
2016-12-19
1,035 reads
This month concludes my second full year on the PASS Board of Directors and my first full year on the...
2016-12-19
422 reads
Its the right time & the right moment of the year to announce the 2nd edition of the ultimate portuguese IT...
2016-12-19
303 reads
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...
2016-12-19
471 reads
Don’t trust Invoke-SqlCmd and error resultsI love to call Invoke-sqlcmd from powershell but one must beware of the risk of...
2016-12-19
27,272 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Comments posted to this topic are about the item Pay for Performance, which is...
Jl. PB.Sudirman No.40, Tekoan, Tanggul Kulon, Kec. Tanggul, Kabupaten Jember, Jawa Timur 68155
Jl. YOS Sudarso No.49, Dusun Kp. Baru, Jajag, Kec. Gambiran, Kabupaten Banyuwangi, Jawa Timur...
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