Microsoft SQL Server identify I/O bottlenecks
You can also identify I/O bottlenecks by examining the latch waits. These latch waits account for the physical I/O waits...
2010-03-19
2,337 reads
Blogs
Fixing a giant or running a SQL Server project deployment with Temporal tables
By Rayis Imayev
(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...
Azure Cosmos DB introduction
Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...
Display dates between two input dates using SQL DATEDIFF function in SQL Server
SQL Server has a very useful function called DATEDIFF. This function is used to...
Forums
Create View in stored procedure
Hello, I'm new here and currently learn SQL Server. For my program I try...
Optimize Query
--####################################### --Given Rawdata --####################################### create table #Base (C1 char(1),C2 char(3)) insert into #Base values...
Static data masking is not showing in 18.0 above
I read this article trying to understand the feature of data masking in SQL...
Ask SSC