How about snapshot ? we can take DB snapshots on PROD and execute ETL on snapshot. let me know your view / recommendation on this.
Hi, we are in the process of building ODS - Operational Data source, ODS will contain only current 3yrs data, whereas Production server contain 10yrs...
Hi, We are running SQL Server 2008 R2 64Bit , enterprise with SP1, for Storage we are using SAN. We are facing performance issue with IO below is...
I found good article @ http://www.brentozar.com/sql/sql-server-san-best-practices/
Hi, we want to implement solution to track DBA activity on SQL server 2008R2, activity's like: 1. Accessing DATA (SELECT/INSERT/UPDATE/DELETE) 2....
Is there any limit on SQL server Multiple Instances? if we require to run 60+ Instances on single machine what will be the minimum hardware...
Hey, Frank and Roji thanks for your comment, I think my problem would get resolve by this. I am returning VARCHAR Data type. Sachin
Hello, I am Migrating one database of Mysql to SQL server 2005, I am facing problem with Views where in Mysql they have GROUP_Concat (aggregate...
Hello, I am also facing the same issue, as we want to restrict Users do not establish coneections more than 10 , I mean user sachin should not...
I tried to take backup with Quries (Manually) and it works but i trying the same with scheduller it won't work any idea ? Sachin
hello,<br /><br />I am using sql 2005 on widnows 2003 i configured on maintenency job for taking backup for user databases. out of 7 it backup 4 and...
Hello, i am getting lot many information Event's in Application Log. i am using windows 2000 with SQL Enterprise 2000 SP4. can i stop there event's...
hi, i am using windows 2000 SP4 with MS-SQL 2000 SP4 (130 databases). i am continusly getting below event's in eventlog. i want's know the mening of...
is there any thing synchronous/asynchronous mode in SQL .. and how to set them.. Sachin
it works with DTS .. and i set remote query time out to 1200 Sachin
we kept our server at ISP with global ip and with normal TCP/IP Port Filtering (windows 2000 Server sp4). i don't think there are any chnages with...
i found more links but won't satisfy or resolve the issue http://support.microsoft.com/default.aspx?scid=kb;en-us;140536...
am running SQL 2000 Enterprise edition V. Microsoft SQL Server 2000 - 8.00.760 (Intel X86) i am getting below errors... when i am fetching 200...
Separate names with a comma.
