Forum Replies Created

Viewing 15 posts - 5,761 through 5,775 (of 8,761 total)

  • RE: Today's Random Word!

    Ed Wagner (4/6/2015)

    Revenant (4/6/2015)

    djj (4/6/2015)

    crookj (4/6/2015)

    djj (4/6/2015)

    Ed Wagner (4/6/2015)

    djj (4/6/2015)

    TomThomson (4/4/2015)

    Eirikur Eiriksson (4/4/2015)

    Revenant (4/4/2015)

    Eirikur Eiriksson (4/4/2015)

    TomThomson (4/4/2015)

    crookj (4/3/2015)

    djj (4/3/2015)

    House

    Cards

    pontoon

    Catamaran

    Sail

    Mast

    Pole

    Flag

    Wave

    WAC

    1978 (Disbanded)

    Grease

    Musical

    Broadway

    Night

    April 6, 2015 at 8:42 am

    #1788936

  • RE: sql 2008r2 performance issues

    guy3145 (4/6/2015)

    when the server is "stuck" the output from your query is:

    total_mem_mb= 30719

    avail_mem_mb=9262

    avail_mem_prc=30.15

    seems ok, right?

    do you have some queries to check I/O latency in sql?

    thanks!

    guy

    Suggest you increase the max mem,...

    April 6, 2015 at 5:02 am

    #1788866

  • RE: Question of the Day for 01 Dec 2006

    patricklambin (4/5/2015)

    Thanks for this easy question because , to help a friend , I had to read both books from Kalen Delaney about the storage engine 2005 and 2012...

    April 6, 2015 at 4:07 am

    #1788861

  • RE: sql 2008r2 performance issues

    guy3145 (4/6/2015)

    the total memory on the server is 30GB.

    the minimum memory is set to 0

    the maximum memory is set to 10GB. we tried to increase the maximum to 16gb that...

    April 6, 2015 at 4:01 am

    #1788860

  • RE: Your Cloud Held Hostage – Could It Happen?

    Steve JP (4/6/2015)

    And when someone does successfully attack one of these places I wonder how many companies will get screwed when they finally read the T&Cs with a lawyer?

    I don't...

    April 6, 2015 at 3:41 am

    #1788859

  • RE: How to eliminate OR condition

    koti.raavi (4/5/2015)

    Hi Everyone,

    Please see below query

    Select ID, ID1,Name, Cname from Customer where ID =(@IDSearch) or ID1 =(@Idsearch)

    When i run above query took around 3 mins, i...

    April 6, 2015 at 3:36 am

    #1788858

  • RE: Query to select date range from two table with same date range

    Quick question, can you post the DDL (create table) code and the sample data as an insert statement? The problem is elementary but unfortunately I don't have time to prepare...

    April 6, 2015 at 3:11 am

    #1788854

  • RE: Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied

    rhythmk (4/6/2015)

    Eirikur Eiriksson (4/6/2015)

    rhythmk (4/6/2015)

    Hi All,

    I am getting strange error mentioned below while executing my package.

    Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied

    I am using SSIS...

    April 6, 2015 at 3:09 am

    #1788853

  • RE: JOIN Tables

    Quick solution, elementary case statement!

    😎

    Note: it took about 5 min to prepare the DDL and the consumable data, less than a minute to write the actual query!

    /* In a safe...

    April 6, 2015 at 3:05 am

    #1788852

  • RE: update from oracle db

    newbieuser (4/5/2015)

    Hi friends,

    Currently, we have SQL Server 2005 database linked to Oracle database (ANSI). We are planning on converting Oracle database to Unicode. Our customer has some scripts...

    April 6, 2015 at 2:30 am

    #1788849

  • RE: DBCC CHECKDB - SCript Review and suggestions

    Quick suggestion, why not use Ola Hallengren's SQL Server Integrity Check rather than roll your own?

    😎

    April 6, 2015 at 2:22 am

    #1788848

  • RE: sql 2008r2 performance issues

    guy3145 (4/5/2015)

    Hi

    thank for your answer!

    does all provided data implies high I/O utilization in sql?

    we encounter a lot of sql clients disconnected at some point of the day, it is all...

    April 6, 2015 at 2:19 am

    #1788847

  • RE: Query Hints

    patricklambin (4/6/2015)

    Hi SQL-DBA-01 ,

    it seems that KEEPPLAN is for mainly for queries using many temp tables

    See :

    I found only these links which could be interesting for you.

    Cannot see this as...

    April 6, 2015 at 2:14 am

    #1788846

  • RE: Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied

    rhythmk (4/6/2015)

    Hi All,

    I am getting strange error mentioned below while executing my package.

    Error: ForEach Variable Mapping number 0 to variable "??" cannot be applied

    I am using SSIS 2012.

    I have an...

    April 6, 2015 at 1:18 am

    #1788843

  • RE: How to execute SSIS package when a file is arrived at folder

    vipin_jha123 (4/6/2015)

    Hi ,

    My requirement is to execute SSIS package, when a file is arrived at a D:\MSBI_and_SQL_Guide\Incomings folder,I do not want to start the package manually .

    It is not sure...

    April 6, 2015 at 12:56 am

    #1788842

Viewing 15 posts - 5,761 through 5,775 (of 8,761 total)