|
|
|
|
-
Chintak Chhapia Liked 3 Months ago through Blogs | 1 Point
In this post I explore the database and index related DMVs introduced in SQL Server 2012, namely: sys.dm_db_uncontained_entities, sys.dm_db_log_space_usage and sys.dm_db_fts_index_physical_stats....
|
-
Chintak Chhapia Liked 3 Months ago through Blogs | 1 Point
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....
|
-
Chintak Chhapia Liked 3 Months ago through Blogs | 1 Point
This post gives a brief description about each Enumerator available in SSIS. Will be explaining them in details one by one, taking examples to make it more clear....
|
|
|
|
|
|
|
|
|
-
Chintak Chhapia Commented 4 Months ago through Blogs | 1 Point
Yes, constraints as well as indexes will not be available in new table. For more information have a look at limits and restrictions [here][1]. Also, rowversions gets copied.
[1]: http://msdn.microsoft.com/en-us/library/ms188029.aspx...
|
|
|