I have never use SQL SERVER 2005, but i find that SQL SERVER 2000 can capture the statements when using oledb interface as moh_hassan20 said.
Can SQL SERVER 2000 do that?
version: developer edition sp4
Can event profile capture sql statements when using oledb interface?
Thanks satya again. I think i understand what is a "datetime column" cluster index now.[:D]
My meaning is that: a table has many fields including one calling d_date (datetime) , and i want to select d_date for clusted index.
Is that right?...
logic sequence :
Will SQL SERVER save the data like that(physical):...
Why the next four commands' output different ?
1 DBCC SHOW_STATISTICS(ord_items, IX_ORD_ITEMS_product) WITH STAT_HEADER
I executed than command DBCC CLEANTABLE , but it did not work.
May be the only method is moving the rows to another table, then...
When i use the store procedure "sp_spaceused TableX", it will show me the messages like:
As i know, when i use DBCC SHOW_STATISTICS(A,ix_1) command, i will get the message about the statistics of table A.
I don't understand why i use the...
Thanks satya!Is there any tools except PROFILER?
I was wondering if there was any way to know how many times the store procedure was execute when the server start.
The version of the sql server is enterprise edition, not at the level sp4.
But is there any problems, when i update the sql server to...
why the error message "DBPROCESS is dead or not enabled" appear frequently , but when i run the application again ,it can connect to the server....
Thanks chiragkhabaria and khtan.
I solved that problem now, just make a mistake.
In Store procedure:
1. Insert thousands of rows to tableA.
2. Update the rows in tableA Immediately.
can i do that in the store procedure?
When i add the criteria in the store procedure, it hang, but QA not hang.
AND (ZI.location = @location or @location = 'ALL')
AND (ZI.pri = @pri...
Hi, adriaan. Thanks for your reply.
I haven't consider the index. What i want to know is why the performance executing in Query Analyzer is better...
database size is almost 1.2G
Table orderz 2840kb
Table ord_itemz 218,568kb
Table temp_order_id 88kb
The version of my SQL...
Separate names with a comma.