• If running two SQL Server db in two VMs, I should purchase two db servers?

    If running two SQL Server db in two VMs, I should purchase two db servers? This question is from the Microsoft Virtualization Live Chat which took place on August 27th.

    ITKE342,620 pointsBadges:
  • dbcc checkdb error; object id 0

    Hi, We have been ask by one of our customer to restore a database from SQL Server 2000 and SQL Server 2005. The restore completed however when we run a integrity check on the database errors occurred. We than ran an integrity check with repair allow data loss option, as the customer is happy to...

    Db23290 pointsBadges:
  • Trigger Use

    I have a Sequel Server 2005 database with a Table called Main Call Issue. I want to update the DateTimeModifed field to be the Current System date without changing my original DateTimeAdded field when the record was added to the database. I know a Trigger will work here. Where do I place the...

    Jjc98105 pointsBadges:
  • SSRS – SQL runs in 1 minute but Reporting Services tuns for 30 minutes

    I have a report whose dataset query that takes approximately 1 minute to run in SQL Management Server. That same query in a Reporting Services report takes aver 30 minutes to run. And it is inconsistent in its behavior since sometimes it will never finish running and error out. When it does run...

    Cvillavicencio35 pointsBadges:
  • The most-watched IT questions this week: Sept. 15, 2009

    As part of a new feature on the IT Knowledge Exchange Community Blog, we're highlighting the top 10 most-watched questions. Here are the top 5: Virtualization vs. ConsolidationTracing a computer to an IP addressConnect remote Oracle 11g server in VB 6.0How to utlize multiple static IP's when ISP...

    Michael Morisy8,323 pointsBadges:
  • SQL Database User

    Hello, I have 3 servers running sql server 2005 server1, server2, and server3 with database1 and database2 respectively. I backup database1 on server1 and backup database2 on server2 then I restore database1 and database2 on server3 as read-only on a daily basis. I only want to use one sql...

    Rick Martinez585 pointsBadges:
  • App-V application license requirements

    So if the receiver of the App-V application which has an embedded SQL Server in it already has a liscense to access an SQL Server then ther are no new liscenses required. If that is not the case then the receiver of the App-V application will need to purcahse what? This question is from the...

    ITKE342,620 pointsBadges:
  • What are the licensing requirements associated with App-V?

    What are the licensing requirements associated with App-V? That is if the application being virtualized uses SQL Server and it is part of the virtual application does the user of the App-V package require a full SQL Server license? This question is from the Microsoft Virtualization Chat held on...

    ITKE342,620 pointsBadges:
  • Applying snapshot on Subscriber – SQL SERVER 2005

    hi, i've read on this articlehttp://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1362610_mem1,00.html about applying snaphot on the subscriber by copying the snapshot on the distributor and sending it to the subscriber. i didnt get what/how this part.  When the snapshot is created and the...

    Raptur3d5 pointsBadges:
  • Controlling tempdb Growth

    I have a user running a SAS job that kicks tempdb from 8.5M to 6.6Gig in less than ten minutes. tempdb is on the default C: partition, which is only 16G (I have no control over that ridiculous size)! I’m new at this so I’m thinking my only option is to MOVE tempdb because of the space...

    VelameLaCosa110 pointsBadges:
  • can one use App-V to install SQL Server as part of a virtualized application?

    can one use App-V to install SQL Server as part of a virtualized application? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE342,620 pointsBadges:
  • How can one ‘v-app’ an application that uses a db like SQL 2008 express?

    How can one 'v-app' an application that uses a db like SQL 2008 express? This question is from the Microsoft Virtualization Chat held on August 27th.

    ITKE342,620 pointsBadges:
  • Data model for Custom fields and Custom forms.

    Hi, I plan to build a web application which would have dynamic forms with custom fields. he can create one module, web form having some custom fields.So these fields can be created by customer itself through web application. To make this enable i believe I should have some tables to store meta data...

    SQLServer200810 pointsBadges:
  • Community Update: The IT Blog Top 10 for Sept. 10, 2009

    As part of a new feature on the Community Blog, each week we'll be doing a run down of the 10 most popular blog posts over the previous week, in case you were wondering what your peers were reading or a hot topic somehow missed your radar. Still think we missed something? Send me an e-mail at...

    Michael Morisy8,323 pointsBadges:
  • Error copying indexes in DTS package

    I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a...

    Bleeb45 pointsBadges:
  • SQL select loop list?

    Say I want to derive the following: Select ID, F1 from table Union Select ID, F2 from table Union Select ID, F3 from table Union … etc until F10. Is there smart and easy way so that I can just provide a list: F1,F2,F3,…,F10 and somehow be able to have the select statement loop through it? Also,...

    Vinical5 pointsBadges:
  • SQL server 2000 increase database auto-grow

    Does it matter to increase database auto-grow from 10MB to 250MB? We expereience some bottleneck at database size of 36 GB for a reporting database. But the physical disk has 100 GB free disk space, CPU usage is not high. Occasionally has some COM error Not sure what the problem it is

    ITKE342,620 pointsBadges:
  • Why should I use SSAS for Predictive Analytics?

    We are considering tools for Predictive Analytics in Law Enforcement, and I have been asked to find the advantages of SSAS, especially in SQL 2008. What are your thoughts on the product and what can it do for us?

    Bubbuh5 pointsBadges:
  • SQL dynamic date calc.

    How shall the WHERE clause look for this challenge: Pseudocode: select all records from file where datefield (ccyymmdd 8.0) shall be greater than todays month minus 36 months. As you can see this may be expressed as [em]rolling 36 full months plus current month[/em]. Any help will be apreciated....

    DanTheDane2,555 pointsBadges:
  • SQL 2008 mirroring – are jobs active on mirror on just on failover?

    When mirroring SQL 2008 Databases when the principal is active do the jobs run on the mirror or just on failover?

    LewHill5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following