At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications receiving this dreaded error
There's more information hidden behind those graphical plans than you might first suspect.
It's Halloween day, the night for dressing up in costume and being a little silly. Hopefully it's also a fun day without anything going wrong for you at work.
This challenge invites you to Generate kaprekar kernel or series from numbers.
Using the Kimball Data Warehouse Modeling Tool in an agile setting supporting regular builds and integrated testing with work a rounds to cover non-SQL Server systems.
If you have a requirement to install multiple SQL Server instances with the same settings, you most likely want to do it without following the numerous manual installation steps. The below tip will guide you through how to install a SQL Server instance with less effort.
This editorial was originally published on Oct 21, 2006. It is being re-run as Steve is out at SQL in the City today. This one talks about the security of USB devices and the potential problems of employees copying data.
This article lists the essential TCP/UDP ports that an administrator running SQL Server or a cluster should know.
In this blog, you will see the reproducible steps that reveal the following observation: “If the table has a persisted computed column*, the query optimizer will choose a clustered index scan over a clustered index seek.”
How do I find out what TCP/IP port SQL Server is using for a specific SQL Server instance? In this tip we look at different ways a database administrator can identify the port used by instance of SQL Server.
By Bert Wagner
Train Wreck The last time I watched a high school band nearly fall apart mid-performance...
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Comments posted to this topic are about the item Why Your Index Isn't Being...
Comments posted to this topic are about the item Distance Metric Algorithms
Comments posted to this topic are about the item What Can AI Really Do?
What are the distance metric algorithms that can be used in VECTOR_DISTANCE()?
See possible answers