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...
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...
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...
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...
Is it possible to modify the SQL 2005 performance dashboad reports so it pass the database name, start and end time parameters? We used to use Read80...
As in SQL 2005 there are DMVs available. I want to ask what is the retention period for the data for these views? How long I can go back and look at...
I have application which planning to create new table with 15M rows in it. The data has been split up evenly with 3 region. What would be the faster?...
I came across problem where my query takes long time when I use UDF in my view defination as following way. 5mins to run and way more activities in...
if I run the query without set statistics time and set statistics io than it ran in 5mins 6secs. but if I turn on set statistics time and set...
I have recovery question where my active log drive has been crashed so I can not do the log backup using no_truncate for point in time recovery. but...
I am trying to migrate database maintance plan that was created under SQL 2000 and upgraded to SQL 2005. Those shows under legacy maintenance plan...
I have database with 2 transaction log files using same directory. I did check the history and I didn't find any apparent reason to do so by other...
I am restoring the database from 3rd party every night and I found that I have so many ids exists under database which comes from 3rd party. Those...
Is there anyway bulk insert possible without giving server level role permission? thanks in advance.
How I can script database user and roles for my user database from script before restore? I usually does the restore from SQL jobs every night and I...
How can I capture physical reads in SQL trace? Is it possible to capture? I am using Read80 trace. Thanks!
Separate names with a comma.
