Email Alerts
-
Meet the SearchSQLServer.com expert panel
The SearchSQLServer.com experts are available to help address your most trying SQL Server problems. Article
-
Site offerings at a glance
Here is a quick look at our complete lineup of original content that we update regularly. Article
-
Paging through SQL query results
Ask the Expert
-
Find duplicate indexes
Two SQL Server 2000 user-defined functions that return the duplicate indexes on the current database. Tip
-
Determine the number of rows in a table without a table scan
SQL Server keeps the row count in sysindexes and it can be retrieved there. Here's how. Tip
-
Dynamically manipulating files using xp_cmdshell
Dynamically build and execute OS commands within an SQL script. Tip
-
Drop user databases without using normal syntax
Here's how to drop user databases if you can't drop them using normal syntax like sp_dropuser. Tip
-
Display detailed index statistics
A stored procedure that allows you to obtain detailed DBCC SHOW_STATISTICS information on all indexes for a given table. Tip
-
Encrypting a string to a varbinary(128)
This code is useful when encrypting sensitive data (like passwords) into a varbinary. Tip
-
Identifying external or internal table fragmentation
This article describes how to identify tables that are fragmented internally (ie, fragmentation inside data pages) or externally (ie, extents are fragmented). Tip