Viewing 15 posts - 1,426 through 1,440 (of 5,103 total)
select percent_complete from sys.dm_exec_requests where command like 'RESTORE%'
That can tell you the "percent" at which the restore is done.
October 30, 2007 at 1:03 pm
In addition :
IF @@ROWCOUNT > 0
@Param4 = 1
should be:
IF @@ROWCOUNT > 0
SET @Param4 = 1
October 23, 2007 at 1:57 pm
tklimczak (10/19/2007)
For example i have table with 31721 rows this table takes 250MB.This table has clustered index and 5 non-clustered.
dm_db_index_physical_stats show me that
avg_fragmentation_in_percent = 66.6666666666667
avg_page_space_used_in_percent = 73.9189523103533
You are *not* shrinking...
October 19, 2007 at 3:20 pm
October 19, 2007 at 3:17 pm
Matt Miller (10/18/2007)
Structure the new organization as a pure technocracy. Possible bylines/mottos:
- "Two DBA enter - one DBA leave" (as...
October 19, 2007 at 2:31 pm
OBjectID is available for SP:Statement *NOT* For SQL:Batchcompleted *NEITHER* RPC:Completed . So if your queries are mostly stored procedures you are lucky but if like most cases you have...
October 17, 2007 at 3:47 pm
Totally second others here.
If you need help from us you should "POLITELY" ask, we are all voluntiers and you don't do that when you are trying to get other people's...
October 17, 2007 at 3:34 pm
Ashok Bachu (8/6/2007)
Hi,
I am trying to achieve the same thing here, but I could n't.
I am getting an error " xxxx" from the Distribution agent.
I am using sql 2000 as...
October 17, 2007 at 2:58 pm
The implementation of this at the DB Level implies also are :
1. "CLR" memory must be consumed. In other words less Memory / CPU for what SQL Does best.
2....
October 17, 2007 at 2:41 pm
James A. Schimmels (10/17/2007)
True, but that's why you backup the log file every so often during the day...Jim
You can not backup the log file on a database with SIMPLE recovery...
October 17, 2007 at 1:50 pm
Before getting to that point you should really need to Identify "IF" the I/O rate you have can not be reduced with proper index/design . This path is to be...
October 17, 2007 at 1:42 pm
To be honest I would not do this on the DB Server. I'd rather have a client App do the WebService search ... but then again is your call, not...
October 17, 2007 at 11:51 am
joachim.verhagen (10/17/2007)
October 17, 2007 at 11:50 am
Jeff Moden (10/17/2007)
Thanks, Noel... that's why I like this place... I learn something new everyday 🙂 I'll check out BOL on that. Thanks again.
Count me in. That makes...
October 17, 2007 at 11:46 am
Hmmm I think I saw this request before 😉
October 17, 2007 at 11:44 am
Viewing 15 posts - 1,426 through 1,440 (of 5,103 total)