|
|
-
I just learned one new thing,"How to find different objects, which are used in database like tables,stored procedures,functions,views etc." check out following query...
|
-
Here are different compatibility levels specified by sql server version. Check out following list:
|
-
SP_DBREMOVE can be used to drop database and its associated files. However it will be removed in next sql server version.
|
-
oday I learned one new thing,"how to fetch top 5 rows without using TOP clause" let's check example with offset-fetch option of Order clause in SQL Server 2011 Denali. --With TOP clause...
|
-
Today I learned one new thing,Partition Support increased with SQL 11 "Denali" CTP3, earlier version of SQL Server supported 1000 partitions by default.Now SQL Server 11 "Denali" CTP3 supports 15000 partitions by default...
|
-
Today I have learned one new thing,SQL Server 20011 "Denali" CTP3 support Online rebuild index with varchar(max),nvarchar(max) and varbinary(max) columns. let us check with an example...
|
-
Today i learned one new Datetime function TIMEFROMPARTS arrived with SQL 11 CTP3. TIMEFROMPARTS-Returns a time value from the specified time and precision. it takes 5 arguments. syntax is:..
|
-
I just learned today one new datetime function DATEFROMPARTS arrived with SQL 11(Code-name) "Denali" CTP3. DATEFROMPARTS- Returns date value from the specified year,month and day.
|
-
SQL Server 2011 Code name Denali CTP3 arrived with New Features, Some of new features are listed below:
|
-
I just learned "how to delete old backup database files with using undocumented extended stored procedure" ...
|