Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 13,460 total)

  • RE: Help with contents of a script

    it's effectively a script which performs the same operations as this GUI menu "Shrink Files" in SSMS performs...the followup screen lets you select either the database file(s) or the log...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 12:18 pm

    #1629242

  • RE: SQL Developer Edition Question

    no, but the features differences all really have to do with a lot of advanced things, that would never come up in basic development; they come up more along...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 10:30 am

    #1629207

  • RE: xp_readerrorlog

    xpreaderrorlog doesn't have a column dedicated to the database name, so no, there's no way to filter based on a LIKE statement directly.

    there's a pretty good recap of the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 10:06 am

    #1629199

  • RE: is it possible to have Single instance(name or SID) on multiple database?

    nikunj_lodhi (7/2/2013)

    Hi Folks,

    I wanted to know that can we have a single instance on two different databases?

    I am till now aware that it is a one to one relation(correct me...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 6:19 am

    #1629024

  • RE: Write a SQL statement that will return all the Sales Orders for the Salespersons’ with the name starting with ‘John’.

    the format of your question screams "copy and paste" from your homework;

    That's a little frowned upon here, so lets do it right:

    can you show us the query you've created so...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 6:11 am

    #1629017

  • RE: How to retrieve the Binary Image from database with out affecting database performance

    well, if you are in SQL2005, you cannot take advantage of the FileStream data type.

    In that case, best practice depends on the size of the files you want to store....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 6:08 am

    #1629016

  • RE: Can you please help me??

    that C_recId is probably a varchar?

    adding a format to the order by might help instead:

    select *

    from customer

    where C_recid in (50200,50194,50430,50191,1)

    order by RIGHT('00000' + C_recid ,5) DESC

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 2, 2013 at 5:11 am

    #1628988

  • RE: compare SQL syntax but need the total and %???

    try this to avoid integer division:

    if sql divides two integers , it returns an integer datatype, which can get rounded or truncated.

    SELECT ((count(item_keya) * 1.0 / count(snetworkname) * 1.0) *...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 2:19 pm

    #1628841

  • RE: Tables Refresh Solution

    SQL_TASK (7/1/2013)

    I have 2 database tables.

    1) From Production

    2) From Dev.

    The task is to move the data refresh from Production to Dev Server. But the table schema itself is changed is...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 12:40 pm

    #1628818

  • RE: Update Table with get-date

    i'm guessing since you are using powershell to substitute values, the date parameter must be in single quotes;

    also, it looks like $Date_Import would get substituted too, which makes an invalid...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 9:30 am

    #1628757

  • RE: Import multiple files into multiple tables

    ouch, the custom delimiters finally soaked in; that' certainly adds tot eh complexity, since i'd normally BULK INSERT something custom delimtied...but you need the tables built on the fly,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 8:56 am

    #1628739

  • RE: Import multiple files into multiple tables

    Lucas the plain set @provstr = 'Text' was what is working for me; the other one was one that i was testing, and not applicable here.

    for the error you...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 8:27 am

    #1628729

  • RE: PDF virus threat

    NJDave (7/1/2013)

    Hello

    An application that sits outside of our network will allow the user to store pdf files on the database.

    The concern is that these pdf files could contain viruses.

    The vendor...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 7:17 am

    #1628695

  • RE: Import multiple files into multiple tables

    Lucas the strategy depends on the details.

    I'm not anti -SSIS, but if it can be done via TSQL, then it can be done a lot faster.

    if the destination tables...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 6:50 am

    #1628686

  • RE: CDC Growth and poor performance issues

    ok, if you cannot remove records due to your audit requirements, i think it comes down to query tuning;

    can you grab some execution plans, and see if any of the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    July 1, 2013 at 6:20 am

    #1628674

Viewing 15 posts - 3,166 through 3,180 (of 13,460 total)