|
|
-
Patrick Lambin learned 2 Months ago through Blogs
In this post, we take a look at the Catalog Views related to columnstore indexes introduced in SQL Server 2012: sys.column_store_segments and sys.column_store_dictionaries....
|
-
Patrick Lambin Liked 2 Months ago through Blogs
In this post, we take a look at the Catalog Views related to columnstore indexes introduced in SQL Server 2012: sys.column_store_segments and sys.column_store_dictionaries....
|
|
|
|
|
-
Patrick Lambin learned 3 Months ago through Blogs
In this post, we take a look at the Dynamic Management and Catalog Views related to Resource Governor introduced in SQL Server 2012: sys.dm_resource_governor_resource_pool_affinity and sys.resource_governor_resource_pool_affinity...
|
-
Patrick Lambin Liked 3 Months ago through Blogs
In this post, we take a look at the Dynamic Management and Catalog Views related to Resource Governor introduced in SQL Server 2012: sys.dm_resource_governor_resource_pool_affinity and sys.resource_governor_resource_pool_affinity...
|
-
Patrick Lambin Commented 3 Months ago through Pages
Hi Parash,
SMO = SQL Server Management Objects ( a .Net library which is used to manage SQL Server instances and their "objects", like tables,views,backups,databases ). It is used also in the PowerShell variant sqlps used in the SQL Server Management S...
|
-
Patrick Lambin Commented 3 Months ago through Blogs
Hi Madhivanan,
It is an very useful tip.
Since 2005 , when i began to use SMO to create applications creating databases , i am always surrounding any name of objects ( from databases thru colums,views, ,... ) with a [] pair as i faced some problems ...
|
-
Patrick Lambin Liked 3 Months ago through Blogs
Square braces in SQL Server play a major role in T-SQL programming. When an object name contains a space, special character, etc, the only way to express them is to put them around squre braces. Consider that you want to create a table user master (with...
|
-
Patrick Lambin refreshed 3 Months ago through Blogs
Microsoft SQL Server 2008 introduced the DATE and TIME data-types. TIME could be added to DATETIME in SQL 2008, but can longer be done so in SQL Server 2012. In this post, we look at the Msg #402, and associated workaround....
|