• Page level lock in SQL 2008

    What is the meaning of page level lock in microsoft SQL 2008 enterprise edition? How many records are locked?

    Akansha150 pointsBadges:
  • Database for OLTP

    Which database is most suited for OLTP? Is it Oracle or Microsoft SQL?

    Akansha150 pointsBadges:
  • OLTP in SQL Server 2008

    While using OLTP in Micrsoft SQL 2008 enterprise edition, does the row level locking happens or table level locking happens?

    Akansha150 pointsBadges:
  • DOT NET SQL CONNECTION TIME OUT PROBLEM

    IN MY SQL CONNECTION STRING I WAS MENTION CONNECTION TIME OUT IS 500. MY SQL PROCEDURE WAS RUNNING 45 SECONDS ONLY IN QUERY ANALYZER. ITS RUN ON DOT NET PROGRAM THEN CONNETION TIME OUT ERROR WAS COMMING.

    KonguKarna5 pointsBadges:
  • Microsoft Live Chat: Introducing Microsoft SQL Server 2008 R2 on 4/22 11am ET

    Join us on April 22nd at 11am ET to hear how SQL Server 2008 R2 can provide your IT environment with an end-to-end approach that increases efficiencies, reduced costs and an increased competitive advantage for your business. Visit the blog today to learn more and ask your questions in the...

    EmNichs3,250 pointsBadges:
  • WinXP shows no logon icons

    Customer's machine was set up as a single user machine - meaning that it went straight to the desktop from booting. Now, it shows the login screen with the "To begin, click your user name" message - with NO names or icons. I've checked a number of KB articles from MS which refer to setupact.log for...

    Bobkberg1,070 pointsBadges:
  • Objects explorator FILTER doesn’t work, SQL Server Management Studio de sql server 2008

    Hello friends, On my PC (Windows Xp 2002 SP3) in SQL-Server management studio 2008, the object explorator filter doesn't work. The funnel symbol is simply greyed. I can't access to the box bialog filter parameters. Please, anybody has an idea ? Jean-Max PS : Microsoft SQL Server Management Studio...

    Poussines50 pointsBadges:
  • Will we really save money having users shut down computers at end of day?

    The article below caught my attention. It says that 217 million dollars a year is wasted just in the UK alone by employees leaving computers on overnight. I never shut mine down...my old mentor thought it was actually harmful. Needless to say, we don't have a policy about shutting down computers...

    NoFX3915 pointsBadges:
  • How to use Insert command between two servers to speed up performance

    We need to take data from a table on one server and write it to another in the fastest way possible. We tried Insert command and it worked perfectly as long as it was running on the same computer. When we tried to use it to update another computer/server on our network, none of the data got there....

    Studentofsql5 pointsBadges:
  • Implement SQL Service Broker with SP

    Hi, Can some one help me by giving a sample program in detail on how to implement service broker concept using Stored procedures across different servers, and with in a DB and between Databases. It would be a great help if I could get answer at the earlest. Regards Jeevan

    SQLHELP5 pointsBadges:
  • Data retrieval from TextBox and insert in to database

    Hi i am learning c#2008 and asp.net3.5. I want to get data from my textbox control and insert it in database so i cant find any source code or presentation so please tell me how to do it or give me site address where i can find this Thanks

    Nimitparmar19875 pointsBadges:
  • view active directory data using SQL server 2005

    How could I view active directory data using SQL server 2005. For example I have all of the data available in Human Resource system and I would like to pull some of the information to the active directory like name, position and department … ext where the user name is primary key. Thanks alot for...

    Reem15 pointsBadges:
  • test management tool

    I'm in the process of researching test management tools and was wondering if anyone has any insight to what worksfor them and what doesn't. Also any information on free vs purchasing. Soem features I'm looking for are: user story documentation, test case documentation, defect capture and process,...

    Flyershockey25 pointsBadges:
  • 16 node failover clustering in SQL Server 2008

    How can 16 node failover clustering be achieved in Microsft SQL 2008 enterprise edition? Are all nodes in active state? How many nodes can remain active?

    Akansha150 pointsBadges:
  • Retrieving records from main database and logs database

    Our system has one main database (jadeappdbase) but the system logs (logs per transaction/process) are stored on a separate database on a monthly basis (a specific database is created every start of the month to hold all the logs for the said month). How will I get certain records from the...

    SQL Server Ask the Experts2,585 pointsBadges:
  • bulk update query using sql server

    Hi , We need a way using sql server  for updating more than one rows at a time . Thanks , Pramod.  

    Pramoda5 pointsBadges:
  • Protecting Oracle report source

    Is there a way to wrap the SQL in an Orale report, or another way to protect the report source?

    RMS5 pointsBadges:
  • Policy Management – SQL Server 2008

    I have installed SQL Server 2008 Developers Edition on Laptop witrh XP. All installed ok but noted that under Management section there is no policy management. Is this a separate option during the installation or not included in the Developers 2008 edition of MS SQL Studio?

    Ganners255 pointsBadges:
  • DB2 to SQL Server migration

    We have a client that is migrating from the AS/400 DB2 to .NET and SQL Server and they want us to find them a resource to help locate and then migrate the data stored on the DB2 data base to SQL Server and I was wondering if that is more for a DB2 DBA or for an AS/400 Systems Analyst? Also, the...

    SolpartDean5 pointsBadges:
  • SQL Server 2005 multi-instance cluster

    I need to set up a 2 node multi-instance SQL Server 2005 cluster (active/active). Since each node will failover to the other, can I use SQL Server 2005 Standard Edition on each node or do I need to use Enterprise Edition?

    DbaDave25 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