• Sql server 2005 – query

    How to write quary to calculate second highest salary in Emp Table using  "Top" Keyword

    DotNetj5 pointsBadges:
  • CPU and RAM recommendations for our data warehouse

    We run a DWH with 3 databases. The first DB, called Staging, is the "input buffer", copies the operational data, seven source systems, 12 parallel Extraction Jobs running SSIS packages. Mostly full refresh 40 GB data every night. Second DB is called catalog. Data is transformed using about 1,500...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Looping through a Database

    http://searchsqlserver.techtarget.com/expert/KnowledgebaseAnswer/0,289625,sid87_gci1111272_mem1,00.html In the above article, it shows how to loop through each database. My question is, how would I loop through each database so that I can then use the sp_foreachtable? I am trying to use the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Switching from Bulk-Logged to Simple Recovery Model on SQL Server 2000

    Hello, I've got a SQL Server 2000 SP4 database that I am considering switching from Bulk-Logged to Simple recovery model. The reason is, there are no transaction log backups happening so the log is just growing to an unmanageable size (40+ GB). I also want to minimize/shrink the log file. What is...

    John09905 pointsBadges:
  • Merging MDF files on SQL databases after restoring from a backup

    I recently restored our SQL Server database from a backup, but unfortunately I used a Wednesday backup instead of Thursday, and it is now Friday. Is there a way to merge MDF files, to join all the data together because, as of now, we are missing Thursday’s data.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Removing and adding new space to databases.

    The scenario: SQL_SVR_A (2000)has x amount 'too much' SAN disk space that they want to reclaim/use to allocate to SQL_SVR_B (2000)- which doesn't have enough space. What is the best method to, first, remove the disk space and keep all DBs in-tact and secondly, how to add new space to ServerB,...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Storing encrypted files on an SQL Server 2000

    We are doing our final year project as a secured electronic voting system. To finish this project, we are in need of storing our votes in an encrypted form to provide security and, to do so, we are using back-end as SQL Server 2000. Is this possible or must we change our back-end?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Upgrading a 2000 database beyond Service Pack 2

    We have SQL Server 2000 SP2 on Windows Server 2003. My database cannot be upgraded beyond SP2, is there anything that I can do to make it "work"?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Monitoring log files in a SQL Server 2000 database

    I have an intermittent problem with a SQL Server 2000 database. The job, to truncate the log files, doesn't start on time, and the transaction fills up preventing users from logging in. I would like to monitor the log such that I can send an alert when the log reaches e.g. 80% full.

    SQL Server Ask the Experts2,585 pointsBadges:
  • Using SQL and Postgre on the same machine

    We have a requirement in which we need to have our Microsoft SQL Server, as a database of tomcat servers, and our Postgre SQL, as database of jboss servers, on same machine. Are there any known conflicts or issues we should be aware of?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Microsoft Visual Studio 2008 Express edition

    Hello everybody, i recently downloaded the Microsoft Visual Studio 2008 Express Edition. It has Visual Basic 2008, Visual C# 2008, Visual C++ 2008 and Visual Web Developer 2008 (all Express editions). The problem is i dont know where to start. I have programming background. i have programmed in C++...

    GK30 pointsBadges:
  • hi all

    last day i installed one new xp theam on my xp system. recently i noticed that "RUN" option deleted from my start menu. can anybody help me in this problem ? thanks in advance

    Squibc40 pointsBadges:
  • Database management plan wizard

    I installed Microsoft SQLSERVER 2008 management studio Express with advanced services. I am trying to work with Database management plan wizard. What is the navigation for that? and i don't find management plan folder under management in SSMS express...Do i need to install sql server enterprise...

    Student0045 pointsBadges:
  • Accessing MS SQL Server database from the iSeries

    How to set up TCP/ IP on both ends( SQL server and AS/400)? I keep geting "host name not found" on as400. Thanks, Lan

    Lan1230 pointsBadges:
  • Database Best Practices for index values

    I'm more of a .NET than a database guy, but sometimes we just do what we've got to do.  Please bear with me if this is an elementary question. One of the apps I'm working on now will have to parse data from another system and store the values in the database.  The data coming from the other...

    Overtech65 pointsBadges:
  • SQL Server – SSIS

    what is SSIs in Sql Server?

    90497265505 pointsBadges:
  • mssql login script

    Hello, Can anyone give me a simplet powershell script to check login attempt to remote MSSQL database.For eg: if i have a database "db" in remote sql server say 192.168.1.10 which having username"test" and password as "password".If the login is successful its output should shows as "OK" in...

    LINSONAJ5 pointsBadges:
  • SQL server STD 05 between Sites

    besides buying Enterprise($$$$$.$$), how else can I keep these servers (sych'd, mirrored, ???) via a network link between cities? Server1(win-sql-05)DB <> Server2(win-sql-05)DB

    Multilanguage25 pointsBadges:
  • Intel’s Open Port IT Scavenger Hunt has launched: Win a laptop and other great prizes.

    Think you've got the smarts to navigate Intel's Open Port community for answers to questions about Intel products? You could win a brand new 2010 Core vPro-based laptop, among other prizes. If you're an IT Knowledge Exchange member, we'll also give you 200 bonus Knowledge Points and send you a free...

    ITKE346,080 pointsBadges:
  • Auditing users of STRSQL

    I want to audit the SQL statements of users who use STRSQL. I know if you press F13, you can change the interactive SQL Session Services. If you choose option 4 it will save all SQL statements into a file. But I was wondering if it is possible if we setup this as default when starting up STRSQL? So...

    AS400 - Ask the Expert485 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