Thanks a lot Frank, i'll give it a try tomorrow and let you know
i'm trying to run this query, and i'm getting the following error Server: Msg 170, Level 15, State 1, Line 28 Line 28: Incorrect syntax near '+'....
Database is 3GB, Buffer Cache Hit Ratio is 99.863
i have both SQL 2000 Enterprise and SQL 2005 Enterprise running on a 2 node Active/Passive Cluster servers have 8 GB each, quad core CPu's etc,etc,...
i'm currently performing some memory measurements in one of our SQL 2000 box to make sure the server is not suffering from memory performance issues....
i already stopped the sql services, and copied the ldf file to another hard drive on the sql server. i need to see the details inside this file,...
thanks guys
wow..., any way to tell the percentage of the shrink job been processed already??? Thanks
i'm shrinking 2 databases at the same time to their minimum value. i used enterprise manager to schedule the job. there won't be nobody using the...
how can i create an alert in sql, that would notify me, i would be running out of space on my database drives very soon???.... Thanks
hello guys i'm trying to figure it out a way to do this i have a table with the following data plan_ID---trans_id --- Price --- 1 -------- 10m...
oh i know that <img src='/community/emoticons/emotion-1.gif' alt=':)' />, but the last double quotation is not really a double quotation, <br />it...
i'm trying to run a query like this select * from openquery(sqlserver1,' select field1, field2 from table1 where field2 between '01/01/2004...
i would try both queries, to see the their times. i ran the first one with 400000 records on the calls table, and the loop from 61200 to 75599....
thanks guys, i really appreciate the promptly response i've had from you.<br />i've tried the first approach. <br />here is <br /><br />DECLARE...
i have a problem and i would try to do my best to explain the issue i'm having <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />i...
ok,i'll try that. thanks
well they way the update works is like this. i have a sql job that would add the 3 million records first and then would do the update on those...
hello guys i have a question. every day i'm running a process to update about 3,000,000 records on table that has like 15,000,000 records. i'm using...
i was actually running an update on one of my tables,and i got a this error 1204 severity 19 state 1, and then can not obtain a lock or something....
Separate names with a comma.
