Forum Replies Created

Viewing 15 posts - 2,626 through 2,640 (of 14,953 total)

  • RE: NOSQL is Not about SQL!

    It's just another OODBMS (object oriented database management system) from what I can tell.

    So, yes, it will be faster in some things, and much, much slower on others.

    Usually, OODBMS engines...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: 3rd party tool comparison

    RedGate can also use a GUI, not just command line.

    I haven't used the other ones. I've used RedGate and ApexSQL (not on your list, but they have tools for...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: File Locations and SANs

    I'm accustomed to SANs with multiple fiber channels, so can't speak to that aspect of it.

    I've been using servers where both data and logs are on the SAN for years,...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Evil Kraig F (12/14/2011)


    I must be crazy, I haven't lost track of the thread and I'm pretty sure I know the story Gus is talking about! I think I...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Persisted computed columns not being used correctly by SQL

    Let me guess, the problem was the implicit conversions being short-circuited. That'll add so much to the cost that the optimizer was bypassing it. Right?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: How to control the checkpoint?

    ricardo_chicas (12/14/2011)


    the checkpoint spid is blocking all the other sessions on that databse, I can do anything on that database, I know this is not isolated, internet is plagued with...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: How to control the checkpoint?

    I'm not sure how a checkpoint "blocks everybody else". Can you clarify?

    A checkpoint is simply SQL Server writing data out of RAM onto the hard drive (essentially). Are...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    L' Eomot Inversรฉ (12/14/2011)


    GSquared (12/14/2011)


    Well, per the French scholars Goscinny and Uderzo, it was actually the ancient Gauls who used this method of settling certain disputes. Usually disputes over...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Anybody Build Workflows in Their SQL Server?

    It shouldn't be hard to do. I've built such systems (one pretty much managed a whole small business on its own, and did a better job of it than...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Save data from XLS,XLSX,CSV files to sqlserver2005

    If the DBAs don't allow bulk insert or ad hoc queries, which is a common security measure, then SSIS is your best bet.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (12/14/2011)


    GSquared (12/14/2011)


    Well, per the French scholars Goscinny and Uderzo, it was actually the ancient Gauls who used this method of settling certain disputes. Usually disputes over musical...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/14/2011)


    Ninja's_RGR'us (12/14/2011)


    Pork chops is a projectile thrown in the face of someone who uses cursors, rbar and other forms of bad sql.

    Kind of a more efficient and longer distance...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Trim a string

    SQL Kiwi (12/14/2011)


    GSquared (12/14/2011)


    But do keep in mind that DataLength on Unicode strings can require math on the CharIndex result, or you'll get the wrong position. Len vs DataLength...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Divine Flame (12/14/2011)


    Everybody is going insane here ๐Ÿ˜€ Reading the posts of this thread is fun & crazy ๐Ÿ˜Ž

    "Going"?

    "Going"?

    I'd have to drive a LONG distance in reverse to arrive at...

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • RE: Are the posted questions getting worse?

    Roy Ernest (12/14/2011)


    ... I think I am the only sane person in the THREAD. ๐Ÿ˜€ ...

    Yeah, but we're working on fixing that as fast as we can ....

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 15 posts - 2,626 through 2,640 (of 14,953 total)