|
|
-
Some column name have been renamed are follows:
|
-
Some column name have been renamed are follows:
|
-
Some column name have been renamed are follows:
|
-
Replication Support for AlwaysOn Availability Groups, Replication supports Extended Events
|
-
The previous versions of SQL Server never allowed index operations (CREATE, DROP, REBUILD) on ONLINE mode, if the index includes a Large Value Type column (VARCHAR(MAX), NVARCHAR(MAX), VARBINARY(MAX) etc).
|
-
Microsoft has released cumulative update packages for both SP2 and SP3. 1. Cumulative update package 7 for SQL Server 2008 Service Pack 2 2. Cumulative update package 2 for SQL Server 2008 Service Pack 3 For more details see:
|
-
I just learned one new thing today,you cannot create snapshot of the system databases MASTER,MODEL and TEMPDB.you can create snapshot of MSDB database with following query.
|
-
I just learned one new thing today "how to get comma separated value(CSV) for every column name in tables with COALESCE function." check out following query.
|
-
I just learned one new thing today "How to know database backup details like DBname,backup start time,backup end time,recovery model,total DBsize,backup location etc.with t-sql." check out following query.
|
-
I just learned one new thing today "How to know Maintenance Plan name,description,create date,owner information with using system table sysmaintplan_plans in MSDB Database,all Maintenance Plan related data stored in MSDB database.
|