Greg Larsen discusses the BUCKET_COUNT setting of a HASH index and how to determine how well SQL Server distributes the In-Memory table rows across multiple buckets of a HASH index, by exploring a new DMV, provided with SQL Server 2014, along with the In-Memory OLTP table functionality.
2014-03-19
2,032 reads
This function counts the number of 1's in the binary representation of an integer.
2015-07-28 (first published: 2014-02-24)
944 reads
I wrote this query that helps us find executed queries with most number of execution counts. The DMV that we have used in this script is sys.dm_exec_query_stats and the function that we have used is sys.dm_exec_sql_text.
2015-03-04 (first published: 2013-09-23)
4,963 reads
When you need to present the same SQL Server Reporting Services (SSRS) report in eight or more different languages, or in different formats for different recipients, and the boss demands last-minute changes, it suddenly makes sense to use the Report Definition Customisation Extension (RDCE) .NET class library to create the final reports automatically. But how?
2013-05-02
2,460 reads
An introduction to Universal Product Codes with code to help you use them in your database.
2013-02-28
6,525 reads
As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure. For this, the intelligent use of filegroups is important, particularly when the Enterprise Edition of SQL Server offers the hope of online restores. How, though, should you arrange your data on the different filegroups? What happenens if the primary filegroup gets corrupted? Why backup and restore indexes?
2012-11-13
2,996 reads
A new feature in SQL Server 2012 is Sequence. A Sequence object provides functionality similar to Identity.
2012-10-22 (first published: 2012-09-11)
2,038 reads
2012-07-05 (first published: 2012-06-15)
932 reads
2012-06-05
2,007 reads
2011-11-07
2,025 reads
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Employers and Employee both are depends on each other and they both need their...
Hello everyone! I am a trader or a sole proprietor. I have been in...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers