|
|
-
|
|
This post explores new DMVs introduced in SQL Server 2008R2 and 2012 related to the SQL Server Operating System (SQLOS)....
|
|
-
|
|
Semi-colons as statement-terminators has been around for as long as I can remember, however, they have only been made mandatory in the newer statements. However, as documented in the T-SQL Syntax Conventions, using semi-colons as statement terminators will be required in a future release of SQL Server. However, care needs to be taken not be use them on batch separators....
|
|
-
|
|
In this post, we look at the SQL Server installation related DMVs introduced in SQL Server 2008 R2/2012...
|
|
-
|
|
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....
|
|