Forum Replies Created

Viewing 15 posts - 5,086 through 5,100 (of 13,460 total)

  • RE: Trace not grabbing database info

    i scripted out your trace, and ran it on my dev server(changing the path to the trace file only)

    i certainly see trace data, but i'm confused about what you say...

    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!

    August 2, 2012 at 7:55 am

    #1520841

  • RE: Can you prent a DBA from viewing the data ?

    DBA328 (8/2/2012)

    Oracle has a SYSOPER privilege allows opration such as:

    instance startup,mount & database open;

    alter database backup archive log and restore

    This privilege allows the user to perform basic operational tasks without...

    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!

    August 2, 2012 at 7:09 am

    #1520797

  • RE: Receive Data from Oracle Internet Directory

    I googled "SQL server linked server to "Oracle Internet Directory" " with no luck at all;

    how often does the data change in the "Oracle Internet Directory"? is it something...

    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!

    August 2, 2012 at 6:59 am

    #1520784

  • RE: Can you prent a DBA from viewing the data ?

    SQLKnowItAll (8/2/2012)

    Imagine telling someone that they are responsible for guarding what is in a room, but the room is locked and they don't have the key. When someone...

    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!

    August 2, 2012 at 6:28 am

    #1520758

  • RE: MS SQL 2012 Disadvantages.

    i would definitely recommend going to 2012, and not recommend 2008, or even 2008R2. just because YOU might not have experience in 2012 does not mean you should not recommend...

    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!

    August 2, 2012 at 6:11 am

    #1520750

  • RE: How to display current week as 0 for each year

    so close...we have a table now, and some expected results....but you provided screenshots of data.

    i cannot copy paste those screenshots into SSMS to get the sample data.

    I'm looking for commands...

    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!

    August 2, 2012 at 5:46 am

    #1520744

  • RE: Please Provide Me with Best Solution

    a quick google search of "FDIC insured banks" gives me a starting point like Gail suggested:

    http://www2.fdic.gov/idasp/

    7200+ institutions on the search page , all part of a downloadable csv file.

    you'd...

    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!

    August 1, 2012 at 3:23 pm

    #1520557

  • RE: Is there an joiner much like the 8kSplitter?

    andersg98 (8/1/2012)

    Rather than using an optimizer hint why not just change the table variable to a temp table and let the optimizer do its thing.

    mostly because a function can only...

    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!

    August 1, 2012 at 2:57 pm

    #1520537

  • RE: Update sortorder column to +1

    i think it's simply like this:

    ...ORDER BY ISNULL(SortOrder,2)

    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!

    August 1, 2012 at 2:47 pm

    #1520531

  • RE: Variables Display Gone

    if you think the variables popup might be showing up outside of the desktop space(like when you switch from dual monitor to single, and stuff is outside of scope)

    a lot...

    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!

    August 1, 2012 at 1:15 pm

    #1520491

  • RE: Is there an joiner much like the 8kSplitter?

    well , answering my own question as to why performance sux:

    the plan has nested loop for the inner join, i think based on the Estimated # of rows being =...

    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!

    August 1, 2012 at 11:51 am

    #1520440

  • RE: Is there an joiner much like the 8kSplitter?

    OK the examples so far are kind of specific to the data at hand, and not as generic as I was thinking a Joiner function would be.

    i was playing...

    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!

    August 1, 2012 at 11:39 am

    #1520436

  • RE: Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)

    the jet driver would already be on a normal server, but only works from 32 bit installations, ie SQL 2005;

    if you are on a 64 bit SQL server, you need...

    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!

    August 1, 2012 at 8:44 am

    #1520325

  • RE: How to display current week as 0 for each year

    84gopi (8/1/2012)

    Hi,

    I have merchandise week table in my package which contains week values wk1,wk2,wk3.....upto wk53 per year.

    So using this i need to display current week as 0, for any season...

    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!

    August 1, 2012 at 7:41 am

    #1520270

  • RE: How to display current week as 0 for each year

    84gopi (8/1/2012)

    Hi,

    PFA doc of my report requirement.

    Thanks

    Gopi

    good, you are one third of the way there!

    1. CREATE TABLE stuff: missing...

    2. INSERT INTO stuff...missing.

    3. xpected Output...attached.

    a word doc or screenshots is not...

    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!

    August 1, 2012 at 7:30 am

    #1520251

Viewing 15 posts - 5,086 through 5,100 (of 13,460 total)