Forum Replies Created

Viewing 15 posts - 196 through 210 (of 820 total)

  • RE: Extended Properties Introduction

    So here is a couple of questions.

    Let's say that there is a tool that lets you:

    Log into a SQL server.

    Update the description extended properties on your tables and columns.

    Lets you...

    ATBCharles Kincaid

  • RE: Extended Properties Introduction

    Great article Adam.

    ATBCharles Kincaid

  • RE: Understanding Indexes

    zebulonpi (2/15/2011)


    Also, when publishing something intended as educational, AND being reviewed by your peers, you WILL get criticism. Take it as constructive, learn from it, and become better.

    Which was exactly...

    ATBCharles Kincaid

  • RE: Understanding Indexes

    First I think that the intent, target, and scope are great. Yes, there is room for revision.

    Nice effort, Ron. Everybody gets the blowtorch to the backside for everything...

    ATBCharles Kincaid

  • RE: Life Without Keyboards

    Please take into consideration those of us with chronic sinus conditions. I remember as an operator being seated in front of the console and having a large attack. ...

    ATBCharles Kincaid

  • RE: Introduction to Indexes: Part 3 – The nonclustered index

    GilaMonster (1/21/2011)


    A table can be a heap and have a pk. It can have a clustered index without a pk. Primary key != clustered index.

    Here is a point that is...

    ATBCharles Kincaid

  • RE: Disk Is Cheap! ORLY?

    Points made by Thomas-282729 and others are valid for consideration. You have to apply all of these through a filter of sense. The other point that was...

    ATBCharles Kincaid

  • RE: Disk Is Cheap! ORLY?

    Wonderful article. Good job. A couple of points though.

    For the online kind of storage you are right, and right on the mark. Still the "disk is cheep"...

    ATBCharles Kincaid

  • RE: Disk Is Cheap! ORLY?

    dforck (12/31/2010)


    I find it amusing that he bothered to mention using char instead of varchar, but never mentioned that using nvarchar, or nchar, effectively doubles how much space is being...

    ATBCharles Kincaid

  • RE: Strike Force

    jcrawf02 (12/28/2010)


    I know we all know we're computer geeks, but c'mon, this is just harsh:

    "and then go home and get on with out lives"

    maybe somewhere there's ONE of us who...

    ATBCharles Kincaid

  • RE: Merry Christmas 2010

    A friend of mine had 5 in the house and 32 in the yards. He also had chickens, geese, a swan, and pot bellied pigs. We started calling...

    ATBCharles Kincaid

  • RE: Merry Christmas 2010

    "I'm Steve Jones ... and this is a cat!" ROFLMAO! I have one now but had two for quite a while. They will make one laugh when...

    ATBCharles Kincaid

  • RE: Under Appreciated Features

    Thanks Wayne. I missed it.

    ATBCharles Kincaid

  • RE: Under Appreciated Features

    Running a query across multiple servers in a group.

    Filtered Indexes. Makes up for a crappy design that I inheirited and can't (yet) rewrite.

    Intellisense. I plan on adding the...

    ATBCharles Kincaid

  • RE: Date and Time dimension creation and population T-SQL

    Here is how to drop the time from a date/time. I use GetDate() in the example but you can use a column just as well.

    SELECT DATEADD(DAY, 0, DATEDIFF(DAY, 0,...

    ATBCharles Kincaid

Viewing 15 posts - 196 through 210 (of 820 total)