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
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)
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 8 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 8 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 8 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 8 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 8 years ago
by
SQL Server Engine Team
12
Comments
Top N costly query plans...
SQL Server Engine Tips
Request for topics...
Posted
over 8 years ago
by
SQL Server Engine Team
28
Comments
Please post requests for topics or features that you would like to know about. This can be any of the SQL/TSQL language features or programmability in general. There are so many things to discuss about wrt SQL Server 2005 so it will be good to gauge interest...
SQL Server Engine Tips
Determine primary keys and unique keys for all tables in a database...
Posted
over 8 years ago
by
SQL Server Engine Team
7
Comments
Determine primary keys and unique keys for all tables in a database using INFORMATION_SCHEMA views and the new catalog views in SQL Server 2005...
SQL Server Engine Tips
Determining optimal MAXDOP setting from TSQL in SQL Server 2005
Posted
over 8 years ago
by
SQL Server Engine Team
12
Comments
Determing optimal MAXDOP setting value using DMV...
SQL Server Engine Tips
Renaming sa account in SQL Server 2005
Posted
over 8 years ago
by
SQL Server Engine Team
10
Comments
Renaming sa account in SQL Server 2005...
SQL Server Engine Tips
Getting SQL Server registry settings via SQLCLR table-valued user-defined function...
Posted
over 8 years ago
by
SQL Server Engine Team
2
Comments
SQLCLR TVF to read registry settings for SQL Server instance...
SQL Server Engine Tips
Feedback requested on database mirroring...
Posted
over 8 years ago
by
SQL Server Engine Team
10
Comments
Database Mirroring configuration using certificate authenticated endpoints....
SQL Server Engine Tips
Ordering guarantees in SQL Server...
Posted
over 8 years ago
by
SQL Server Engine Team
18
Comments
Ordering guarantees in queries....
SQL Server Engine Tips
Direct dependencies on a column...
Posted
over 8 years ago
by
SQL Server Engine Team
13
Comments
Queries to get direct dependencies on the column....
SQL Server Engine Tips
Using ANSI SQL style DECLARE CURSOR statement in UDF...
Posted
over 8 years ago
by
SQL Server Engine Team
5
Comments
Use of ANSI SQL style DECLARE CURSOR statement in UDF is not supported...
SQL Server Engine Tips
OUTPUT clause in INSERT/UPDATE/DELETE statements
Posted
over 8 years ago
by
SQL Server Engine Team
3
Comments
Using OUTPUT clause in INSERT/UPDATE/DELETE statements...
SQL Server Engine Tips
Test linked server connection settings...
Posted
over 8 years ago
by
SQL Server Engine Team
12
Comments
Testing linked server connection settings....
SQL Server Engine Tips
Performing batched updates...
Posted
over 8 years ago
by
SQL Server Engine Team
0
Comments
Performing updates in batches using UPDATE with TOP clause....
SQL Server Engine Tips
Welcome !
Posted
over 8 years ago
by
SQL Server Engine Team
4
Comments
Welcome to the SQL Server Engine Tips blog - hosted by the engine program management team. The purpose of the blog is to share guidelines, best practices, tips and answer questions related to implementing and deploying solutions using SQL Server. We will...
Page 2 of 2 (43 items)
1
2