Forum Replies Created

Viewing 15 posts - 1,126 through 1,140 (of 3,061 total)

  • RE: SQL policy based management

    THE-FHA (3/14/2011)

    I have an ebook thats having only the basics of SQL policy based management and i need another book that can teach me advanced technics on this topic as...

    March 14, 2011 at 8:31 am

    #1298359

  • RE: calculating dates

    timotech (3/14/2011)

    Hi all i don't know what i'm doing wrong, i have this sql to calculate a particular date:

    SELECT DATEADD(dd, - 365, @BeginDate) AS Expr1, @BeginDate...

    March 14, 2011 at 7:58 am

    #1298327

  • RE: Cursor use in Oracle

    Jeff Moden (10/10/2009)

    PaulB-TheOneAndOnly (9/22/2009)

    pandeharsh (9/12/2009)

    Also,I read here that,we should avoid cursor as much as possible.

    This is not correct. Is like saying you should avoid surgery as much as possible -...

    March 11, 2011 at 2:39 pm

    #1297894

  • RE: Tuning Locks

    sjimmo (3/11/2011)

    I understand that when the number of locks obtained is equal to 40% of the total SQL Server memory that it will start throwing 1204 errors.

    What I am...

    March 11, 2011 at 2:23 pm

    #1297886

  • RE: Roles - What level do these belong at in SQL 2008 ?

    sgmunson (3/10/2011)

    As I don't have much background in the security side of SQL Server, I need some guidance on setting up security for a small company with perhaps 10 to...

    March 11, 2011 at 12:51 pm

    #1297858

  • RE: Data integrity during company merger hypothetical?

    Vertigo44 (3/11/2011)

    Vague Hypothetical situation...

    Our company conducts customer registrations and account information,etc,etc right. Our DBMS will have a unique id throughout our system.

    However, what is best practice when/if our company gets...

    March 11, 2011 at 12:17 pm

    #1297846

  • RE: Best practices for sending a database to your client (schema & data)

    LightningFingers (3/11/2011)

    I don't completely understand collations, to be honest. And unfortunately we don't have a DBA where I work to help guides us through things like this.

    It appears like you...

    March 11, 2011 at 12:05 pm

    #1297841

  • RE: Connecting to SQL server: SLOW- IP adress, FAST- name

    Chrissy321 (3/10/2011)

    Do you get similar results when you use the tracert command to both the name and the IP?

    I'm really looking forward to read the answer to this question.

    March 11, 2011 at 11:48 am

    #1297830

  • RE: Custom Date Key???

    DMS11X (3/11/2011)

    I am a complete SQL NooB:crazy:, I am looking to create a custom GETDATE() and use it as a key...

    Format: AL= ACTIVITY LOG

    AL-MMDDYYYY-1

    AL-MMDDYYYY-2

    AL-MMDDYYYY-3

    and so on...

    I need the number 1,2,3......

    March 11, 2011 at 11:21 am

    #1297810

  • RE: Best practices for sending a database to your client (schema & data)

    LightningFingers (3/11/2011)

    One possibility seems to be to create a .bak file for the database. But we've run into issues with collation when moving .bak files between servers that aren't configured...

    March 11, 2011 at 11:14 am

    #1297805

  • RE: Index sort order

    terryshamir (3/11/2011)

    I have tblOrder table with clustered PK on OrderID which is an autoincrementing int field

    This is a foreign key in tblOrderDetails.

    In tblOrderDetails there is an non-clustered index on OrderID...

    March 11, 2011 at 5:59 am

    #1297563

  • RE: TOP 1000 in Oracle

    Vedran Kesegic (3/7/2011)

    Top N question was piece-of-cake, complete beginner's question.

    I'm failing to see the value of this particular post.

    Also, why you have to be rude to the original poster?

    March 10, 2011 at 1:01 pm

    #1297336

  • RE: ERD Tools

    comandant005 (2/23/2011)

    I will be very much grateful if you can help solve this problem of mine.

    David,

    This is homework assignment, you even copy/pasted your instructor instructions about this being an...

    March 9, 2011 at 9:08 am

    #1296583

  • RE: Foreign key question

    Jamesyoung79 (3/8/2011)

    I'm going too see what I can find on ER model and 3NF to see what I can find on it and if you'd care to explain a little...

    March 8, 2011 at 8:11 am

    #1295900

  • RE: Test database

    smknox (3/3/2011)

    I am trying to make a test database for developers and for that purpose made a database with 100 person records whereas the production database has about 40,000 such...

    March 8, 2011 at 8:03 am

    #1295894

Viewing 15 posts - 1,126 through 1,140 (of 3,061 total)