Forum Replies Created

Viewing 15 posts - 2,116 through 2,130 (of 2,862 total)

  • RE: Are the posted questions getting worse?

    SQLRNNR (2/2/2012)

    GilaMonster (2/2/2012)

    Anyone interested in proof-reading an article on bulk-logged recovery and minimally logged operations? It's titled as an introductory article, but I read the log and might end up...

    February 2, 2012 at 6:00 pm

    #1442166

  • RE: Are the posted questions getting worse?

    Evil Kraig F (2/2/2012)

    Revenant (2/2/2012)

    jcrawf02 (2/2/2012)

    Is it a character flaw that every time I ask for help and someone tells me that it will take too long and be too...

    February 2, 2012 at 3:49 pm

    #1442135

  • RE: Are the posted questions getting worse?

    jcrawf02 (2/2/2012)

    Is it a character flaw that every time I ask for help and someone tells me that it will take too long and be too hard, to get mad...

    February 2, 2012 at 3:16 pm

    #1442118

  • RE: How to manage design time connection strings?

    That is a prefectly valid question.

    Yes, connection strings in the database work only for run time.

    If you need to work with connections during design time, you will be probably better...

    February 2, 2012 at 12:17 pm

    #1442006

  • RE: How to manage design time connection strings?

    We have a small ETLConfig database on the local server. This database contains all connection strings in a small table.

    This way you have the same connection for any deployment, and...

    February 2, 2012 at 10:09 am

    #1441951

  • RE: INSERT OUTPUT

    SQL Kiwi (2/2/2012)

    cengland0 (2/2/2012)

    Except, and correct me if I'm wrong, SQL Server Audit is only available in 2008 but the OUTPUT clause is available in 2005 and 2008.

    That's right, and...

    February 2, 2012 at 10:04 am

    #1441947

  • RE: INSERT OUTPUT

    Nice and simple -- thanks, Steve!

    February 2, 2012 at 9:00 am

    #1441895

  • RE: Create a Unique ID for Rows

    No, that will not do -- if you read the original post, it calls for a UNIQUEIDENTIFIER, not for an INT.

    You have to cast is as a UNIQUEIDENTIFIER with default...

    February 1, 2012 at 4:31 pm

    #1441491

  • RE: SET option hierarchy

    KWymore (2/1/2012)

    Hopefully this experience has not dissuaded the QoTD author from submitting further questions.

    +1

    Sandip, I hope to see your next one soon.

    February 1, 2012 at 4:02 pm

    #1441477

  • RE: Are the posted questions getting worse?

    Jack Corbett (2/1/2012)

    Evil Kraig F (1/31/2012)

    A robot DBA may not injure data or, through inaction, allow data to come to harm.

    A robot DBA must obey the...

    February 1, 2012 at 9:52 am

    #1441305

  • RE: SET option hierarchy

    L' Eomot Inversé (2/1/2012)

    Narud (2/1/2012)

    According to this reference http://msdn.microsoft.com/en-us/library/ms191203.aspx, there are only 3 rules in hierarchy of options. I would like to know from where comes option no. 4?

    Option no....

    February 1, 2012 at 9:42 am

    #1441298

  • RE: Strings and Defaults

    L' Eomot Inversé (1/26/2012)

    nice question.

    Evey time I recall that default varchar length is 1 for declare but 30 for cast I feel sick and resolve never to use varchar without...

    February 1, 2012 at 8:24 am

    #1441237

  • RE: SET option hierarchy

    Interesting question -- thanks!

    February 1, 2012 at 8:22 am

    #1441236

  • RE: Little Help With Select Statement.

    sys.sql_logins contains only SQL Server logins, not the Windows-authenticated logins.

    Do you need info form that view? Dates of creation and modification are in sys.database_principals.

    January 31, 2012 at 9:44 am

    #1440760

  • RE: Computed Columns 1

    A simple yer or no, and I got it wrong... Thanks, Bitbucket -- a good lesson!

    January 31, 2012 at 9:28 am

    #1440746

Viewing 15 posts - 2,116 through 2,130 (of 2,862 total)