Using a vendor application we are running a process called as Flowchart run ( this is run from the application.). Vendor appln installation folder...
Based on row length you can do some calculation. Going forward you can keep track of no of rows increment each month. I guess this is just basic...
dtipton -- yes , I was wrong there. Online defrag is available in both 2000 as well as 2005. However I don't understand what bikeboy meant --...
Below is the link that talks about "lock pages in memory "setting though it does not tell the reason etc...
If you are using /PAE switch , ensure that awe enabled option is turned on. Secondly the account under which service is running should have 'lock...
If you are using AWE , then you should set max server memory otherwise SQL Server will take up all the available memory. Also for the account under...
Try the below query --- SELECT elem_value FROM metadata a, status b WHERE a.uri = b.uri AND b.status = 'Final' AND a.elem_name = 'URL' and (...
Why do you want to do this as this will increase disk I/O. I think recovery interval setting in SIMPLE recovery mode should do the trick.
Frankly I don't have exact answer, but have some thoughts if you cantry it out. Distribution of db files does not matter. What matters is your backup...
Correct me if I am wrong -- but I think online indexing in Yukon means, the system provides you facility to reindex tables with less impact rather...
I think there are two ways -- Create clustered index, defrag and then drop the index OR unload and reload the data. Frankly I haven't tried that...
You should use /3gb / pae ( for less than 16 GB RAM ) switch in boot.ini file. Then enable awe option. For greater than 16 GB RAM you should not use...
You can get a very good estimate based on array configuration utility installed in your server ( if disks were ever RAID'ed ) . IN explorer Check...
No, you cannot update text field in a trigger. IN SQL 6.5 text columns were available in triggers with null values ( meaning inserted/deleted tables...
I am not sure what your intentions are by placing on a server which does not have SQL Server installed on it. You can detach/attach as johnson...
Leave this option to default so that SQL Server will process the query parellely or serialy, unless you experience any problem with that. I think 0...
Check the SQL Server Service. IT will show you the executable path. In Computer Management , click on Services and then double click on MSSQLSERVER...
pallavi/ekata - I am not sure how you are using it but I know in my case we removed that concept. I was handling an healthcare application that was...
... One thing I forgot to mention is that atleast in OLTP env, you should separate tran log file location with data file location for performance...
I don't think we can control virtual log files. This is something that SQL Server manages internally. But as and when space is allocated to the log...
Separate names with a comma.
