PASS Data Community Summit is the go-to conference for data professionals to connect, share, and learn with peers and industry leaders.
Summit 2024 will take place in-person, in Seattle, from November 4-8. This year's event will take place in the Seattle Convention Center's brand new Summit Building.
Hear from industry experts at over 200 sessions spanning a range of topics and technologies, from the Microsoft data platform to always evolving content and learning tracks expanding to incorporate PostgreSQL, Snowflake, Oracle, MongoDB, and more.
Sign up to our newsletter to receive the latest news and announcements - rd.gt/48ZYZik Find out more about the PASS Data Community Summit - rd.gt/3vIvzaj Register now - rd.gt/3Kwv6wR
Nice presentation. How do we transform data or apply business logic on the data? I mean like creating stored procedures to merge data from different tables, I need the transformed data(after applying business logic) to be exported to business users on demand. Can we do this is serverless pool? Ours is a small company. But, we have data coming from number of sources. How does this replaces sql server
Just a note, Ctrl+Shift+R pings all objects on the servers you're connected too. This can actually cause issues with other code running concurrently, such as building an index. Found this out the hard way when my boss asked me why I kept running code that jacked up his processes :)
Thank you very much for this video. I'm a student of applied sciences and I'm very interested in becoming a datascientist. Your video was very interesting with lots of useful information. :D
Excellent Presentation, an Inspiration, Unique concepts. Please keep it up so folks like here can watch and learn significant Data concepts for free and comment their ideaology, appreciate your efforts. Thank you, much Obliged.
-CREATE DATABASE HeapsDB use HeapsDB go CREATE TABLE NumbersTable(NumberValue bigint not null, BiggerNumber bigint not null, CharacterColumn char(50)) DBCC IND('HeapsDB',NumbersTable ,-1) We have around 14 types of pages Page type 1 is a datpage and Page type 10 is a IAM page The Page is of 3 Parts. 1. Header 2. Data 3. Row Offset Header for 96 bytes Data depends on DataType + 7 Bytes(Identify the Nulls) Row Offset is for Address of Every Record One page = 8192 Bytes DataPages --> Actual data Get Stored. IAM page --> Locates the DataPages. DBCC TRACEON(3604) DBCC PAGE('DATABASENAME',1,PAGEID,1) GO insert into NumbersTable select NumberValue, NumberValue + 5000000, LEFT(replicate((cast(NumberValue as varchar(50))),50),50) from ( select NumberValue = ROW_NUMBER() over( order by newid() asc) from master..spt_values a cross apply master..spt_values b where a.type = 'P' and a.number <= 200 and a.number>0 and b.type = 'P' and b.number <= 200 and b.number>0 ) a; select page_count, index_depth,page_Level = index_level,page_count,record_count, * from sys.dm_db_index_physical_stats (db_id(),OBJECT_ID('NumbersTable'),NULL, NULL, 'DETAILED') SELECT DB_NAME([ddips].[database_id]) AS [DatabaseName] , OBJECT_NAME([ddips].[object_id]) AS [TableName] , [i].[name] AS [IndexName] FROM [sys].[dm_db_index_physical_stats](DB_ID(), NULL, NULL, NULL, NULL) AS ddips INNER JOIN [sys].[indexes] AS i ON [ddips].[index_id] = [i].[index_id] AND [ddips].[object_id] = [i].[object_id] --Page Allocation SELECT allocated_page_iam_page_id ,allocated_page_page_id, next_page_page_id,previous_page_page_id FROM sys.dm_db_database_page_allocations (db_id(),OBJECT_ID('NumbersTable'),NULL, NULL, 'DETAILED') WHERE page_type_desc is not null and page_type_desc = 'data_page' --Create a Clustered Index create clustered index CIX_NumbersTable on NumbersTable(NumberValue) with (maxdop=1) -- Look into the data and Index pages SELECT allocated_page_iam_page_id ,allocated_page_page_id, next_page_page_id,previous_page_page_id , page_level,page_type_desc FROM sys.dm_db_database_page_allocations (db_id(),OBJECT_ID('NumbersTable'),NULL, NULL, 'DETAILED') WHERE page_type_desc is not null order by page_level desc --and page_type_desc = 'index_page' --PROVIDED BY sqlvagalla.blogspot.com/
it takes a lot of effort to put this kind of video. we will only know the pain, if we create such a video. it is very easy to comment. I think she has done an excellent job.