Posted
by SDReyes
on Stack Overflow
See other posts from Stack Overflow
or by SDReyes
Published on 2010-04-27T04:09:39Z
Indexed on
2010/04/27
4:13 UTC
Read the original article
Hit count: 289
It's possible to capture a query's result using SQL Server Profiler?
© Stack Overflow or respective owner
as seen on SQL Authority
- Search for 'SQL Authority'
I am glad to announce that along with SQLAuthority.com, I will be blogging on the prominent site of SQL Server Magazine. My very first blog post there is already live; read here: Beginning SQL Server: One Step at a Time.
My association with SQL Server Magazine has been quite long, I have written nearly…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Hi,
I need to configure SQL Server aliases on a public-facing production server. To do that, I need to install SQL Server Configuration Manager.
I was not able to find a standalone installer for that, so I am having to install SQL Server 2005 Client Components. This approach is not ideal as we don't…
>>> More
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it.
We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i am connecting to sql server 2000 on a remote computer with a dotnet application, but when i try to open the connection it gives the following error:
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections
What…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
If in SqlProfiler you can see that to execute a query a Scan is Started, does this mean a full table scan or can it just be a lookup? If it can be both, how can you tell which one of the two it is?
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Using Entity Framework 4 with stored procedures and SQL Server 2008 SP1... When running SQL Server Profiler (TSQL_SPs template), the lines that show my stored procedure call and its statements say that they executed in DatabaseID = 1 (Master) but it is actually happening in my application database…
>>> More
as seen on Server Fault
- Search for 'Server Fault'
Even though the log file shows that there is over 1 GB of free space, we start receiving an error message every 3 or 4 days saying that the TempDB file is full. I know cursors impact the TempDB file, but is there anything else I should be looking at to see why this keeps happening? I've tried running…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time
spid=163
duration=11310646
starttime=2010-04-06 17:45:24.480
endtime=2010-04-06 17:45:35.790
reads=152
writes=2
cpu=16
eventclass=12
textdata=…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
i've picked a query out of SQL Server Profiler that says it took 1,497 reads:
EventClass: SQL:BatchCompleted
TextData: SELECT Transactions....
CPU: 406
Reads: 1497
Writes: 0
Duration: 406
So i've taken this query into Query Analyzer, so i may try to reduce…
>>> More
