When a function is wrapped around an indexed column in the WHERE clause it will usually prevent the proper usage of that index. This article gives an example and discusses what other options are available.
2007-09-27
5,005 reads
We are always searching for new ways to improve the performance of our database systems. Raghavendra Narayana brings us a new article that examines an idea for rebuilding partitions and indexes based on data access: in real time!
2007-09-26
5,531 reads
2007-09-26
517 reads
As autumn approaches, Patrick Index produces his ten hot chestnuts for IT Contractors like himself, with a jaundiced 'contractor's-eye view'.
2007-09-26
5,583 reads
Continuing with his look at transactional replication, Andy Warren looks at the various delivery options with a detailed analysis of what happens under various configurations.
2007-09-25
5,317 reads
With the new codebase in place, RSS is pervasive throughout the site. Get a few hints here on how this works.
2007-09-25
2,193 reads
SQL Server 2008 (code named Katmai) is scheduled to launch in February of next year, and the code isn't slated to be released to manufacturing until Q2 2008. But database gurus don't have to wait to get a sense of what's to come because Microsoft recently released SQL Server 2008 to the community for preview.
2007-09-25
7,293 reads
This article is an excerpt from the forthcoming book, Business Metadata, to be published on or about September, 2007, co-authored by Bill Inmon, Bonnie O’Neil and Lowell Fryman, published by Morgan Kaufman.
2007-09-25
2,175 reads
Replication is one of the more useful features in SQL Server and can handle a wide variety of tasks based on his configuration. SQL Server expert Andy Warren takes a look at some of the default transational replication options in this article and what they mean.
2007-09-24
4,761 reads
Lots of changes to the site, see how to work with some of them.
2007-09-24
1,947 reads
By Steve Jones
There is a nice article at Harness.io on their use of feature flags and...
By James Serra
There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...
Hello, I have long-term task, which came one year ago, and just now I...
Comments posted to this topic are about the item LOGON Trigger Count
Comments posted to this topic are about the item Invisible Downtime
I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?
See possible answers