Retrieving Data from an Audit Table
This article examines the various methods for retrieving data from an Audit table.
2010-04-09
3,419 reads
Articles
SQL Server Intellisense VS. Red Gate SQL Prompt
Fabiano Amorim is hooked on today's Integrated Development Environments with built-in Intellisense, so he looked forward keenly to SQL Server 2008's native intellisense. He was disappointed at how it turned out, so turned instead to SQL Prompt. Fabiano explains why he prefers to SQL Prompt, why he reckons it fits in with the way that database developers work, and goes on to describe some of the features he'd like to see in it
2010-04-09
4,030 reads
SQL Server 2008 Spatial Index Performance
The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?
2010-04-08
4,056 reads
Date Manipulation with DATEADD/DATEDIFF
Learn how to use Dateadd/Datediff functions to manipulate dates in this short article from Seth Phelabaum.
2010-04-07
37,323 reads
New and Improved Functionality in SSIS 2008
While it does not bring revolutionary changes, the release of SQL Server 2008 delivers functionality, scalability, and performance improvements to SQL Server Integration Services (SSIS). Here is a comprehensive listing of new and enhanced features of SSIS with a short description of each.
2010-04-07
4,355 reads
Understanding Dynamic Management Views and Functions in SQL Server 2008
Performance monitoring and optimization is an inseparable part of a DBA's activities. To optimize a poorly performing system/query or to troubleshoot the performance issues you need to know the root cause. Prior to SQL Server 2005, we had several system tables to monitor the state of the system.
2010-04-06
2,169 reads
Working with Queues in SQL Server
This article shows sow to create a queue from a SQL table to serve each operator exactly one item from the queue that has not been picked up by any other.
2010-04-05
27,345 reads
Celko's SQL Stumper: Eggs in one Basket
Joe Celko returns with another stumper to celebrate Easter. Unsurprisingly, this involves eggs. More surprising is the nature of the puzzle: This time, the puzzle is one of designing a database rather than a query. DDL as well as the DML.
2010-04-05
2,337 reads
SQL Server Indexed Views
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
TSQL Challenge 27 - Identify overlapping weekly schedules of Nurses
This challenge is related a scheduling problem in the home health care industry. The task is to look into the schedules of nurses and identify any overlapping schedules.
2010-04-05
2,580 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Duta Gardenia,Telp/Wa 0821.3111.159
Ruko Duta Garden, Duta Gardenia I Blok B2-B3, RT.001/RW.008, Jurumudi Baru, Kec. Benda, Kota...
BCA KCP Rawasari Tlpn/wa:085373737551
Jl. Rawasari Sel. No.24 A, Rawasari, Kec. Cemp. Putih, Kota Jakarta Pusat, Daerah Khusus...
BCA KCP Bandara S/H Term D,Telp/Wa 0821.3111.159
Terminal 2, Gate 3, Pajang, Kedatangan, Tangerang City, Banten 15126
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers