Forum Replies Created

Viewing 15 posts - 5,686 through 5,700 (of 7,164 total)

  • RE: SQL Compilations/sec equals Batch Requests/sec with ad-hoc inserts possibly causing high CPU utilisation

    I am not an expert but figured I would kick off the conversation.

    I want to know the root cause too but I will still say that SQL Server is not...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 1:46 pm

    #1347481

  • RE: ETL/Warehousing & Cross DB Queries

    The only justification I could see for avoiding cross-database calls is to leave the option open to scale out at some point down the line by moving the Staging or...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 12:15 pm

    #1347478

  • RE: Invalid object name '#temptable'.

    I don't have anything concrete in mind as to why it could be happening but I am curious, which statement fails with "table not found", the INSERT INTO or the...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 12:05 pm

    #1347477

  • RE: how to attached mail Send from sql server 2008

    Coolroof (7/1/2011)

    its executing properly but mail is not come and when i execute without attachment parameter i'm geeting mail.

    Any error messages?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 11:57 am

    #1347476

  • RE: Creating CLR Procedures and Assembly in SQL Server using Visual Studio

    Why do you need to create it with UNSAFE? What is it doing that is causing you to require that setting?

    Also, just because its created with UNSAFE does not mean...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 11:57 am

    #1347475

  • RE: debtors outstanding query

    Direct replies here: http://www.sqlservercentral.com/Forums/Topic1135468-391-1.aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 11:55 am

    #1347474

  • RE: Replacing Hierachy Text value with IDs

    Intrepid121 (7/2/2011)

    ....

    What would be the best\ quickest way to achieve this?

    You could attack this using basic string replacement but I would not recommend it.

    The proper way IMO is to do...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 11:52 am

    #1347472

  • RE: Using VSS for data mining

    See section "Data mining by using transportable shadow copies" here:

    http://technet.microsoft.com/en-us/library/ee923636(WS.10).aspx

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 11:03 am

    #1347463

  • RE: how to configure sp_send_cdosysmail in sql server 2008

    Coolroof (7/2/2011)

    pls give me steps for configure sp_send_cdosysmail in sql server 2008.

    Using CDO for mailing is from the SQL 2000 days. Please consider the Database Mail subsystem to send email...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 10:56 am

    #1347462

  • RE: Performace issue when retrieving data from two tables

    Shamshad Ali (7/2/2011)

    ...

    Following is the no. of records in each table./

    select count(*) from users -- 306940

    select COUNT(*) FROM UserProfile -- 173958

    I am running following simple query which is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 10:47 am

    #1347459

  • RE: Increasing CPUs hurts Perf

    as2higpark (7/2/2011)

    Also wanted to add that we are seeing the CPUs (average of all 24) spike to around 50 - 70% sporatically throughout the work day. The spikes generally last...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 8:13 am

    #1347439

  • RE: Help with SQL query

    GilaMonster (7/2/2011)

    opc.three (7/2/2011)

    Bummer. The article is still relevant. Please see the section titled "Recompile". Adding the option to your query will cause it to be more expensive than would otherwise...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 7:55 am

    #1347436

  • RE: Transaction Log

    Lynn Pettis (7/2/2011)

    As far as when the compatibility views will go away, Microsoft doesn't always tell you. I haven't load Denali, so I can't say if they exist there,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 6:39 am

    #1347427

  • RE: Help with SQL query

    rockstar283 (7/1/2011)

    I am currently workin as a TEMP in my company..and only permanent guys can execute a proc 🙁

    Bummer. The article is still relevant. Please see the section titled "Recompile"....

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 2, 2011 at 6:14 am

    #1347426

  • RE: Change Data Type

    Welcome maddoxd. You can change the data type of the BirthDate column without dropping and recreating the table, or even bothering with the Primary Key on EmpID. Something like this...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    July 1, 2011 at 4:30 pm

    #1347371

Viewing 15 posts - 5,686 through 5,700 (of 7,164 total)