Category Archives: SQL-Server

T-SQL: Flush memory cache for testing purposes

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

SQL server is of course caching data, in order to minimize access to disks. Sometimes you want to clear that memory, for testing purposes for example. You can use DBCC commands in order to clear the system / proc / session cache. See the SQL below:

T-SQL: Creation date/time of tables

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

When you are looking for the creation date/time of certain tables, you can easily find that in the sys.tables.You can use the code below in order to list all tables, and the creation date of those tables.

T-SQL: Find table in complete instance

bschelst/ February 11, 2019/ SQL-Server/ 0 comments

Looking for a table, but you don’t remember in which database it’s located? The code below will create a stored procedure, which you can use in order to find a table in multiple databases.