Sign In
SQL Server Engine Tips
Guidelines, Best Practices, TSQL and SQL Programming Tips & Tricks.
Translate This Page
Translate this page
Powered by
Microsoft® Translator
Options
About
Email Blog Author
RSS for posts
Atom
RSS for comments
OK
Search
Advanced search options...
Search In:
Everything
Blogs
Forums
People
Groups
Places
Pages
Date range:
All Time
Last Year
Last 6 Months
Last 3 Months
Last Month
Last Week
Last Two Days
Tags
Announcements
Architecture
Best Practices
Catalog Views
Dynamic Management View
General
Oracle SQL Migration
Pages
Performance - Engine
Performance - SQL/TSQL
Performance - Tools
Performance Troubleshooting
Programming
SQL Server 2005
SQL Server 2008
Archive
Archives
July 2008
(1)
June 2008
(2)
August 2007
(1)
April 2007
(1)
March 2007
(3)
February 2007
(3)
December 2006
(1)
November 2006
(2)
September 2006
(3)
July 2006
(1)
June 2006
(3)
May 2006
(1)
February 2006
(3)
October 2005
(7)
September 2005
(3)
August 2005
(2)
July 2005
(3)
June 2005
(3)
May 2005
(2)
October, 2005
MSDN Blogs
>
SQL Server Engine Tips
>
October, 2005
Posts
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SQL Server Engine Tips
Renaming logins in SQL Server 2005...
Posted
over 7 years ago
by
SQL Server Engine Team
0
Comments
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...
SQL Server Engine Tips
Use of INFORMATION_SCHEMA views to access temp tables.
Posted
over 7 years ago
by
SQL Server Engine Team
1
Comments
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...
SQL Server Engine Tips
Top 5 features you would like to see in the next version of SQL Server
Posted
over 7 years ago
by
SQL Server Engine Team
82
Comments
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...
SQL Server Engine Tips
SQL Server 2005 features that are dependent on Windows Server 2003...
Posted
over 7 years ago
by
SQL Server Engine Team
10
Comments
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...
SQL Server Engine Tips
Find Top N costly query plans in adhoc batches or modules...
Posted
over 7 years ago
by
SQL Server Engine Team
12
Comments
Top N costly query plans...
Page 1 of 1 (5 items)