Views can be an effective tool for speeding up your selects and simplifying complex queries. Learn what indexed views are, where you might want to use them, how to create them, and what constraints exist with their use.
2010-04-05
5,000 reads
The concluding part of the Oracle / SQL Server comparison looks at error logging, security, installation and finally querying the databases.
2010-04-02
3,828 reads
2010-04-01 (first published: 2010-03-31)
4,377 reads
Insider rumours and gossip from the murky world of the Database Industry, and from the colourful characters that inhabit it.
2010-04-01
2,611 reads
Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.
2010-03-31
2,478 reads
Part III of the Oracle / SQL Server comparison looks at the configuration options for each database, their storage options as well as the startup and shutdown procedures.
2010-03-30
4,344 reads
Determining which columns to select for your indexes is critical. Having a little knowledge of how your application is using your database columns and how SQL Server processes indexes helps you make good decisions when you create your indexes.
2010-03-29
3,850 reads
Part II or the Oracle / SQL Server comparison dives deeper into databases by exploring the architectural differences.
2010-03-26
4,935 reads
Part I of the Oracle / SQL Server comparison looks at the various editions of each database and their structure.
2010-03-25
6,514 reads
In his latest article, Marcin Policht demonstrates a variety of tools that can be employed to execute SQL Server Integration Services packages, focusing in particular on the method leveraging functionality available within the Business Intelligence Development Studio.
2010-03-24
3,539 reads
By Steve Jones
At Redgate, we’re experimenting with how AI can help developers and DBAs become better...
I was messing around performing investigative work on a pod running SQL Server 2025...
By Steve Jones
Redgate recently released SQL Compare v16, which included a new feature to work with...
Comments posted to this topic are about the item What is Page Density
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Looking to confirm my understanding of these three products and how they can be...
In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?
See possible answers