Nurah.lee

 ⚠️ Understanding SQL Server Memory Management SQL Server Memory Usage: SQL Server does not immediately release memory even if tables are truncated or data is deleted. Memory Retention Mechanism: By design, SQL Server retains memory (buffer pool, plan cache) for performance reasons. Memory Clearing is Manual: Reducing SQL Server's memory usage must be done explicitly. Solution: Clear SQL Server Memory Manually To manually clear SQL Server memory and force it to release unused memory: 1. Clear the Buffer Cache DBCC DROPCLEANBUFFERS; 2. Clear the Plan Cache DBCC FREEPROCCACHE; 3. Clear Cache for Specific Database (Recommended) USE [syncdb]; DBCC FREEPROCCACHE WITH NO_INFOMSGS; DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS; Solution: Adjust Maximum Server Memory (Temporary Fix) If SQL Server continues to consume too much memory, limit the maximum memory usage: EXEC sp_configure 'show advanced options' , 1 ; RECONFIGURE; EXEC sp_configure 'max server memory...

  To check the size of your database in SQL Server , you can use the following query: Chatgpt - Refer this  https://chatgpt.com/share/681c2bc9-c948-8001-8530-d2563ec53c59 1. Check Database Size (Data + Log) USE YourDatabaseName; GO EXEC sp_spaceused; 2. Detailed Database Size (Data and Log Separately) SELECT      name AS FileName,     size * 8 / 1024 AS SizeMB,      max_size * 8 / 1024 AS MaxSizeMB,     physical_name AS FilePath,     type_desc AS FileType FROM sys.master_files WHERE database_id = DB_ID('YourDatabaseName'); 3. Size of All Databases on the Server SELECT      DB_NAME(database_id) AS DatabaseName,     SUM(size * 8 / 1024) AS SizeMB FROM sys.master_files GROUP BY database_id; Analysis and Recommendations: High Index Size: Your index size is almost as large as your data size (4.09 GB for indexes vs 4.83 GB for data). This suggests you may have many indexes , including unused ...

  Refer link:  Keyword on Google: bad data visualization examples bad dashboard examples powerbi link 9 Bad Data Visualization Examples That You Can Learn From - https://www.gooddata.com/blog/bad-data-visualization-examples-that-you-can-learn-from/ Bad Data Visualization: 9 Examples to Learn From -  https://www.luzmo.com/blog/bad-data-visualization Dashboard examples: The good, the bad and the ugly -  https://www.matillion.com/blog/dashboard-examples-the-good-the-bad-and-the-ugly Power BI Dashboard Design: Avoid These 7 Common Mistakes -  https://zebrabi.com/power-bi-dashboard-design/ reddit discussion https://www.reddit.com/r/dataisugly/search/?q=poor+data+visualization+examples&cId=c9ce09ee-ddf4-40c4-8a97-82924c068004&iId=99a2075f-2971-4e17-8c45-ab4557e4c16e

Load data from default repo Just open the command prompt and type code as below > python Python 3.12.2 (tags/v3.12.2:6abddd9, Feb  6 2024, 21:26:36) [MSC v.1937 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information.     >>> import sklearn >>> print(sklearn.__version__)   1.6.1   >>> from sklearn import datasets >>> dir(datasets)   ['__all__', '__builtins__', '__cached__', '__doc__', '__file__', '__getattr__', '__loader__', '__name__', '__package__', '__path__', '__spec__', '_arff_parser', '_base', '_california_housing', '_covtype', '_kddcup99', '_lfw', '_olivetti_faces', '_openml', '_rcv1', '_samples...