Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 3,061 total)

  • RE: Sudden decrease in Linked Server Performance

    andysfreeemail (10/6/2010)

    I'm still not having any luck resolving this.

    If you find a solution please let me know (Did yours happen after a reboot - what was the trigger...

    October 6, 2010 at 4:57 am

    #1232361

  • RE: Difference between Oracle & SQL Server at high level.

    saurabh.deshpande (10/5/2010)

    What are the difference between Oracle(Say Oracle 10g) and SQL Server (Say SQL Server 2005) at high level.

    Too many differences - this exceeds what can be discussed in...

    October 6, 2010 at 4:41 am

    #1232351

  • RE: Staging vs Temp tables in SSIS

    I'm in agreement with Derrick. I vote for Staging tables.

    Also, a real staging table would not add overhead to Tempdb as a temp table would do.

    October 5, 2010 at 12:28 pm

    #1231978

  • RE: Incorrect syntax near '0'.

    tmurray 69699 (10/5/2010)

    I have it after the last 0 then a , anc then conn2)

    :blink:

    October 5, 2010 at 8:54 am

    #1231776

  • RE: Group by vs. Distinct

    UMG Developer (9/29/2010)

    Sure with GROUP BY you can add a HAVING clause, but I have seen people use DISTINCT as a short-cut for grouping by all the returned columns a...

    October 5, 2010 at 8:03 am

    #1231715

  • RE: Disk Defrag

    Jon.Morisi (10/4/2010)

    I've been operating with the preference to take SQL server offline when defragmenting the disks in which SQL Server datafiles or logfiles reside on in order to avoid possible...

    October 5, 2010 at 6:43 am

    #1231636

  • RE: xp_instance_regread redirects

    Nicely documented. Thank you Howard.

    October 5, 2010 at 6:32 am

    #1231626

  • RE: historization of high volume data

    Gibou (10/5/2010)

    I'm new to sql server high volume usage. I have an application to develop and I would appreciate some advices.

    Say that I'll have to have those tables :

    - cars

    -...

    October 5, 2010 at 6:17 am

    #1231616

  • RE: Dimension problem

    riccardo.russo79 (10/4/2010)

    Paul,

    your solution is nice. I will have 50+ classes... so I will have 50+ DW with 1 DataMart each one?

    I would say it will end up being one DWH...

    October 4, 2010 at 5:25 pm

    #1231372

  • RE: How to split name in parts and search them in a column

    as-534320 (10/4/2010)

    How can i use substring() and charindex()? Can you point me a small example?

    Sure thing.

    Example below solves scenario where there is a first and last name separated by...

    October 4, 2010 at 7:17 am

    #1230980

  • RE: Bulk Insert very large compressed partitioned table and primary key

    Pablo Campanini (10/4/2010)

    Hi.

    I tried to load a very large .CSV file in primary key order to a Compressed partitioned table with the parameter ORDER by the primary key, but it...

    October 4, 2010 at 6:55 am

    #1230969

  • RE: Renaming all user created tables

    jamesmario (10/3/2010)

    Is there a script to change all the user created tables? for example, a database created with 5 tables (table1, table2,table3,table4,table5) and later wants to rename them to (table11,...

    October 4, 2010 at 6:29 am

    #1230945

  • RE: Dimension problem

    riccardo.russo79 (10/2/2010)

    I need help for modeling a new DW.

    Situation: my ETL software collects measures each quarter from 100 different tlc nodes. The measures are divided in classes (say now there...

    October 4, 2010 at 5:57 am

    #1230930

  • RE: Decrease Query execution time.

    rahulpatel112 (10/4/2010)

    I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc.

    I want to...

    October 4, 2010 at 5:45 am

    #1230921

  • RE: How to split name in parts and search them in a column

    as-534320 (10/4/2010)

    I will need to create a stored procedure to search for a person name.

    Ex:

    @name = 'John Smith'

    I would like that this stored procedure returns persons called 'John Smith' and...

    October 4, 2010 at 5:33 am

    #1230912

Viewing 15 posts - 1,471 through 1,485 (of 3,061 total)