Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL » .NET   (RSS)

SYSK 359: How to Purge Workflow Tracking Data Inserted By SqlTrackingService

To my great surprise, after doing a search for a script that would delete the events logged by the almighty SqlTrackingService service, I didn’t find one… So, I quickly created it (see below), and it seems to do the job just fine given the current table
Posted by irenak | 1 Comments

SYSK 263: .NET Stored Procs Do Not Execute in Parallel using MARS

The http://msdn2.microsoft.com/en-us/library/ms345109.aspx article has the following note in the Interleaved Execution section: “Stored Procedures written in any of the .Net languages will not interleave while managed code is executing. If the inproc
Posted by irenak | 0 Comments
Filed under: ,

SYSK 257: .NET way to analyze SQL data I/O performance

Would you like to know how many server round trips it took to retrieve your data using ADO.NET? Would about the number of bytes sent and received? Total connection time? Command execution time? Number of returned rows? Welcome to the System.Data.SqlClient.SqlStatistics
Posted by irenak | 0 Comments
Filed under: ,

SYSK 236: Using SQL Server Notification Services API Remotely

Did you notice that all samples (at least all I’ve come across) show how to use Notification Services interface running locally, i.e. on the SQL Server computer? The code snippet below shows getting a list of subscribers: Microsoft.SqlServer.NotificationServices.
Posted by irenak | 1 Comments
Filed under: ,

SYSK 80: Keyboard Shortcuts to Comment/Uncomment Code in SQL Server Management Studio and in Visual Studio 2005

If you’re a keyboard person, try this combination to comment out selected lines (works in both, SQL and Visual Studio) – press Ctrl-K, keep pressing Ctrl key and hit key C (Ctrl-K Ctrl-C). To uncomment selection, use Ctrl-K Ctrl-U.
Posted by irenak | 0 Comments
Filed under: ,
 
Page view tracker