Forum Replies Created

Viewing 15 posts - 2,401 through 2,415 (of 13,460 total)

  • RE: Can composite indexes be used as an index on a single field?

    since you said the PartNumber is the first field, then yes; but it also depends on how selective that single column is.

    if there's a lot of common values, SQL...

    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 3, 2014 at 11:45 am

    #1702986

  • RE: DDL Triggers and exec privilege

    the issue is not the trigger, but the tables/objects the trigger is manipulating.

    for example, if your trigger is inserting into master.dbo.MyAuditTable, you probably want to GRANT INSERT ON master.dbo.MyAuditTable 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 3, 2014 at 10:14 am

    #1702948

  • RE: Opinion of use of LINQ

    Welsh to capture the code, for example, i decided the dmv's were not enough; not everything exists in the cache to check for performance issues.

    Instead i started with 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!

    April 3, 2014 at 10:08 am

    #1702943

  • RE: Opinion of use of LINQ

    at our shop, we use a lot of LINQ; generally, the developers write whatever they want, and if they hit a performance block, then that call gets modified to use...

    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 3, 2014 at 9:13 am

    #1702909

  • RE: Can't drop index due to FK enforcement

    like the error is telling you, because there are foreign keys in place, in this case you'll need to drop and recreate the foreign keys, i think; you can find...

    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 2, 2014 at 10:33 am

    #1702548

  • RE: Tranaction Logs on a Test Box

    Andrew in my shop, all databases on development boxes are switched over to simple recovery mode; i don't need a point in time restore on development that log backups would...

    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!

    March 31, 2014 at 10:30 am

    #1701690

  • RE: SEARCHABLE PDF'S

    have you considered adding a full text index on the pdfs themselves? you'd obviously need to modify HOW you search after you have that in place.

    first example i found when...

    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!

    March 31, 2014 at 9:57 am

    #1701671

  • RE: Execute Permission Problem on Stored Procedure

    it's rare that a procedure explicitly names the database while in the same database; i really think it's affecting another database: this snippet from your proc really makes me think...

    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!

    March 31, 2014 at 9:15 am

    #1701637

  • RE: Execute Permission Problem on Stored Procedure

    the procedure deleted from the database [HPApps], which i suspect is NOT the same db thatt proc exists in.

    so if the produdure exists in [LocalDB], the permisisons chain is broken,and...

    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!

    March 31, 2014 at 8:23 am

    #1701606

  • RE: Columns_updated() in a trigger started giving incorrect column after a column has been removed form the table.

    you have to alter your trigger. your staticly written trigger did not change to now match the new results from columns_updated() function

    columns updated uses a map to say which columns...

    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!

    March 31, 2014 at 6:52 am

    #1701560

  • RE: Execute Permission Problem on Stored Procedure

    Chris can you take a look at the specific stored proc that is raising the error?

    ownership chaining is probably disrupted in this specific case.

    you can get that error "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!

    March 31, 2014 at 6:41 am

    #1701557

  • RE: sql dynaminc and aggregate functions

    another issue is that query is going to use integer division and return incorrect totals

    something in the query needs to be multiplied by 1.0 so that the datatype is expanded...

    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!

    March 27, 2014 at 2:43 pm

    #1700892

  • RE: Server-side trace to find SELECT *

    --

    --fix any views that happen to have changes to their underlying tables they query from

    declare c1 cursor for

    select name from sys.views

    open c1

    fetch next from c1 into @viewname

    While @@fetch_status <>...

    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!

    March 27, 2014 at 2:39 pm

    #1700889

  • RE: Server-side trace to find SELECT *

    since you are taking about VIEWS breaking, that really has nothing to do with a trace, right? it really has to do with source code of views/procs/etc

    i typically refresh every...

    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!

    March 27, 2014 at 2:33 pm

    #1700883

  • RE: Indexes creation

    I'd seen several similar posts on finding index creation date.

    i'm very sure that there is no creation date exposed anywhere for indexes; objects in sys.objects have the create_date and modify_date,...

    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!

    March 27, 2014 at 8:37 am

    #1700716

Viewing 15 posts - 2,401 through 2,415 (of 13,460 total)