• SQL Server Log Shipping 2005 to 2008

    Does anyone know if i can logship from a sql server 2005 to a sql server 2008?

    Rick Martinez585 pointsBadges:
  • Partitioning in SQL Server 2005/2008

    We have partitioned 5 large tables across 10 partitions (with 10 filegroups) and with a set of 5 - 6 users the performance was adequate, with minimal conflicts (like deadlocks etc), but we want to implement this scheme that can scale to say 300 users. With regard to this I have the following...

    Inquisito20 pointsBadges:
  • Locking and concurrency in SQL server 2008

    In microsft SQL 2008 enterprise edition, readers block writers and writers block readers. What does it mean? Is it that on same set of records only one query be processed.

    Akansha150 pointsBadges:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • 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:
  • Oracle 10g versus Microsoft SQL Server 2008

    Require comparison between Microsoft SQL 2008 enterprise edition versus oracle 10g standard edition.

    Akansha150 pointsBadges:
  • SQL find duplicates SQL Server 2008

    Up against a SQL question that is difficult to code.  Any help is greatly appreciated.

    Jtigges5 pointsBadges:
  • Adding users to my SQL Server 2008

    How do I increase the number of users CAl to my SQL server 2008 Licensed by server?

    Georgy25 pointsBadges:
  • What is the easiest and best Front End development for SQL server.

    What is the easiest and best Front End development for SQL server. I have Visual Studio 2008 Professional IDE. VB.net or VB.

    KRMerker5315 pointsBadges:
  • Multiple rows locked in sqlserver when updating one row

    In Microsoft SQLServer, I found out that when you perform an SQL update, in a lot of cases multiple rows are locked, even when row-locking is configured for that table and page-locking is prohibited, and even when you force row-locking in the SQL statement using WITH (ROWLOCK).

    Nevenfi5 pointsBadges:
  • Encrytpion on SQL Server 2008

    I want to encrypt a stored procedure in SQL Server 2008. I tried software such as SQL shield, it's great but the problem is SQL Profiler can still record/log the content of my original SP. Is there any way to avoid SQL Profiler from recording/logging my original content? If not, do you suggest any...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Loading a new database from an Old one

    I am new to SSIS. We are running SQL Server 2008, and I have to load a new database from an old one which had a different structure. I'm not sure how to cope with PK's that are identities. For example, I have three tables: 1) Main table eg. A list of applications 2) Joiner table eg. A list of...

    SQL Server Ask the Experts2,585 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:
  • 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 2008 stored procedures and execution plans

    Hi, Is it any significant difference in performance between stored procedure with many parameters (some of them can be null sometimes) and creating many stored procedures that will contains only subset of this parameters ? Thx,  

    Bink15 pointsBadges:
  • Alter Column Drop Identity in T/SQL?

    Is it possible to alter a column definition to remove its identity property?

    Jagoodie60 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