Determining which columns to index in a table used to be a very time consuming process that was as much art as science. New author Ranga Narasimhan brings us an article that shows how SQL Server 2005 makes this much easier.
ROWE stands for a Results Oriented Work Environment. This Friday Steve Jones asks if you'd like to work in one.
In a recent thread here on SQL Server Central, it was pointed out that a member of the securityadmin fixed...
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.
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Komp. Hatta Centre, Jl. Arifin Ahmad Perkantoran Soekarno No.9 Blok D, Sidomulyo Timur, Marpoyan...
BCA KCP Kramat Jaya Hub.0853•5504•2311 Jl. Kramat Jaya Raya No.10 Blok F1, Semper Bar.,...
Jl. H.R. Subrantas No.74 A & B, Sidomulyo Bar., Kec. Tampan, Kota Pekanbaru, Riau...
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers