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
Vinay Thakur
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,265 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
752 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,215 reads
Denali — Day 6: indirect Checkpoint
Denali – Day 6: indirect Checkpoint
I have already blog some information about checkpoint here
As I have already blog about Checkpoint and...
2012-05-06
1,558 reads
Denali — Day 5: Column-store indexes (aka Project Apollo)
Denali – Day 5: Column-store indexes (aka Project Apollo)
There is another great achievement for Denali, especially for Data warehouse, where data...
2012-05-05
805 reads
Blogs
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers