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...

  • RE: Extended Properties Introduction

    Great article Adam.

  • 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...

  • 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...

  • 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. ...

  • 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...

  • 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...

  • 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"...

  • 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...

  • 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...

  • 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...

  • 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...

  • RE: Under Appreciated Features

    Thanks Wayne. I missed it.

  • 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...

  • 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,...

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