Weblinks

FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"

Posted on Mär 22, 2011 von in Links

Tags: dbcc, knowledgebase, sql server, sql server 2005, troubleshoot

Recover from a full transaction log in a SQL Server database

Posted on Mär 21, 2011 von in Links

Tags: recovery, sql server

To 1433 or not to 1433...that is the question

Posted on Mär 18, 2011 von in Links

Tags: connect, sql server, tcp_ip

General Hardware/OS/Network Guidelines for a SQL Box

Posted on Mär 11, 2011 von in Links

Tags: hardware, netzwerk, sql server

Important support changes for SQL Server 2000 and SQL Server 2005

Posted on Mär 10, 2011 von in Links

Tags: sql server, sql server 2000, sql server 2005, support

The blocking nature of aggregates

Posted on Mär 8, 2011 von in Links

Tags: coding, query, sql server, t-sql

Don’t depend on expression short circuiting in T-SQL (not even with CASE)

Posted on Mär 4, 2011 von in Links

Tags: coding, query, sql server, t-sql

10 lessons from 35K tps

Posted on Feb 28, 2011 von in Links

Tags: coding, performance, query, sql server, t-sql

Do changes to index keys really do in-place updates?

Posted on Feb 28, 2011 von in Links

Tags: index, paul randal, query, sql server

FIX: A query that uses the DATEDIFF function may run slowly in SQL Server 2005

Posted on Feb 24, 2011 von in Links

Tags: fix, query, sql server, sql server 2005

1
...
19
20
21
...
22
...
23
24
25
...
26
...
27
28
29
...
115