Viewing 15 posts - 45,601 through 45,615 (of 49,571 total)
Tanveer (7/17/2008)
Your solution will work only when I can predict a downtime.My query is for unplanned system crash. Hence I guess I need some other solution.
System crashes are by definition...
July 18, 2008 at 7:00 am
I'm not sure there is a way. You can get the currently executing statement from the sys.dm_exec_sql_text funtion, getting the sql_handle from sys.dm_exec_connections or sys.dm_exec_sessions, but that will just show...
July 18, 2008 at 6:51 am
Last time I saw that message it was because an online rebuild of the index wqas occurring at the same time. Check that.
July 18, 2008 at 6:48 am
As a first pass, that the query is using index seeks, not scans and there are no lookups.
I notice that all but one of the indx operations are full scans.
July 18, 2008 at 6:39 am
Some of those sound familiar.
The table in question also had 34 NC indexes, all with the same leading column, 80% with the same second column. The leading column of all...
July 18, 2008 at 6:37 am
All of them please. Zipped and attached it they're that big.
I'm less interested in the indexes it did use than the index it might not be using that could be...
July 18, 2008 at 5:47 am
Please post the table and index definitions.
July 18, 2008 at 5:41 am
I'll move my comment from the other thread, to keep everything together.
What you have there is a cross join. With no join conditions between the tables, each row in the...
July 18, 2008 at 5:38 am
As far as I know, the info about After/Instead of is just in the script of the trigger in SQL 2000.
SQL doesn't have a before trigger
July 18, 2008 at 5:23 am
sbalaven (7/18/2008)
I tried in SQL 2000 version. But it is not working.
You posted in the 2005 forums, hence I assumed you are using SQL 2005.
Please use the appropriate forum...
July 18, 2008 at 5:14 am
thiras (7/18/2008)
Why it is not possible to do so? Is because of any SS2k5 internal issue (security, administration, etc.)?Vlad.
Reliability. Modifying system objects cause assorted problems in SQL 2000 due...
July 18, 2008 at 5:09 am
free_mascot (7/18/2008)
You can't recover deleted rows unless and untill you are using checkpoint.
Checkpoints happen automatically and just write dirty data pages to disk. It's BEGIN TRANSACTION that allows data...
July 18, 2008 at 5:05 am
shiwani2002sg (7/18/2008)
July 18, 2008 at 4:49 am
SELECT OBJECT_NAME(object_id), name FROM sys.columns WHERE is_identity = 1
July 18, 2008 at 4:47 am
thiras (7/18/2008)
Hi all!Is there a way to alter system stored procedures in SQL Server 2K5?
No. Neither the system tables nor the system procedures can be modified in any way
Manipulating system...
July 18, 2008 at 4:43 am
Viewing 15 posts - 45,601 through 45,615 (of 49,571 total)