Forum Replies Created

Viewing 15 posts - 4,696 through 4,710 (of 7,502 total)

  • RE: Half a Million

    Did anyone notice SSC crossed the 800000 members some time ago ?

    Good job guys 😎

    July 18, 2008 at 6:19 am

    #844963

  • RE: query taking too much time

    GilaMonster (7/18/2008)

    My favorite was a java-based messaging app that passed all string literals as N'... despite defining the table with varchar columns.

    Net result, index scan of around a million rows...

    July 18, 2008 at 5:48 am

    #844942

  • RE: ALTER SYS SP in SS2K5

    there is one thing I can say about modifying system stored procedures:

    it is a big nono[/b]

    If you do it, sooner or later, you're going to pay for it.

    You just...

    July 18, 2008 at 5:17 am

    #844918

  • RE: query taking too much time

    GilaMonster (7/18/2008)

    ALZDBA (7/18/2008)

    We have recently had an issue where the same query on an equal table

    one using nvarchar, the other using varchar. (indexes same indexes on both objects)

    Implicit conversion...

    July 18, 2008 at 3:17 am

    #844864

  • RE: xp_cmdshell

    ZA_Crafty (7/18/2008)

    Well, this will go into a sql job. The reason I have it as tsql, is so that the file name can be dynamic.

    the idea is to email a...

    July 18, 2008 at 1:35 am

    #844834

  • RE: query taking too much time

    May I just add to avoid any N-typed datatype.

    If you don't actualy need it, use varchar in stead of nvarchar.

    We have recently had an issue where the same query on...

    July 18, 2008 at 1:20 am

    #844827

  • RE: query taking too much time

    - 200mb for sqlserver isn't that much.

    - How much RAM do you have on your PC ?

    - Post the tables DDL (create statement, triggers, indexes,..)

    - source : 25000 rows...

    July 18, 2008 at 12:30 am

    #844808

  • RE: xp_cmdshell

    you may be better off putting this into a sqlagent job, owned by sa.

    This avoids opening up xp_cmdshell for everybody :sick:

    If you still encist on having this in tsql, put...

    July 18, 2008 at 12:25 am

    #844805

  • RE: Performance Information using T-SQL

    Indeed. The bug is known for a while now.

    It would be nice if MS fixed that at least for the new downloads !

    July 18, 2008 at 12:17 am

    #844802

  • RE: Building a Distributed Service Broker Application

    -what version of sql2008 are you using ?

    -Did you check with sql2008 bol ?

    - did you have a look at the SQL2008.Service_Broker.Samples.zip (codeplex) ?

    - did you enable SSB for sql...

    July 17, 2008 at 2:25 pm

    #844662

  • RE: SQL Service stopping at a particular time

    chandramohann (7/17/2008)

    Yes the service is getting stopped. And the autorestart option is enabled. But even though the server is not getting auto started once it is stopped. We have to...

    July 17, 2008 at 12:03 pm

    #844574

  • RE: How to Query when SQL Server 2005 SQL sql authenticated account will expire

    - I don't know if you should put this in your SQLServer engine :unsure:

    - I think at SSC you'll find a clr module that queries AD to get expiration dates....

    July 17, 2008 at 11:58 am

    #844571

  • RE: Unable to remove primary key

    Can you post :

    - the tables create statement (ddl)

    - the partition function ddl statement

    - the partition scheme ddl statement

    July 17, 2008 at 11:42 am

    #844565

  • RE: Deleting data in tables

    - with the least overhead you could generate and execute truncate statements for every table. (truncate will only work if there are no FKs pointing to the table)

    - or you...

    July 17, 2008 at 11:34 am

    #844554

  • RE: Monthly SQL Crashes

    VD (7/16/2008)

    to SQLGuru,

    can you please provide more info about the iLO driver bug? We've recently had issues with an HP box restarting without ANY errors in any of the...

    July 17, 2008 at 1:28 am

    #844187

Viewing 15 posts - 4,696 through 4,710 (of 7,502 total)