Get a list of SQL queries run yesterday:

-

 Get a list of SQL queries run yesterday:

  1. Queries are saved in the cache via system representations (sys.dm_exec_query_stats, sys.dm_exec_sql_text, and sys.dm_exec_query_plan)
  2. Using SQL Server Profiler
  3. Using Extended Events
  4. Using the Query Store, starting from the 2016 version
  5. Using SQL Complete (SQL Complete\Execution History) in SSMS

 

Comments

Post a Comment

Popular posts from this blog

Delete vs Truncate in MySQL and MS SQL Server

-
Delete vs Truncate in MySQL and MS SQL Server DELETE DELETE is a DML Command. DELETE statement is executed using a row lock, each row in the table is locked for deletion. We can specify filters in where clause It deletes specified data if where condition exists. Delete activates a trigger because the operation are logged individually. Slower than truncate because, it keeps logs. Rollback is possible. TRUNCATE TRUNCATE is a DDL command. TRUNCATE TABLE always locks the table and page but not each row. Cannot use Where Condition. It Removes all the data. TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions. Faster in performance wise, because it doesn't keep any logs. Rollback is possible. DELETE and TRUNCATE both can be rolled back when used with TRANSACTION (TRUNCATE can be rolled back in SQL Server, but not in MySQL ). if there is a PK with auto increment, truncate will reset the counter Learn SQL with us a PCWorkshops ! 
Read more

What Is SQLite?

-
Image
  What Is SQLite? SQLite is a C-language library designed to implement a compact, high-speed, self-contained, and robust SQL database engine . It stands as the most widely employed database engine globally, integral to the operating systems of virtually all mobile phones and the majority of computers. Additionally, it is packaged within numerous everyday applications. The SQLite file format boasts stability, cross-platform compatibility, and backward compatibility. Developers commit to maintaining this stability until the year 2050. SQLite database files serve as prevalent containers for the exchange of rich content across systems and as a long-term archival format for data . The active usage of SQLite databases exceeds a staggering 1 trillion (1e12) instances [5]. It is noteworthy that the SQLite source code is in the public domain, making it freely accessible for use by anyone, without restrictions on purpose. Learn SQLite with us at PCWorkshops.     ...
Read more

The Seven Different Types of Coding Blocks in Java

-
Java   Coding Blocks    In Java , the term "coding block" typically refers to a block of code within certain constructs that define the scope and execution context of variables and statements. There are several types of coding blocks in Java, each serving different purposes. Here’s an overview: 1. Method Block A  Java  method block is the section of code within a method. It defines the scope of local variables and contains the statements that make up the method. public class MyClass { public void myMethod () { // Method block starts here int localVariable = 10 ; System.out.println(localVariable); // Method block ends here } } 2. Class Block A  Java  class block is the section of code within a class definition. It contains the class’s fields (variables), methods, and nested classes. public class MyClass { // Class block starts here int instanceVariable; // Field public void myMet...
Read more