Limit Trace File and Table Sizes [!INCLUDE SQL Server] SQL Trace results vary in size depending on the event classes that are included in the trace and the way in which the [!INCLUDE ssDE] is used.

FileTables, a new feature introduced in SQL Server 2012, is a unique table that reflects metadata of files in a specified folder.

Just a small tip that I use often when I have a large SQL Profiler trace. Rather than reading through trace files line by line, you can read it into a table and then query it. This syntax creates a ...

The **SQLServer:FileTable** performance object provides counters for statistics associated with FileTable and non-transacted access. This following table describes the SQL Server **FileTable** ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

As described in implementing durability for memory optimized tables, the storage requirements and its management for memory optimized tables is very different compared to the disk-based tables. If you ...

However, SQL Server data files (MDF and NDF) can get inaccessible due to a variety of reasons and paralyze all business operations. What can be done, if there is no backup of the corrupt database ...