Forum Replies Created

Viewing 15 posts - 11,206 through 11,220 (of 13,460 total)

  • RE: Script needed to identify indexes in database that SHOULD be defined as UNIQUE but are not

    hmmm... thinking about it, i think you have to test the count > 1 and EXCLUDE those indexes istead;

    a table with no rows simply will not return results in the...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 20, 2009 at 8:51 pm

    #981163

  • RE: Script needed to identify indexes in database that SHOULD be defined as UNIQUE but are not

    Marios Philippopoulos (4/20/2009)

    I need a script that will list all indexes in a database that SHOULD be defined as UNIQUE (based on the data distribution) but are not.

    Does anyone have...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 20, 2009 at 8:46 pm

    #981161

  • RE: How to Delete Temporary Tables from the MSCS_CatalogScratch Database

    well the db will not get smaller... a db stays at a certain size in order to save space for future work...but the space used/space free will change.

    run sp_spaceused on...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 20, 2009 at 12:37 pm

    #980961

  • RE: update problem in sql server express

    rajeevgupta40 (4/20/2009)

    hi,

    i want to update total sum of quantity not only quantity.

    you cannot do this.

    a query with a group by does not expose data so it can be updated.

    you must...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 20, 2009 at 11:11 am

    #980895

  • RE: Solid State Storage is here as a feasible solution?

    i read up on RamSAN thanks to you guys;

    I'm jealous, quite frankly.

    seems to be faster than a bat outta...well

    but it's not a cheap solution either. that's some big money to...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 20, 2009 at 10:01 am

    #980827

  • RE: Effect of Truncate on Indexes

    does truncating force a rebuild(resetting?) on statistics if auto-update statistics is ON?

    i know there is a threshold of 20% rows changed before the auto update occurs, but since truncate...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 19, 2009 at 7:33 pm

    #980476

  • RE: SQL server data types and HTML

    your confusing presentation layer with the data layer.

    you could argue that all your data be stored as a bitmap/image, since that is how it is going to be presented.....hopefully it's...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 18, 2009 at 7:40 pm

    #980295

  • RE: How to Delete Temporary Tables from the MSCS_CatalogScratch Database

    yulichka (4/18/2009)

    There is note under script:

    Note:

    Use the CatalogCleanup.vbs script when your Commerce site is not running to prevent performance impact and to make sure that all temporary tables are...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 18, 2009 at 7:01 am

    #980179

  • RE: How to Delete Temporary Tables from the MSCS_CatalogScratch Database

    yes you need to delete temporary tables.

    MS recommends at least every week.

    you can use the script provided and never bring your database offline.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 17, 2009 at 11:49 am

    #979886

  • RE: How to Delete Temporary Tables from the MSCS_CatalogScratch Database

    i would use the script that Austin_123 pointed you to, straight from Microsoft;

    one of the nice things it says is that if you DON'T take the catalog off line,...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 17, 2009 at 11:22 am

    #979860

  • RE: Do you need Dynamic SQL to query multiple databases?!

    you are right in your suspicions, it's gotta be dynamic.

    the reason is any sql statement cannot take a variable for an Object.

    so whatever the object, whether databasename or tablename, if...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 17, 2009 at 7:29 am

    #979658

  • RE: deleted entries from the table !!!

    homebrew01 (4/17/2009)

    Would the default trace have that information ?

    no, unfortunately.

    the default trace tracks DDL stuff...who created /altered/deleted database objects...it doesn't have anything related to DATA changes. you need a separate...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 17, 2009 at 6:45 am

    #979597

  • RE: Report Performance

    i think the rule is a count of 20% of the total rows in a given table have to insert/change before auto-update of the statistics occurs. On a billion row...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 16, 2009 at 10:40 am

    #979044

  • RE: which backup mode is in place

    it's simply

    ALTER DATABASE Yourdbname SET RECOVERY SIMPLE

    or

    ALTER DATABASE Yourdbname SET RECOVERY FULL

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 16, 2009 at 10:29 am

    #979026

  • RE: Is there a function which determines if a varchar is a number?

    glad you found it Dom;

    this site has a Ton of really useful scripts. enjoy.

    i cleaned up my original post, since the update to the CODE window made HTML font info...

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

    April 16, 2009 at 6:25 am

    #978750

Viewing 15 posts - 11,206 through 11,220 (of 13,460 total)