SQL Battleship
It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!
2019-04-15 (first published: 2014-04-25)
8,379 reads
Uncategorized
Review Your BUCKET_COUNT Statistics with DMV
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
Function to count set bits in a signed integer
This function counts the number of 1's in the binary representation of an integer.
2015-07-28 (first published: 2014-02-24)
974 reads
Find Top 5 executed queries ordered by execution count
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)
5,133 reads
Developing a Report Definition Customization Extension for Multi-Language Reports
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
Universal Product Codes: a Database Primer
An introduction to Universal Product Codes with code to help you use them in your database.
2013-02-28
6,612 reads
Designing Databases for Rapid Resilience
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
New feature in SQL Server 2012 - Sequence
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,047 reads
2012-07-05 (first published: 2012-06-15)
934 reads
2012-06-05
2,010 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Azure SQL DBA certification
Hello team Can anyone share popular azure SQL DBA certification exam code? and your...
Faster Data Engineering with Python Notebooks: The Fabric Modern Data Platform
Comments posted to this topic are about the item Faster Data Engineering with Python...
Which Result II
Comments posted to this topic are about the item Which Result II
Question of the Day
Which Result II
I have this code in SQL Server 2022:
CREATE SCHEMA etl;
GO
CREATE TABLE etl.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT etl.product
VALUES
(2, 'Bee AI Wearable');
GO
CREATE TABLE dbo.product
(
ProductID INT,
ProductName VARCHAR(100)
);
GO
INSERT dbo.product
VALUES
(1, 'Spiral College-ruled Notebook');
GO
CREATE OR ALTER PROCEDURE etl.GettheProduct
AS
BEGIN
exec('SELECT ProductName FROM product;')
END;
GO
When I execute this code as a user whose default schema is dbo and has rights to the tables and proc, what is returned? See possible answers