Stored procedure with table parameter
You plan to create a stored procedure that uses a table parameter as an input parameter. The table value parameter may hold between 1 and...
top of page
Topic
Recent Posts
Archive
Tags
No tags yet.
Index seek operation -- Nonclustered index
You have a table that has a clustered index and a nonclustered index. The indexes use different columns from the table. You have a query...
Enable the database query store
You have a Microsoft Azure SQL Database named MyDb that uses server version V12. You plan to use Query Performance Insight to...
Indexes to avoid table scans
The Account table was created by using the following Transact-SQL statement: There are more than 1 billion records in the Account table....
A stored procedure to insert data
You are creating a stored procedure which will insert data into the table shown in the Database schema exhibit. You need to insert a new...
Optimizing a SQL query
You use Microsoft SQL Server Profile to evaluate a query named Query1. The Profiler report indicates the following issues: ✑ At each...
SQL- Stored procedure: Skip first two INSERT statements
I encounter an interesting question as follows: You have a stored procedure that needs to run three INSERT statements, the first two of...
Case study -- About deadlock
Background - You have a database named HR1 that includes a table named Employee. You have several read-only, historical reports that...
Schema permissions
A database administrator needs to perform specific actions for objects in the database. You need to ensure the administrator can perform...
Schema Design
You have a database that contains the following tables: BlogCategory, BlogEntry, ProductReview, Product, and SalesPerson. The tables were...
bottom of page