Physical Join Operators in SQL Server - Merge Operator
Part II of the Physical Joins series looks at the Merge operator.
2010-07-05
4,112 reads
Articles
There Must Be 15 Ways To Lose Your Cursors… Part 2
Learn to use Where, Claire. Plus a conversion methodology, a test harness and more!
2010-07-02 (first published: 2009-04-27)
28,405 reads
Reporting Services 2008 R2: Geospatial Visualization – Part I
Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services. This step-by-step tutorial demonstrates the creation of a Map Report.
2010-07-02
3,764 reads
Log shipping and A Control Mechanism
Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.
2010-07-01
5,899 reads
Kimball University: Extreme Status Tracking For Real Time Customer Analysis
Customer interactions create a wealth of timely data that marketing departments are eager to exploit. The customer status fact table provides a central switchboard for using this fast-moving data.
2010-07-01
2,416 reads
Come Vacation on the SQL Cruise
This fall you have the chance to learn from a number of SQL Server experts and get a little vacation at the same time on a SQL Cruise.
2010-06-30
1,745 reads
There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction
Learn how to leave those Cursors and loops in the thrash, Nash... An article from longtime contributor and SQL expert, Barry Young.
2010-06-30 (first published: 2009-04-14)
34,093 reads
XML Workshop 26 – SELECT * FROM XML
This article presents a generic function that makes it easy to query XML documents
2010-06-30
12,295 reads
Determining Object Access Using SQL Server Profiler
Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.
2010-06-30
2,886 reads
Generating a Distinct Delimited List Using XML
Generating an ordered, distinct, delimited string using ROW_NUMBER() and FOR XML PATH.
2010-06-29
10,849 reads
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Pasar Legi NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Letjen S. Parman No.135, Kestalan, Kec. Banjarsari, Kota Surakarta, Jawa Tengah...
BCA KCP Palur NO TELPON 087781685658
WHATSAPP 087781685658 Jl. Raya Palur No.Km 5, Jurug, Ngringo, Kec. Jaten, Kabupaten Karanganyar, Jawa...
Cara reschedule tiket Garuda Indonesia
Untuk reschedule tiket Garuda Indonesia Anda dapat menghubungi saluran resmi Garuda di 0823-2461-4949 Atau...
Question of the Day
May the Fourth Be With You Fun
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