I have a database xyz and need to get all the table names, its column names and its length.
- Which DMV should I use?
- Is there a DMV...
I have this .mdf file which is being generated by a different team.
The database on their side has AUTO_CLOSE as OFF.
But once I...
I have a bcp command that loads data from a flat file into a table.
Currently I'm using the following bcp command for it:
The database I'm working on is in SQL SERVER 2008 and has SNAPSHOT isolation ON (See below).
This was set by executing the following:
I have this stored procedure that throws "Snapshot isolation transaction aborted due to update conflict".
Which SQL Profiler event should I turn on...
Question 1:I have this read only database against which I'm running couple of queries to record their response time.
Inspite of data being...
I ran sql profiler with Template as "TSQL_Duration" for a stored procedure(A) which inturn calls couple of other stored procedures(B,C,D)...
Below is what I'm doing to figure out the elapsed time for a query:
<Execute the query>...
Separate names with a comma.