Відео

Loved it

Como puedo programar las implementación en la tabla tabular

What’s the name?😊

Great video, thanks for sharing 👍

Nice diagram. Looking forward to your talk.

#SNÆCKS !!

Will i be able to watch it online?

#SNÆCKS

sqlserver plate number

Love the shirt

Amazing explanation .

Genial contenido 👌👌👌⚡

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

Awesome !!!

Advancing career in SE(PLSQL and Oracle, RDBMS) (Bucket list) at 30

how many children they raised, 3+

Thank you for sharing

Love you buddy 💞 #TeamHugo

very good video

😣 𝓅𝓇o𝓂o𝓈𝓂

Looking forward to your session, Mike!

Will be excited to watch your session.

Hello, Itzik. Master, I'm Jungsun :D nice to see you again. I hope you're doing well.

Thanks for sharing

Saw many videos but this one is beyond excellence. Thanks a lot Deepthi for sharing an amazing work n research with us all. this is really helpful.

could you please share custom unit test condition project codeplex link ?

Excelente explicación, hay que ponerlo en practica.

Thanks. A great session 👏

For reference for any one else watching this after me: you can just start at 3:00 to skip the announcements at the beginning

Que mal por el audio, se pierde gran parte del contenido, de igual modo, gracias.

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 :)

how come no views awesome footage

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

How do you add a sequential number to different tables?

Thanks Simon.

Anna is amazing

Es una pena la falla en el audio...

06:27 usage example: what is the performance of this server in two weeks

thanks!!

very informative video

Nice presentation 👏👌👍.

Amazing content, thank you!

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/

No clarity in your explanation... Seems just copied from kelvin Kline's presentation

Does this model support if the source are oracle, netezza, teradata other than SQL server ?

👍