Passing Parameters as (almost) 1, 2, and 3 Dimensional Arrays
It's a well known fact that there's no such thing as a true "array" in SQL Server and that you can't pass a table as a parameter... but you can get a lot closer than you think.
Balancing the Message
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
Balancing the Message
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
Balancing the Message
How can we get information about new products, tools, and services in the Internet world? Steve Jones has a poll this Friday asking what ways you would like to interact with SQL Server vendors on the site.
Identity Values – Two things to know
I saw someone post a question recently about running out of identity values in an INT column. It happens, it’s...
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
Top 10 steps to optimize data access in SQL Server. Part III (Apply advanced indexing and denormalization)
Even after you have applied proper indexing along with re-factoring your TSQLs with best practices, some data access routines might still be there, which would be expensive, in terms of their execution time. There must have been some smart ways to deal with these. Yes there are. SQL server offers you some rich indexing techniques that you might have not used earlier. These could surprise you with the performance benefits they possibly offer. Let us start implementing those advanced indexing techniques:
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
Database Snapshot and Rollback Transactions
A Rolled back transaction will increase the snapshot sparse file usage. New author Subash brings us an examination of how those database snapshots actually work.
Being Supportive
Steve Jones says we need to stick together in IT, at least from the perspective of the client. Otherwise we can all look bad as an industry.
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers