Forum Replies Created

Viewing 15 posts - 5,356 through 5,370 (of 6,022 total)

  • RE: search and replace a string in all user tables’ data in all databases

    I'm trying to think of a situation where I would want to replace a string value across X varchar columns in X tables and X databases. This would imply that...

    November 10, 2011 at 6:57 am

    #1405718

  • RE: License By Core

    IceDread (11/9/2011)

    ...As a side note I also prefer how Oracle handles null over sql server...

    Well, unlike SQL Server, Sybase, DB2, etc.; Oracle's implementation of NULL equality doesn't conform to ANSI...

    November 9, 2011 at 12:56 pm

    #1405434

  • RE: unexplained Performance difference in queries between UAT/Live database

    Claudie36 (11/8/2011)

    MY 2nd user experiencing response problems came back to me and it looks like it's the one table causing problems. My 2nd user also has a 'group by' on...

    November 9, 2011 at 7:19 am

    #1405156

  • RE: License By Core

    IceDread (11/8/2011)

    The only advantage ms sql server has over oracle is it's price. Some would perhaps make an argument for the user interface as well. If ms sql server were...

    November 9, 2011 at 6:47 am

    #1405123

  • RE: Going Green in Software Development

    We've talked about CPU and power usage at the server and network infrastructure level, but the bulk majority of utilization is at the client level. Stuff like Flash, Java, Silverlight,...

    November 8, 2011 at 7:19 am

    #1404518

  • RE: Going Green in Software Development

    JJ B (11/7/2011)

    If you are interested in monitoring your electric usage, you may want to check out the following, The Energy Detective (TED) which I installed in my house. ...

    November 7, 2011 at 3:38 pm

    #1404199

  • RE: Going Green in Software Development

    P Jones (11/7/2011)

    Another great argument against the use of cursors - thanks!

    Indeed, rowset cursors are destroying the planet and a threat to mankind. It's time we stopped beating around the...

    November 7, 2011 at 7:31 am

    #1403951

  • RE: Laptop Boy Scouts

    One technique the police could use to catch these guys is to get hold of a bunch of cheap non-functional laptops, install them with a GPS tracking device, and then...

    November 3, 2011 at 7:51 am

    #1402650

  • RE: Identifying who took a database offline

    Don Bricker - Illinois (10/31/2011)

    We have a SQL Server 2008 instance in which someone took a database offline couple of weeks ago. I have identified the SPID from the Log...

    November 2, 2011 at 9:41 am

    #1402229

  • RE: Stored procedure performance

    dm_tapas (11/1/2011)

    The below stored procedure is taking around 1 hours to execute. but it should not take this much time.

    Can some body tune this and tell me...

    November 2, 2011 at 9:29 am

    #1402224

  • RE: Where are the good Senior Level DBA's?

    randy.worrell (11/1/2011)

    JamesMorrison (11/1/2011)

    Why are people complaining about the GUI for SQL Server? At least we have a GUI that actually works.

    Oracle DBAs are still complaining (for my entire 11 year...

    November 1, 2011 at 12:46 pm

    #1401793

  • RE: index on big table

    GilaMonster (11/1/2011)

    Eric M Russell (11/1/2011)

    If the clustered index is on a non-unique key, then SQL Server will still use the default 8 byte rowid.

    The 8-byte RID is only used in...

    November 1, 2011 at 9:58 am

    #1401717

  • RE: index on big table

    dva2007 (11/1/2011)

    thanks you. that makes more sense as it is not going to take more space then default ROWID (8 bytes).

    If the clustered index is on a non-unique key, then...

    November 1, 2011 at 9:28 am

    #1401699

  • RE: index on big table

    dva2007 (11/1/2011)

    if there are more records with the same date in the table, can i create clustered index on that field?

    We have 5 years records and the same day have...

    November 1, 2011 at 9:06 am

    #1401683

  • RE: Where are the good Senior Level DBA's?

    As for comparing the cost of hiring a fulltime staff DBA versus the cost of purchasing higher end hardware, the DBA has more value if he/she has expertise in other...

    November 1, 2011 at 8:48 am

    #1401669

Viewing 15 posts - 5,356 through 5,370 (of 6,022 total)