There has been much debate over the need for the Lock Pages in Memory privilege, on 64-bit versions of SQL Server. Jonathan Kehayias presents a "warts and all" account of its history, the confusions surrounding its use, and why he believes it's still a good default configuration for 64-bit SQL Server instances, even when running Windows Server 2008 and Windows Server 2008R2.
Users often have a certain expectation of privacy about their data in applications, and as software engineers, Steve Jones thinks we need to respect that.
This blog, explores ideas for extending SQL Server with new, fast hash functions. As will be shown, the high speed, built in functions CHECKSUM and BINARY_CHECKSUM are not always optimal hash functions, when you require the function to spread data evenly over an integer space.
Be carefull when replacing a defective (FLASH) storage device, its sector sizes may vary without you knowing it.
Today we have a guest editorial from Andy Warren. Today Any asks you to think about your career and your network for 2012.
I have transactional replication configured in my production environment with multiple subscribers. The business team has requested that one of the subscriptions be reinitialized, because they think there is some missing data. In this tip we look at the different options that you can use to reinitialize a subscription for transactional replication.
This article shows how to use 6 SQL table-based tools to solve the same problem, and gives the pros and cons of each.
This challenge invites you to solve a payroll challenge which requires to calculate the number of hours employee worked in a week.
By Steve Jones
I type fairly well. Well, I type fast, but I do wear out a...
By way of background, a while back I did video called “My New Favourite...
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WA:08218154393 Jl. A. Yani No.KM 33 5, Guntung Payung, Kec. Landasan Ulin, Kota Banjar...
WA:08218154393 Jl. Jend. Sudirman No.30, Ps. Pagi, Kec. Samarinda Kota, Kota Samarinda, Kalimantan Timur...
I have this data in the dbo.Commission table in a SQL Server 2022 database.
salesperson commission Brian 12 Brian 16 Andy 7 Andy 14 Andy 21 Steve 20 Steve NULLAll the data is a varchar, and I decide to run this query to get the totals for each salesperson.
SELECT SalesPerson
, AVG(TRY_PARSE(Commission AS int)) AS TotalCommission
FROM commission
GROUP BY SalesPerson
GO
What average commission is calculated for Steve? See possible answers