Forum Replies Created

Viewing 15 posts - 331 through 345 (of 859 total)

  • RE: using dynamic Sql with views

    a suggestion i have seen else where on the forums is to use a view similar to the one below:

    CREATE VIEW blah

    AS

    SELECT 'db1' AS DBName, * FROM db1..tbl1

    UNION ALL

    SELECT 'db2',...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 14, 2012 at 12:31 pm

    #1487322

  • RE: Create database DDL VS creating a database in SSMS

    Perry Whittle (5/14/2012)

    capn.hector (5/14/2012)

    we fixed it by detaching the database with sp_detach_db rename the log file then sp_attach_single_file_db. it worked and we can now shrink the file.

    Bad idea generally.

    A...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 14, 2012 at 12:04 pm

    #1487301

  • RE: Create database DDL VS creating a database in SSMS

    the VLF's being used was what tipped us to the script being used and having 2 VLF's at the size of Initial / 2. thanks for the article by...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 14, 2012 at 9:52 am

    #1487216

  • RE: Today's Random Word!

    Revenant (5/14/2012)

    crookj (5/14/2012)

    Brandie Tarvin (5/14/2012)

    Daniel Bowlin (5/14/2012)

    Regional

    Sectional

    Provincial

    bumpkin

    Hillbilly

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 14, 2012 at 9:32 am

    #1487198

  • RE: Create database DDL VS creating a database in SSMS

    opc.three (5/11/2012)

    capn.hector (5/11/2012)

    opc.three (5/11/2012)

    Could be. I did not think SHRINKFILE was sunject to the 'initial size' issue though.

    i believe only when used with CREATE DATABASE. all the DB's we...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 14, 2012 at 9:25 am

    #1487189

  • RE: Create database DDL VS creating a database in SSMS

    opc.three (5/11/2012)

    Could be. I did not think SHRINKFILE was sunject to the 'initial size' issue though.

    i believe only when used with CREATE DATABASE. all the DB's we created with...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 11, 2012 at 6:07 pm

    #1486679

  • RE: Create database DDL VS creating a database in SSMS

    opc.three (5/11/2012)

    OK, I am with you now. I would run a Trace to see what SSMS is doing. My guess is SSMS does a SHRINKFILE w/ NOTRUNCATE first to bring...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 11, 2012 at 5:49 pm

    #1486673

  • RE: Create database DDL VS creating a database in SSMS

    there were other options set. the developer scripted out the dev database and ran the script on the production server. since we dont need it as large as...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 11, 2012 at 5:00 pm

    #1486671

  • RE: Find out why a SP failed.

    Gazareth (5/8/2012)

    Queue, not cue, surely?

    (Sorry :-D)

    lol had pool cue on my brain when i was posting that.

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 11, 2012 at 3:44 pm

    #1486658

  • RE: Today's Random Word!

    SQLRNNR (5/10/2012)

    Daniel Bowlin (5/10/2012)

    wipe out

    Big red balls

    Blue balls

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 10, 2012 at 10:14 am

    #1485826

  • RE: Are the posted questions getting worse?

    Lynn Pettis (5/9/2012)

    riya_dave (5/9/2012)

    hi

    i have cursor in my sp ,so i tried to remove it with while loop in order to enhance performance,but it takes more time than cursor.

    I am...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 9, 2012 at 12:09 pm

    #1485239

  • RE: Find out why a SP failed.

    Grant Fritchey (5/8/2012)

    capn.hector (5/8/2012)

    thanks to the suggestion of Grant it got me thinking about the where clause. i was helping out the operator about an hour after the...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 8, 2012 at 6:21 am

    #1484464

  • RE: Find out why a SP failed.

    thanks to the suggestion of Grant it got me thinking about the where clause. i was helping out the operator about an hour after the "Error" occured since...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 8, 2012 at 6:08 am

    #1484452

  • RE: Need help with my date logic function

    can you post the output you want from the 4 queries. when i run them i get

    Start_Date ...

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 7, 2012 at 4:00 pm

    #1484265

  • RE: Today's Random Word!

    L' Eomot Inversé (5/7/2012)

    Revenant (5/7/2012)

    Daniel Bowlin (5/7/2012)

    Gorgon

    zola

    Émile

    emilio estevez

    For faster help in answering any problems Please read How to post data/code on a forum to get the best help - Jeff Moden[/url] for the best way to ask your question.

    For performance Issues see how we like them posted here: How to Post Performance Problems - Gail Shaw[/url]

    Need to Split some strings? Jeff Moden's DelimitedSplit8K[/url]
    Jeff Moden's Cross tab and Pivots Part 1[/url]
    Jeff Moden's Cross tab and Pivots Part 2[/url]

    May 7, 2012 at 3:52 pm

    #1484261

Viewing 15 posts - 331 through 345 (of 859 total)