Weblinks

Conor vs. FOREIGN KEY join elimination

Posted on Okt 21, 2010 von in Links

Tags: fremdschl_ssel, query optimizer

How to change database mirroring encryption with minimal downtime

Posted on Okt 21, 2010 von in Links

Tags: database mirroring, encryption

How It Works: SQL Server 2008 NUMA and Foreign Pages

Posted on Okt 21, 2010 von in Links

Tags: how it works, numa, sql server 2008

Bad habits to kick : creating the uber-view

Posted on Okt 21, 2010 von in Links

Tags: bad habits

Mystery of memory fraction in Showplan XML

Posted on Okt 21, 2010 von in Links

Tags: ausf_hrungsplan, troubleshoot, xml

How to downgrade Integration Services 2008 packages to 2005

Posted on Okt 21, 2010 von in Links

Tags: Integration Services, sql server 2005, sql server 2008

How It Works: Extended Event (sqlos.wait_info*)

Posted on Okt 21, 2010 von in Links

Tags: how it works, sqlos

Creating a 60 GB Index

Posted on Okt 20, 2010 von in Links

Tags: index, performance

Changes to sp_estimate_data_compression_savings stored procedure in SQL2008R2

Posted on Okt 20, 2010 von in Links

Tags: data compression, sql server 2008 r2

FIX: Error message when you use Query Designer in SQL Server 2005:"Unable to find an entry point named 'GetWindowLongPtr' in 'user32.dll'"

Posted on Okt 20, 2010 von in Links

Tags: troubleshoot

1
...
57
58
59
...
60
...
61
62
63
...
64
...
65
66
67
...
115