GitHub

limit-trace-file-and-table-sizes.md

[!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 [!INCLUDEssDE] is used. If you trace event classes that ...
GitHub

create-a-transact-sql-script-for-running-a-trace-sql-server-profiler.md

Find out how to create a Transact-SQL script from an existing trace file or table in SQL Server Profiler. [!INCLUDE SQL Server] This topic describes how to create a Transact-SQL script from an ...
Computerworld

How to fetch a file from FTP and import into SQL Server automatically

The importance of automating processes can’t be overestimated. Most things start out as a manual procedure until you work out exactly how things should happen, but many times they stay that way ...
Redmond Magazine

Speed Up SQL Server Apps

Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...
TechRepublic

Passing table valued parameters in SQL Server 2008

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer need ...