Forum Replies Created

Viewing 15 posts - 976 through 990 (of 3,061 total)

  • RE: Data warehouse multiple time dimension

    A version of Koen's solution #1 works fine for us. Date/Time dimension table includes about thirty attributes to help slice and dice the data in different ways.

    June 24, 2011 at 6:10 am

    #1343607

  • RE: Restricting DBA from accessing SQL DB objects

    bhawna.jain (6/24/2011)

    I have already applied cell level encryption. But I don't want DBA to see the definition or modify any object. We are blocking DBA access for the security of...

    June 24, 2011 at 6:00 am

    #1343606

  • RE: Query performance

    vinod.saraswat (6/23/2011)

    I am facing problem in getting the count * from a table.

    The table contains 1526013586 rows. I am querying it for count * with a where condition for specific...

    June 23, 2011 at 6:04 am

    #1342951

  • RE: Normalization

    fourteen, fourteen pages already on this thread!!! :w00t:

    There is an abundant amount of information on the posts of this thread but I'm affraid most people wouldn't read it from start...

    June 23, 2011 at 6:00 am

    #1342942

  • RE: Monitoring SQL Server with Oracle Grid

    GRE (Gethyn Ellis) (6/22/2011)

    I am after people opinions on using Oracle Grid to monitor SQL Server instances, in particular from people who use it or have used it previously.

    Good,Bad,...

    June 23, 2011 at 5:55 am

    #1342941

  • RE: Inventory DB Design

    francissvk (6/20/2011)

    I need a simple table structure to track this and achieve this output. Pls help to design the db in this regard.

    Allow me to show you how to fish...

    June 21, 2011 at 4:35 pm

    #1342171

  • RE: Tricky Select statement

    npeters 86796 (6/21/2011)

    the values 888,123 etc... we have about 100,000 distinct values, so that way will not work.

    Yes, it will work. Try it.

    June 21, 2011 at 4:13 pm

    #1342164

  • RE: PLz help to fix the error

    sravnmaganti (6/21/2011)

    Asked by amedexitt in MS SQL Server

    Tags: 0x80040155, error, failed, package, ssis

    Hi There:

    I'm trying to create a SSIS Package using SQL Business Intelligence and I'm getting this error. Does...

    June 21, 2011 at 4:09 pm

    #1342163

  • RE: Help with formating a QUERY ???

    tp 25072 (6/21/2011)

    I'm kind of trial and error guy. I haven't tried anything.

    Isn't a contradiction to have those two statements together, in the same line?

    June 21, 2011 at 4:03 pm

    #1342162

  • RE: Does sql view a folder path to data file the same as mount point path to data file

    Indianrock (6/20/2011)

    We have several of our database files located on mount points e.g. K:\split_data\cm_data\datafile01.ndf

    If we change our disk environment, removing mount points but have the exact same...

    June 21, 2011 at 5:23 am

    #1341741

  • RE: Help with Normalization

    Compusol (6/20/2011)

    I am trying to normalize a table that I need for a new system I am putting together. What is the best way to normalize this table (since it...

    June 21, 2011 at 5:19 am

    #1341738

  • RE: Oracle empty string ('') is the same as NULL

    tchien69 (6/20/2011)

    PaulB-TheOneAndOnly and BowieRules!: Alright you kids, stop it. You're both right. 🙂

    We stopped eight month ago!!! 😀

    June 20, 2011 at 4:36 pm

    #1341509

  • RE: Measuring DB size

    Sumanta Roy (6/20/2011)

    Is there any way we can measure how much is the database growth in last one hour if the database size is not captured before one hour?

    No that...

    June 20, 2011 at 5:29 am

    #1341068

  • RE: Better safe than sorry: WINDOWS UPDATE MAY CAUSE SQL 2008 R2 PROBLEM

    Raymond van Laake (6/20/2011)

    I'm not trying to start a panic, but we have a problem on our SQL Server 2008 R2 64bit SP1, and the specialist from our hosting company...

    June 20, 2011 at 5:20 am

    #1341058

  • RE: How to Select the columns in a table leaving behind just one

    ash0550 (6/17/2011)

    Say IN a table if I want to display 5 out of 6 columns can I do that without specifying IN manual order with a simple syntax

    Is it...

    June 18, 2011 at 5:57 pm

    #1340835

Viewing 15 posts - 976 through 990 (of 3,061 total)