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

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. If ...

SQL Server, FileTable object [!INCLUDE SQL Server ] The SQLServer:FileTable performance object provides counters for statistics associated with FileTable and non-transacted access. This following ...

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 ...

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 ...

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.