Forum Replies Created

Viewing 15 posts - 1,516 through 1,530 (of 3,061 total)

  • RE: Compare records

    chris.s.powell (9/23/2010)

    I have a table diagramed as follows:

    UserName ColumnA ColumnB Date/Time

    Tom ...

    September 23, 2010 at 2:18 pm

    #1226591

  • RE: openquery, openrowset or neither?

    rew-370421 (9/23/2010)

    Within my SQL2005 Instance (32BIT), I successfully created and queried to an Oracle database.

    From a performance perspective, should the queries be written with OPENQUERY, OPENROWSET or how?

    Both OPENQUERY...

    September 23, 2010 at 2:06 pm

    #1226582

  • RE: Schema binding across multiple databases

    vinothraj (9/23/2010)

    We need to create a clustered index by implementing schema binding in the view. As you know it throws error.

    How could I know? ... post shows nothing.

    Would you...

    September 23, 2010 at 7:50 am

    #1226327

  • RE: Table Relationships

    ronaldkrex (9/23/2010)

    Thanks for your Help. But what if I have a value in the parent Table Primary Key column. And I am trying to enter that Same value in the...

    September 23, 2010 at 5:42 am

    #1226230

  • RE: LINQ to SQL and Entity Framework - What do DBAs think of these options?

    LSAdvantage (9/17/2010)

    I am a .NET developer working with a small team of developers who have to also double as our own DBDs. Recently, the subjects of LINQ to SQL...

    September 22, 2010 at 5:28 pm

    #1226013

  • RE: Logging error in SSIS

    sravan.here (9/22/2010)

    Path does not exist..... but it worked in the older version(on server based)....the problem is when i am converting to Filed based its failing

    Pre-create the path all the way...

    September 22, 2010 at 5:15 pm

    #1226010

  • RE: Logging on locally

    fpniscott (9/22/2010)

    I just installed SQL enterprise on a server and when I try to connect to that server locally I get a log in faild for user X. When I...

    September 22, 2010 at 5:13 pm

    #1226008

  • RE: Logging error in SSIS

    sravan.here (9/22/2010)

    Hi,

    I was trying to modify a SSIS package from server based to File based.

    When we were running the SSIS from server it used to work fine although the path...

    September 22, 2010 at 5:08 pm

    #1226004

  • RE: String manipulation

    wannabe dba (9/22/2010)

    I need to extract a substring from a column .The data in the column mainly contains email addresses and I need to remove the .com,.br,.uk,.ar etc from the...

    September 22, 2010 at 4:59 pm

    #1225996

  • RE: Table Relationships

    ronaldkrex (9/22/2010)

    Here is my dilemma. I have 2 tables 1 parent and 1 child. I established a relationship between the two tables based upon the primary key of the parent...

    September 22, 2010 at 4:48 pm

    #1225995

  • RE: Proper Design pattern for Multiuser Handling (Concurrency)

    pravin.sawant99 (9/20/2010)

    Its all right but i want to know the techniques to handle concurrency i.e. Lost updates

    In regards to concurrency, concurrency is handled by locking/latching - these are well documented...

    September 22, 2010 at 2:40 pm

    #1225951

  • RE: Views Vs Tables

    Tara-1044200 (9/21/2010)

    Views are very slower than tables while querying and also the execution plans are choosen differently, how can we trick views so that it performs like a table.

    A view...

    September 21, 2010 at 4:05 pm

    #1225282

  • RE: Load Balancing on Analysis Services Servers

    trivedi.nikesh (9/21/2010)

    We want to implement load balancing on our SSAS servers. We want to create a linked server(where SQL Server Instance is installed) with SSAS servers. We want to pull...

    September 21, 2010 at 10:54 am

    #1225052

  • RE: ERD Tools

    I clearly remember the first ERD tool I used, it was a brain-powered pen and a notepad v1.0 then I got an upgrade to the blackboard edition 😀

    Looking back...

    September 21, 2010 at 10:48 am

    #1225044

  • RE: Error: 2627 PRIMARY_KEY constraint 'PK...' Cannot insert duplicate...

    EdA ROC (9/20/2010)

    CORRECTION - I just scrutinized the table and noticed menu_config_id is NOT an Identity!

    Any suggestions where to look for the 'seed value' the app is using?

    I would...

    September 20, 2010 at 9:33 am

    #1224130

Viewing 15 posts - 1,516 through 1,530 (of 3,061 total)