Forum Replies Created

Viewing 15 posts - 5,251 through 5,265 (of 13,460 total)

  • RE: Create Script of all indexes in a Database

    AAKR (7/5/2012)

    Hi thanks for quick reply. this script working on sysdatabases only

    I want create user database indexes please provide the script:-)

    Thanks in Adavance:-)

    which script are you talking about?

    did you run...

    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!

    July 5, 2012 at 9:48 am

    #1509198

  • RE: Create Script of all indexes in a Database

    here's another version i had slapped together once;

    this is specific to SQL 2008 and above, becuase it's also scripting filtered indexes and include columns;

    i never bothered fleshing out the partitions...

    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!

    July 5, 2012 at 9:39 am

    #1509191

  • RE: Revert Last Delete Statement on in SQL Mgmt Studio

    the only way is to restore from backup.

    if you were not inside an explicit transaction you created, the change would be committed immediately, with no way to reverse it.

    if you...

    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!

    July 5, 2012 at 9:11 am

    #1509171

  • RE: SQl Server CLR

    I'm not sure either;

    in my CLR where i'm using a web service, i have an added web reference;

    i'm hitting the web service directly;

    i'm guessing that for you, it's really indirect,...

    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!

    July 5, 2012 at 8:39 am

    #1509155

  • RE: SQl Server CLR

    Stewart "Arturius" Campbell (7/5/2012)

    Has the method / dll that is being used correctly referenced and / or deployed? special care must oftimes be taken when other dll's are being referenced.

    that'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!

    July 5, 2012 at 8:27 am

    #1509147

  • RE: Synonym to Indexed view not using the correct execution plan

    for the item that is running slow, can you try adding this option(optimize for ) to your query?

    SELECT SUM(amount) [Total],SUM(number) [Number of Records],

    ...[snipped for clarity]...

    ) data

    GROUP BY TransactionCurrency,TransactionType,TransactionCode,TransactionSubCode,SecondarySubCode

    --this is what...

    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!

    July 5, 2012 at 8:00 am

    #1509130

  • RE: Synonym to Indexed view not using the correct execution plan

    Yes this is all true, but I am not running it via the stored procedure- i am just running SQL code with the parameters passed directly , as 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!

    July 5, 2012 at 7:33 am

    #1509114

  • RE: Synonym to Indexed view not using the correct execution plan

    yeah i'm more sure than ever it's parameter sniffing, and nothing to do with synonyms at all;

    my first clue:

    if @EndDate is Null

    select @EndDate = getdate()

    i'll assume that the costructor for...

    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!

    July 5, 2012 at 6:20 am

    #1509068

  • RE: Synonym to Indexed view not using the correct execution plan

    Rin Sitah (7/3/2012)

    Hi There,

    when the proc is run, it takes hours to complete.

    Any help would be appreciated. Let me know if you need more information!

    Cheers.

    I'm thinking the issue has a...

    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!

    July 5, 2012 at 5:42 am

    #1509050

  • RE: SQL + PGP = head aching

    I had built a prototype CLR that i thought would work, but i didn't have PGP installed on my work machine for testing.

    here's the CLR code i thought would work,...

    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!

    July 4, 2012 at 10:55 am

    #1508849

  • RE: Copy query result to excel

    it's an excel thing: simply highlight all the cells, right click and Choose format Cells...

    the popup window choose "Text" fromt e available options.

    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!

    July 3, 2012 at 3:20 pm

    #1508509

  • RE: Testing Enterprise Backups

    tim.cloud (7/3/2012)

    I just finished setting up a server that does exactly what you need. In fact, here is what I setup:

    1.) A single core VM with a single drive...

    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!

    July 3, 2012 at 3:04 pm

    #1508503

  • RE: Using Table valued function

    CELKO (7/3/2012)

    The short answer is that good programmers do not use table valued functions. They are proprietary, screw up the optimizer and require disk access so they are slow.

    Instead...

    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!

    July 3, 2012 at 2:56 pm

    #1508500

  • RE: Query Results problem, at my wits end....

    the trick is you are missing a couple of tables, i bet.

    you have to get all possible combinations before you join for the totals.

    you have to select from something like...

    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!

    July 3, 2012 at 1:52 pm

    #1508472

  • RE: Granting datareader access to a user for objects in a schema

    Kwisatz78 (7/3/2012)

    Correct he was saying he couldn't see the list of tables in SSMS. I will run the script tomorrow when I get back to work 🙂

    it's really easy...

    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!

    July 3, 2012 at 1:41 pm

    #1508464

Viewing 15 posts - 5,251 through 5,265 (of 13,460 total)