|
|
-
Olga Medvedeva Liked 4 Months ago through Blogs
This post explores new DMVs introduced in SQL Server 2008R2 and 2012 related to the SQL Server Operating System (SQLOS)....
|
-
Olga Medvedeva refreshed 4 Months ago through Blogs
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 w...
|
-
Olga Medvedeva Liked 4 Months ago through Blogs
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 w...
|
|
|
|
|
|
|
-
Here are the seven Demo’s that I had posted over the past few weeks, listing them here:
Detecting invalid values in Price domain or unrealistic values in Height domain
How to standardize data using DQS
How to clean records using third-party refere...
|
|
|
-
Olga Medvedeva Liked 4 Months ago through Blogs
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 ...
|
|
|