Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool
As blogged on “Denali – Day 11: SSMS enhancement” about Features added on...
2012-05-16
815 reads
Vinay Thakur
Denali – Day 15: Support for Windows Server Core
Denali – Day 15: Support for Windows Server Core
Windows Server Core: Microsoft Server has so many features which is not required...
2012-05-15
956 reads
Denali – Day 14: New DMV & DMF
Denali – Day 14: New DMV & DMF
As there has been so many DMV/DMF already introduced in earlier version of Sql server,...
2012-05-14
739 reads
Denali – Day 13: FileTable
Denali – Day 12: FileTable
“FileStream” is introduced in sql server 2008, for storing BLOB data like varbinary(max), it is integrated...
2012-05-13
890 reads
Denali – Day 12: More Manageability Features
Denali – Day 12: – More Manageability Features:
-K switch
With new feature added in an engine to use that feature with different way...
2012-05-12
1,195 reads
Denali — Day 11: SSMS enhancement
Denali — Day 11: SSMS enhancement
SSMS is a separate tool now, and it has enhanced features on it. This helps developer/DBA...
2012-05-11
665 reads
Denali — Day 10: Sequence object
Denali – Day 10: Sequence object
Sequence is an object introduced in Denali, this is similar to ORACLE sequence, earlier sql server...
2012-05-10
1,267 reads
Denali — Day 9: Additional Scalability Features
Denali – Day 9: Additional Scalability Features
15,000 Partitions earlier it was 1000For the enterprise system having huge amount of data to...
2012-05-09
492 reads
Denali — Day 8: Startup Parameter
Denali – Day 8: Startup Parameter
Startup Parameters means you are providing the parameter to sql server at the start of sql...
2012-05-08
755 reads
Denali — Day 7: Contained Database
Denali – Day 7 : Contained Database
Contained database is another new feature for sql server 2012 – Denali, earlier version has a big...
2012-05-07
1,216 reads
Blogs
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
The Book of Redgate: What Our Customers Say
By Steve Jones
This is from 2010, but I loved that people felt this way about Redgate...
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers