Forum Replies Created

Viewing 15 posts - 2,791 through 2,805 (of 5,841 total)

  • RE: UDF Performance When Used As A "Macro"

    Todd Young-359443 (10/15/2012)

    I was able to work at home this weekend and found the answer. When calling

    at UDF that does not access any database table and is used more...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 16, 2012 at 7:24 am

    #1549547

  • RE: Explicit Transaction to improve performance?

    If the delete is CAUSING blocking (are you using sp_whoisactive to watch what is going on?), I would look at the following:

    1) no index on what you are using for...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 16, 2012 at 7:21 am

    #1549542

  • RE: Small database with 1 million users

    Sqlsavy (10/15/2012)

    Hi all,

    We've a small database (1 GB) and SQL 2005 server is clustered one. Now Business is forecasting that database will be accessed by million users by early...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 16, 2012 at 7:17 am

    #1549537

  • RE: Isolation Level and LOCK_TIMEOUT

    Thanks. I don't have all of the details at the moment about what are the exact objects and type of locks that are blocking, I do see that ALTER INDEX...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 2:28 pm

    #1545801

  • RE: Best way to effienctly store hugh amounts of data

    bteraberry (10/4/2012)

    TheSQLGuru (10/4/2012)

    2) Having a table per object type sold is unworkable - how many different types of objects does Amazon sell??

    So if you're selling products you have to design...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 2:18 pm

    #1545792

  • RE: Isolation Level and LOCK_TIMEOUT

    Lexa (10/4/2012)

    TheSQLGuru (10/4/2012)

    Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

    Also, what tool/mechanism did you use to determine that this sproc was...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 10:17 am

    #1545661

  • RE: Temp table for Performance Impact

    >>Working with big tables in DM environments, it's almost always worth putting an index or two on temp tables. Anything over 10k rows and it's likely to make a measurable...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 9:38 am

    #1545628

  • RE: Best way to effienctly store hugh amounts of data

    aaron.reese (10/3/2012)

    out of interest then; if I was selling books (ISBN, Author, Pages), wine (bottle size, ABV,Vinyard,grape,acidity) and shirts (material,collar type, sleeve length), how would you recommend storing the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 8:03 am

    #1545553

  • RE: Isolation Level and LOCK_TIMEOUT

    Please show the code for the sproc. Does the sproc reference any UDFs by any chance?

    Also, what tool/mechanism did you use to determine that this sproc was doing the...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 7:50 am

    #1545542

  • RE: Temp table for Performance Impact

    1) What is the point of this (isn't PRIMARY KEY sufficient by itself and the UNIQUE redundant?):

    PRIMARY KEY (ID),

    UNIQUE (ID))

    2) I can probably count on 2...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 4, 2012 at 7:47 am

    #1545538

  • RE: Reduce INITIAL SIZE of TEMPDB

    Beware shrinking tempdb: http://support.microsoft.com/kb/307487

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 3, 2012 at 8:16 am

    #1544945

  • RE: Best way to effienctly store hugh amounts of data

    Maddave (10/3/2012)

    Thanks guys, all very interesting stuff. I'm getting more in to how this application is implemented and it's becoming scary. As Sean Lange mentioned, the developers have...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 3, 2012 at 8:10 am

    #1544937

  • RE: Using MERGE for Audting

    terry999 (10/2/2012)

    Thanks Jason

    I had made that change.

    From now on I will use MERGE to replace Triggers for audit - all in one place.

    Note that this places the onus on...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 3, 2012 at 8:07 am

    #1544935

  • RE: Optimize query needed

    haiao2000 (10/2/2012)

    TheSQLGuru (10/2/2012)

    I am seriously missing something:

    SELECT CAST(5 AS VARBINARY(128)) --0x00000005

    SELECT CAST(0x00000005 AS bigint) --5

    SELECT dbo.ConvertBigIntToVarBinary1(5) --0x010001

    SELECT CAST(0x010001 AS bigint) --65537

    NAH! you aren't missing anything. it was just our requirements...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 2, 2012 at 1:26 pm

    #1544568

  • RE: Best way to effienctly store hugh amounts of data

    bteraberry (10/2/2012)

    One minor point ... even if you decide to use what they've established, you can make the inserts quite a bit more efficient by ditching the cursor loop. ...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

    October 2, 2012 at 1:00 pm

    #1544557

Viewing 15 posts - 2,791 through 2,805 (of 5,841 total)