Please click here if the page does not redirect automatically …
Source
Similar Posts
Please click here if the page does not redirect automatically … Source
How do I list all the columns in a table?
Post as a guest Source
Create effective prompts for generative AI training tools
This module covers the basic concepts of prompt engineering, the elements of an effective prompt, and best practices in prompting. By the end of this module, you’ll be able to: Critique the effectiveness of different prompt engineering techniques. Assess the clarity and relevance of instructions and context for prompt creation. Evaluate the benefits of creating…
n-Pull
Pick-n-Pull Source
Microsoft Certified: Azure Administrator Associate
As a candidate for this certification, you should have subject matter expertise in implementing, managing, and monitoring an organization’s Azure environment, including: Virtual networks Storage Compute Identity Security Governance As an Azure administrator, you often serve as part of a larger team dedicated to implementing an organization’s cloud infrastructure. You also coordinate with other roles…
sql server
Extension to @xav answer that handled table partitions to get size in MB and GB. Tested on SQL Server 2008/2012 (Commented a line where is_memory_optimized = 1) SELECT a2.name AS TableName, a1.rows as [RowCount], –(a1.reserved + ISNULL(a4.reserved,0)) * 8 AS ReservedSize_KB, –a1.data * 8 AS DataSize_KB, –(CASE WHEN (a1.used + ISNULL(a4.used,0)) > a1.data THEN (a1.used…