14,151 questions 3 answers Azure Resource Graph Explorer - Retrieving DTU Percentage I am trying to use Azure Resource Graph Explorer to obtain a list of databases along with their DTU percentage. However, my query returns NULL for the DTU_percentage column. Is it possible to retrieve this inf...
1,701 questions ASP.NET ASP.NET A set of technologies in the .NET Framework for building web applications and XML web services. 3,537 questions Windows Server 2012 Windows Server 2012 A Microsoft server operating system that supports enterprise-level management, data storage, applications, and com...
14,149 questions 3 answers Azure Resource Graph Explorer - Retrieving DTU Percentage I am trying to use Azure Resource Graph Explorer to obtain a list of databases along with their DTU percentage. However, my query returns NULL for the DTU_percentage column. Is it possible to retrieve this inf...
Advanced SQL Interview Questions for Experienced 35. Write a query to fetch employees who earn more than the average salary. SELECT * FROM Intellipaat_Emp WHERE salary > (SELECT AVG(salary) FROM Intellipaat_Emp); 36. How would you find the 2nd highest salary from a table called Employees...
2,760 questions Sign in to follow asked Dec 10, 2024, 9:10 PM Ram PS 0 Reputation points commented Dec 12, 2024, 3:06 PM Jiachen Li-MSFT 32,961 Reputation points • Microsoft Vendor 1 answer SCOM DW Query to retrieve Web Application Transaction requests Management is requestin...
14,165 questions 4 answers tsql sum amount recursively without recursive cte Hi, I need help creating recursive query to sum up Amounts of all ChildIDs for parent ID=1 node. Table definition and data below. This is for SQL serverless where Recursive CTE is not supported. So left join woul...
Couple of questions on SQL Server 2008 - Beginner Covert sql output into excel and schedule the automate job that runs every friday and send email with attachment . Coverting UTC date time to local date time in sql server CR and LF not working in a SELECT statement create a job without sq...
Send your questions and comments for Rob toxtrmasp@microsoft.com. Rob Howardis a founder of Telligent Systems, specializing in high-performance Web apps, knowledge management, and collaboration systems. Previously, Rob was employed by Microsoft where he helped design the infrastructure features of ASP...
Send your questions and comments for John tommdata@microsoft.com. John Papais a baseball fanatic who spends most of his summer nights rooting for the Yankees with his two little girls, wife, and faithful dog, Kadi. He has authored several books on ADO, XML, and SQL Server and can often...
Query 1: Write a query to create the table in Structured Query Language. ADVERTISEMENT ADVERTISEMENT Sol: ADVERTISEMENT ADVERTISEMENT Syntax to Create a Table in SQL: CREATETABLEtable_name ( column_Name1 data type (sizeofthecolumn), column_Name2 data type (sizeofthecolumn), ...