Top 5 SQL/TSQL/Engine features summary of responses…

You can find below the summary of responses for the top 5 features requested for next version of SQL Server. http://umachandar.members.winisp.net/files/top_5_features_summary.htm   You can post your requests on the blog at http://blogs.msdn.com/sqltips/archive/2005/10/07/top_5_features_request.aspx.

0

Renaming logins in SQL Server 2005…

Did you know that SQL Server 2005 supports renaming logins? This can be done via ALTER LOGIN statement. I posted a sample about renaming sa login and disabling it before. But it is probably not obvious if you can do it for all logins. Ex: ALTER LOGIN sqluser WITH NAME = [newuser]; You can also…

0

Use of INFORMATION_SCHEMA views to access temp tables.

An MVP recently sent us an email asking how to use the INFORMATION_SCHEMA views to access temp tables.  This MVP thought the session ID (spid) was needed to construct the suffix.  Here was our response: ========================= Hi, The algorithm for generating the temp table name suffix changed between Shiloh in Yukon.  In any case, it…

1

Top 5 features you would like to see in the next version of SQL Server

Here is an opportunity to discuss about the top 5 features that you would like to see in the next version of SQL Server. It would be nice if you can include a sentence for each feature explaining why it is required. Please use features of SQL Server 2005 as starting point meaning do not…

82

.99 US $ TPC-C price/performance benchmark for SQL Server 2005

Microsoft and Dell broke the $1 barrier with SQL Server 2005 x64 Standard Edition running on an Intel dual-core Xeon CPU. For more details, check out the TPC link http://www.tpc.org/tpcc/results/tpcc_price_perf_results.asp.

0

SQL Server 2005 features that are dependent on Windows Server 2003…

 The question about what features are supported by SQL Server 2005 running on Windows Server 2003 comes up quite often. So below are some of the features that are depends on the OS and brief description about them.        1. Password policy/expiration check for SQL logins – CREATE LOGIN is a new DDL for creating…

10

Find Top N costly query plans in adhoc batches or modules…

I encountered a problem about a query not using a particular indexed view in SQL Server 2005. To investigate this issue, I figured that I would go about writing a query using the execution related dynamic dynamic management views to get the cost of the query that should have used the indexed view. This proved…

12