Stored procedures:
- SP:StmtStarting
- SP:StmtCompleted




In SQL Server Profiler 2008, when starting/configuring the trace, go to the &quot;Events Selection&quot; tab, click on the &quot;Show all events&quot; checkbox, and then in the list under the Stored Procedures section select the  SP:StmtStarting and SP:StmtCompleted events to be included in the trace.

I&#39;m developing an application targeting .NET Framework 2.0 using C# for which I need to be able to find the default application that is used for opening a particular file type.

I know that, for example, if you just want to open a file using that application you can use something like:

    System.Diagnostics.Process.Start( &quot;C:\...\...\myfile.html&quot; );

to open an HTML document in the default browser, or

    System.Diagnostics.Process.Start( &quot;C:\...\...\myfile.txt&quot; );

to open a text file in the default text editor.

However, what I want to be able to do is to open files that don&#39;t necessarily have a *.txt* extension (for example), in the default text editor, so I need to be able to find out the default application for opening *.txt* files, which will allow me to invoke it directly.

I&#39;m guessing there&#39;s some Win32 API that I&#39;ll need to P/Invoke in order to do this, however a quick look with both Google and MSDN didn&#39;t reveal anything of much interest; I did find a very large number of completely irrelevant pages, but nothing like I&#39;m looking for. 

Finding the default application for opening a particular file type on Windows

What&#39;s the best way to trim a DateTime object to a specific precision?  For instance, if I have a DateTime with a value of &#39;2008-09-29 09:41:43&#39;, but I only want it&#39;s precision to be to the minute, is there any better way to do it than this?

    private static DateTime TrimDateToMinute(DateTime date)
    {
        return new DateTime(
            date.Year, 
            date.Month, 
            date.Day, 
            date.Hour, 
            date.Minute, 
            0);
    }

What I would really want is to make it variable so that I could set its precision to the second, minute, hour, or day.

Is there a better way to trim a DateTime to a specific precision?

I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database.  I recently discovered that trigger execution is not included in the trace.  After looking through available events for a trace, I do not see any that look like they would include trigger execution.  Does anyone know how to setup a trace to monitor the execution of triggers?

How to get SQL Profiler to monitor trigger execution

<p>I have a trace setup for SQL Server Profiler to monitor SQL that is executed on a database.  I recently discovered that trigger execution is not included in the trace.  After looking through available events for a trace, I do not see any that look like they would include trigger execution.  Does anyone know how to setup a trace to monitor the execution of triggers?</p>


I have a database with user &#39;dbo&#39; that has a login name &quot;domain\xzy&quot;.  How do I change it from &quot;domain\xzy&quot; to &quot;domain\abc&quot;.

Sql Server 2005 how to change dbo login name

In Oracle, I can re-create a view with a single statement, as shown here:

    CREATE OR REPLACE VIEW MY_VIEW AS
    SELECT SOME_FIELD
    FROM SOME_TABLE
    WHERE SOME_CONDITIONS

As the syntax implies, this will drop the old view and re-create it with whatever definition I&#39;ve given.

Is there an equivalent in MSSQL (SQL Server 2005 or later) that will do the same thing?

SQL Server equivalent to Oracle&#39;s CREATE OR REPLACE VIEW

I have never clearly understood the usage of `MAXDOP`. I do know that it makes the query faster and that it is the last item that I can use for Query Optimization. 

However, my question is, when and where it is best suited to use in a query?



What is the purpose for using OPTION(MAXDOP 1) in SQL Server?

I am currently investigating how to make a connection to a SQL Server database from my Java EE web application using Windows Authentication instead of SQL Server authentication. I am running this app off of Tomcat 6.0, and am utilizing the Microsoft JDBC driver. My connection properties file looks as follows:

    dbDriver              = com.microsoft.sqlserver.jdbc.SQLServerDriver
    dbUser                = user
    dbPass                = password
    dbServer              = localhost:1433;databaseName=testDb
    dbUrl                 = jdbc:sqlserver://localhost:1433

I have zero problems with connecting to a SQL Server database in this fashion when using SQL Server authentication.

Is there any way I can retrieve the credentials of the user&#39;s Windows Authentication and use __that__ authentication for SQL Server?

__UPDATE__: I know in ASP.net there is a way to set up Windows Authentication for access to the webapp, which is exactly what I am looking for, except I want to pass that token off to SQL Server for access to the database.

Can I connect to SQL Server using Windows Authentication from Java EE webapp?

How do I in SQL Server 2005 use the DateAdd function to add a day to a date




SQL Server 2005 Using DateAdd to add a day to a date

I would like this to be the ultimate discussion on how to check if a table exists in SQL Server 2000/2005 using SQL Statements.

When you Google for the answer, you get so many different answers. Is there an official/backward and forward compatible way of doing it?

