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. but...
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 : row1:2008-01-01 12:03:24 row2:2008-01-02 12:03:24 row3:2008-01-01 12:03:24 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 2 DBCC...
Thanks jagblue 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: name: TableX rows:34221 reserved:30192 kb data:19552 kb...
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.
hello satya: 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.
