We soon learn, in SQL Server, that heaps are a bad thing, without necessarily understanding how or why. Jonathan Lewis is an Oracle expert who doesn't like to take such strictures for granted, especially when they don't apply to Oracle. Jonathan discovers much about how SQL Server places data, and concludes from his experiments that heaps perform badly in SQL Server because you cannot specify a fill factor for them.
Is self service BI a good idea? Some people think so, others don't. Steve Jones talks about one of the issues and why it might actually not be a problem.
How can I receive notifications when the policies I have implemented have been violated so I don't have to manually look at each server?
Today we have a guest editorial from Andy Warren. You can get more productive, but are you being productive at the tasks that you should be working on? See what Andy Warren has to say.
Using SqlTypes can have a significant impact on the performance of your SQL CLR implementations. Is it for the better? Read this article to find out.
Inspired to streamline the process of gathering and storing data from Performance Monitor Counters, SQL Server MVP Laerte Junior guides us through the functions of his remarkably useful module.
When someone else doesn't do a good job to prove a point, are they incompetent or malicious? Steve Jones comments.
When reloading or attaching a SQL 2000 database to SQL 2005 or 2008, the database objects are upgraded automatically. Some database options don't change, though. PAGE_VERIFY is one of them.
A number of hierarchies and networks are most conveniently modelled as binary trees. So what is the best way of representing them in SQL? Joe Celko discards the Nested Set solution in favour of surprisingly efficient solution based on the Binary Heap
When is backup not enough? Steve Jones talks about a few things that can cause you issues and a backup can't help you recover from.
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
BCA KCU MENARA BIDAKARA Telpon/WA:085188120691 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
BCA KCP Tebet Telpon/WA:085188120691 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N...
BCA KCP Setiabudi Atrium Telpon/WA:085188120691 Setiabudi Atrium, Plaza Setiabudi, Jl. H. R. Rasuna Said...
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers