Why You Shouldn’t Use an Intel Xeon Silver Processor for SQL Server
Processor-based licensing means selecting hardware carefully for good performance.
2019-05-03
Processor-based licensing means selecting hardware carefully for good performance.
2019-05-03
Small form-factor (SFF) machines have emerged as a major growth segment in the desktop PC market. Performance per watt is an important metric for such systems. Intel has pretty...
2019-04-26
Introduction Earlier this week, I bought a new HP Spectre x360 13-AP0023DX convertible laptop at Best Buy. I have often criticized Best Buy as a bad place to buy...
2019-04-25
Intel's latest SSD caching solution using 3D XPoint memory is here. This time, the Optane cache is paired with QLC NAND flash, and all bundled onto one M.2 module...
2019-04-22
You may have heard of Intel Optane Technology, but perhaps you aren’t quite sure what that term actually refers to, and whether it is relevant for SQL Server. Unfortunately,...
2019-04-14
When Intel announced the new Cascade Lake family as officially launched last week, it added a new product segment to its portfolio – the ‘Application Processor’ or AP. These...
2019-04-08
At least two retailers from the US on Friday have started to take pre-orders on Intel’s Optane DC Persistent Memory modules and therefore had to reveal their prices. Today...
2019-04-05
Lexar this week introduced its first external SSDs featuring a USB 3.1 Gen 2 Type-C interface. The SL100 Pro drives are lightweight, miniature, and offer a read speed of...
2019-04-05
Glen Berry talks through a number of useful new developments in hardware, storage, and the Microsoft Windows and SQL Server ecosystem.
2016-05-23
3,214 reads
You have been asked to deploy a brand new SQL Server instance. Your management asks you to come up with the best balance of availability, performance and cost for SQL Server. Richard Vantrease has some recommendations.
2014-06-05
4,676 reads
I had an excellent group of people in Gothenburg Sweden when I taught there...
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Data analysis is all about wrangling massive datasets. To do that efficiently, you need...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
hi a peer of mine recalls an error in an edi app that often...
Hello SSC! First, I would like to thank everyone who has responded to my...
I have created these triggers in SQL Server 2022:
CREATE TRIGGER triggertest_tri_1 ON dbo.triggertest FOR INSERT AS PRINT 'one' GO CREATE TRIGGER triggertest_tri_2 ON dbo.triggertest FOR INSERT AS PRINT 'two' GOI want to be sure that the trigger with "1" runs first. I decide to run this:
EXEC sp_settriggerorder@triggername = 'triggertest_tri_1', @order = 'first'What happens? See possible answers