Effective Clustered Indexes
As a guideline, clustered Indexes should be Narrow, Unique, Static and Ever Increasing (NUSE). Michelle Ufford Explains why.
2011-01-17
4,641 reads
Additional Articles
Getting Started with SQL Azure Development
SQL Azure provides features similar to a relational database for your cloud apps. We’ll show you how to start developing for SQL Azure today.
2011-01-14
3,003 reads
Trending Buffer Pool Performance Using DMV sys.dm_os_performance_counters
I'd seen you posted a tip on capturing SQL based PerfMon counters using sys.dm_os_performance_counters. What queries can I run against those stored results that would allow me to examine memory usage on my SQL instance?
2011-01-13
2,548 reads
Data Conversion in SQL Server
Most of the time, you do not have to worry about implicit conversion in SQL expressions, or when assigning a value to a column. Just occasionally, though, you'll find that data gets truncated, queries run slowly, or comparisons just seem plain wrong. Robert Sheldon explains why you sometimes need to be very careful if you mix data types when manipulating values.
2011-01-12
4,537 reads
Contiguous Time Periods
It is always more efficient to maintain referential integrity by using constraints rather than triggers. Sometimes it isn't obvious how to do this. Until a recent idea by Alex Kuznetsov, the history table presented problems for checking data that were difficult to solve with constraints. Joe Celko explains.
2011-01-11
3,294 reads
Natural vs. Surrogate Keys in SQL Server : Getting the Proper Perspective
This article demonstrates the relative merits of natural and surrogate keys and benchmarks their performance in different scenarios.
2011-01-10
4,502 reads
Profiling Database Activity in the Entity Framework
It’s important to profile your database queries to see what happens in response to Entity Framework queries and other data access activities, says Julie Lerman, who gives you the details on several profiling options to improve you coding.
2011-01-07
3,027 reads
Script Task and Event Logging in SSIS
components. These same configuration settings can be leveraged in Script Task, but you also have the option of triggering and tracking events in a considerably more customizable manner. This article explores features that provide this flexibility.
2011-01-06
3,819 reads
Monitor SQL Server Agent Jobs with Policy Based Management
I need to monitor all the SQL Agents to find out if a job failed in the last 24 hours. Could this be done with policy based management? If so, can you show me how to create the policy?
2011-01-05
4,291 reads
Identity Property Range Checking in SQL Server
This article examines practical methods of managing and monitoring large tables which make use of the IDENTITY property.
2011-01-04
3,913 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCU MENARA BIDAKARA Telp/WA0851•8812•0691
BCA KCU MENARA BIDAKARA Telp/WA0851•8812•0691 Menara Bidakara, Jl. Gatot Subroto No.Kav.71-73 Lt. Lobby dan...
Alamat Kantor BCA Finance - Depok Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Komplek Perkantoran, Ruko Pesona View, Jl. Pesona Khayangan Jl. Ir. H. Juanda...
BCA Finance Bekasi Layanan Mobil Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 KOMPLEK MEGA OFFICE PARK, Jl. Harapan Indah Boulevard No.8 blok P5, Medan...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers