|
|
-
|
|
In this post, I use the MODIFY FILE clause of the ALTER DATABASE statement to rename the logical file of a database. This is most often useful during product/organization re-branding. This approach is fast because it does not require a transfer of data to a new database....
|
|
-
|
|
While DMVs are some of the most powerful features of Microsoft SQL Server, they are still under-utilized due to the lack of awareness around them. Nevertheless, each release of Microsoft SQL Server comes with a new set of DMVs being introduced & existing DMVs being modified to expose more valuable information/details. Once a week for the next couple of weeks, my posts will be centered around the DMVs & Catalog Views modified in SQL Server 2012....
|
|
-
|
|
Primary data files are always assigned a file_id = 1 in the sys.database_files view. But, what about the log and rest of the data files? Does the primary transaction log file of a database always receive a file_id = 2?...
|
|
-
|
|
Is there a limit upon the number of characters that can be displayed in the query execution results displayed in the "Text" mode in SSMS? In this post we discuss how to change the maximum characters that can be displayed per column....
|
|
-
|
|
Every SQL developer/DBA I know has spent a considerable time customizing their SSMS setup. When moving from workstation to another, all the efforts need to be spent again. But not anymore - the Import and Export wizard, a part of the SSMS for SQL Server 2012 makes moving settings from one computer to another an easy task....
|
|
-
|
|
As a true Enterprise product, Microsoft SQL Server comes with a host of tools and utilities that can help evaluate and prepare an existing environment for a SQL Server installation/upgrade. The SQL Server Upgrade Advisor is one such tool from the vast arsenal of these peripheral "helper" tools....
|
|
-
|
|
Are your SQL Server instances up-to-date? Use official SQL Server Build lists to know about the latest releases of SQL Server....
|
|
-
|
|
SQL Server has the ability to enforce organzational security policies for SQL login passwords. This can be bypassed by using the CHECK_POLICY clause in the CREATE LOGIN statement. However, when using hashed passwords, no such restrictions seem to apply....
|
|
-
|
|
Working with SQL Server logins and users is one of the most important and critical activities when moving databases from one SQL Server instance to another. The hash value for SQL Server logins created in SQL 7.0 or earlier are 16-bit values and are no longer compatible with SQL Server 2012....
|
|
-
|
|
In this post, we see that temporary tables allow the use of only 116 characters out of a possible 128. How are temporary tables named, and what happens to the restricted length of 12 characters? What is the naming logic for temporary tables?...
|
|