What is it from web page that initiated on SQL side, I mean to say Dynamic queries or stored procedures? I have seen similar problem when the t-sql...
It should be based on your SLA with business on worst case secnario what is the minimum data loss they like to keep it. If your business users says...
should look under job activity monitor under SQL server agent.
Second is better option. Yes, it is multiple joins but it will be better for performance and other stuff. The join will be only one time.
So satya, can SSIS supports multiple MSDB databases? I see what you are saying but in secnario I am talking when my Nd1 crashed, I am forced to use...
According to microsoft, we can cluster SSIS service but it is NOT RECOMMENDED. http://msdn2.microsoft.com/en-us/library/ms345193.aspx Now this is the...
I came across situation where I want to make sure this is known. in SQL 2000 in group by clause I have to put the calculate field as its defined in...
I did a quick test and i have simple dts package that works. I am still doubting myself. Can someone know if legacy 32 bit DTS can run on 64 bit SQL...
Thank you guys.
Hello Reethu, What I am asking is how can I find what is the total memory available for SQL server instance and how much out of that used? On the...
How/where can I find the information about the memory on my SQL 2005 instance either stand alone or on cluster? What I am looking for is what is the...
if I be using mount points with my high availability enviornment with cluster on windows 2003 and SQL server 2005 with one drive letter. Isn't it...
I am having same issue. With SQL 2005 clustering 26 character drive limitation is lifted using Mount points. Mount points are used as folder under...
Hello Luis, what if I removed #6 backup database than do you think sysadmin required? Let me know.
If I would like to user to do the following tasks. 1. will need Create, Read, Update, and Delete capabilities within the Database 2. responsible...
Make sure you backup your exisitng log file in case if you need to recover afterwards. As your log is bigger than data file it looks like that you...
I did that but that creates the scripts only for user but database role (standard role) for sure is missing. So i.e. I have fixed id called Testid...
Hello All, I used to use generate script feature in SQL 2000 before I restore database and if I have to retain the id and permission. I am trying...
How can I stop log recovery on startup as database is not able to recover due to out of space on log drive? Database is recovering up to 100% and...
are these 2.5M rows part of whole table? Are you deleting whole table or certain ones? if you are deleting empty out whole table than use TRUNCATE...
Separate names with a comma.
