Viewing 15 posts - 706 through 720 (of 1,179 total)
I suspect there though dbmail has not been configured somewhere your job is trying to generate mail report. Check your maintenance plan or job for any such options. Also check...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 6, 2010 at 2:12 am
Each transaction will be loged into the transaction log for simple, bulk-loged or full recovery.
If simple recovery is set than transaction log truncated after each transaction commits and hence...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 5, 2010 at 12:04 am
If SQL Server configuration is fine execute following commnad to find memory related details.
select * from sys.dm_os_performance_counters where object_name like '%Memory Manager%'
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 29, 2010 at 6:41 am
Good Question, Thank you!!!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 15, 2010 at 3:26 am
Yes, me too worng....
The correct answer is none. As though resource database is readonly we can move it along with master.
http://msdn.microsoft.com/en-us/library/ms345408.aspx
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
September 9, 2010 at 7:05 am
Actually it depends, what exactly your customers requirement is.....
because from budget to latency and dataloss it depends.
But I guess budget is low and latency will be fine from your description....
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 30, 2010 at 5:23 am
If I guess correctly you are facing this problem after perfroming the BCP. I suggest you rebuild the indexes of respective table after doing BCP.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 30, 2010 at 5:10 am
If the database is in use you will not be able to put it offline.
For that you do have two option:
1. Kill the connection to the respective database
2. In addition...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 30, 2010 at 4:57 am
From cluster can you try to access the shared folder where you are copying the file for LS? Use same login which is set up for LS.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 11, 2010 at 1:31 am
check Alter login...
http://msdn.microsoft.com/en-us/library/ms189828.aspx
This will help you. You just need to create small programme to do it automatically.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 10, 2010 at 7:25 am
Also make a note that table scan is not always BAD!! As mention by Gilamonster SQL Server is smart enough to select best execution plan for your query :-).
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 9, 2010 at 3:56 am
Aaha... I got the article finally...
http://www.sqlskills.com/BLOGS/PAUL/post/Benchmarking-do-multiple-data-files-make-a-difference.aspx
Hope this will hlep you.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 9, 2010 at 3:22 am
Restructuring File & File group will surely help you in maintenance as mention in the above posts also you will be benefited for the performance as you will have multiple...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 9, 2010 at 3:12 am
pl. be more specific? what exactly would you like to do?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 9, 2010 at 1:58 am
Here your object is to run the query online. But I am not sure how it will helpful? As your database structure is different.
Now to overcome your issue I...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 9, 2010 at 1:45 am
Viewing 15 posts - 706 through 720 (of 1,179 total)