Here are two possible ways of doing it. Which one among the two is the standard/best way of doing it?

First way:

    IF EXISTS (SELECT 1 
               FROM INFORMATION_SCHEMA.TABLES 
               WHERE TABLE_TYPE=&#39;BASE TABLE&#39; 
               AND TABLE_NAME=&#39;mytablename&#39;) 
       SELECT 1 AS res ELSE SELECT 0 AS res;

Second way:

    IF OBJECT_ID (N&#39;mytablename&#39;, N&#39;U&#39;) IS NOT NULL 
       SELECT 1 AS res ELSE SELECT 0 AS res;

**MySQL** provides the simple 

    SHOW TABLES LIKE &#39;%tablename%&#39;; 

statement. I am looking for something similar.



Check if table exists in SQL Server

How can I have a dynamic variable setting the amount of rows to return in SQL Server? Below is not valid syntax in SQL Server 2005+:

    DECLARE @count int
    SET @count = 20
    
    SELECT TOP @count * FROM SomeTable



Dynamic SELECT TOP @var In SQL Server

I want to return top 10 records from each section in one query. Can anyone help with how to do it?  Section is one of the columns in the table.

Database is SQL Server 2005. I want to return the top 10 by date entered.  Sections are business, local, and feature.  For one particular date I want only the top (10) business rows (most recent entry), the top (10) local rows, and the top (10) features.

Select top 10 records for each category

I have months stored in SQL Server as 1,2,3,4,...12. I would like to display them as January,February etc. Is there a function in SQL Server like MonthName(1) = January? I am trying to avoid a CASE statement, if possible.

Convert Month Number to Month Name Function in SQL

How do I limit a SQL Server Profiler trace to a specific database? I can&#39;t see how to filter the trace to not see events for all databases on the instance I connect to.

SQL Server Profiler - How to filter trace to only display events from one database?

I downloaded [SQL Server 2008][1] and can&#39;t seem to find [SQL Profiler][2] anywhere.

I believe I installed the SQL Server Enterprise Express/trial version?

I guess it was Express and not Enterprise after all right?

  [1]: http://en.wikipedia.org/wiki/Microsoft_SQL_Server#SQL_Server_2008
  [2]: http://msdn.microsoft.com/en-us/library/aa173918%28SQL.80,printer%29.aspx


Where is SQL Profiler in my SQL Server 2008?

Trying to understand what Sql Profiler means by emitting &quot;sp_reset_connection&quot;.

I have the following, &quot;exec sp_reset_connection&quot; line followed by BatchStarting and Completed,

    RPC:Completed	    exec sp_reset_connection
    SQL:BatchStarting   SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c]
    SQL:BatchCompleted  SELECT [c].[TestID] AS [TestID], [c].[Description] AS [Description] FROM [dbo].[Test] AS [c]	

Basically does first line &quot;exec sp_reset_connection&quot; mean the whole process (my connection was opened, the select stmt is run, then the connection is closed and released back to pool) just take place?  Or my connection is still in open stage.

And, why does the sp_reset_connection executed before my own select statement, shouldn&#39;t it the reset come after user&#39;s sql?

I&#39;m trying to know is there a way to know in more detail when a connection is opened and closed?

By seeing &quot;exec sp_reset_connection&quot;, does that mean my connection is closed?


What does &quot;exec sp_reset_connection&quot; mean in Sql Server Profiler?

The output from a SQL Server trace in profiler contains the columns CPU and Duration (amongst others). What units are these values in?



SQL Profiler CPU / duration units

I&#39;m running a data import (using C#/Linq), and naturally I&#39;m trying to optimize my queries as much as possible.  To this end I&#39;m running a trace on the DB using SQL Server Profiler, with my trace filtered by my SQL login name (it&#39;s a name that can uniquely be attributed to my data import process).

Strangely enough, most of my SQL statements are really quick :) - very few queries even break over the 1ms mark.  But spaced in between all my queries are several rows where the EventClass is &quot;Audit Login&quot; or &quot;Audit Logout&quot; - and the duration of an &quot;Audit Logout&quot; can be up to a minute!

Has this got something to do with the fact that I&#39;m using transactions in my import?  If so, is there any way to find which are the big-hitting queries so I can clean those up?

Content Type	Original Author	Original Content on Stackoverflow
Question	firedfly	View Question on Stackoverflow
Solution 1 - Sql Server	Mladen	View Answer on Stackoverflow
Solution 2 - Sql Server	Lachlan Wetherall	View Answer on Stackoverflow

How to get SQL Profiler to monitor trigger execution

Sql Server Problem Overview

Sql Server Solutions

Solution 1 - Sql Server

Solution 2 - Sql Server

Is there a better way to trim a DateTime to a specific precision?

Finding the default application for opening a particular file type on Windows

Attributions