Forum Replies Created

Viewing 15 posts - 9,061 through 9,075 (of 13,460 total)

  • RE: identifying resources used by a server side trace

    profiler = heavy impact i agree, but a server side trace I still believe has negligible/almost nil impact; that was what i was trying to say.

    i've placed both a DML...

    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 13, 2010 at 6:01 am

    #1191939

  • RE: Insert rows

    you need to decide that the new user is going to copy/inherit the roles of a specific user.

    for example:

    insert into user_role

    select

    3, --the userid of the new person...

    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 13, 2010 at 5:55 am

    #1191935

  • RE: identifying resources used by a server side trace

    winston I'm in the same camp of not worrying about the trace impact after this article about the near-zero impact of a server side trace where someone actually compared...

    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 13, 2010 at 5:40 am

    #1191928

  • RE: Block Users from using sql server query analyzer

    ahh... no i don't believe so...the database is not available, or no definitive to the to the logon connection...you know i can connect to master, but query db1 using 3...

    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 12, 2010 at 12:55 pm

    #1191653

  • RE: Block Users from using sql server query analyzer

    this is a per-SQL-Server installation/instance trigger, not a per-machine trigger...

    so if you have a server named "PROD", and it has a default SQL instance, and two named instances, ie "PROD\SQL2005"...

    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 12, 2010 at 12:16 pm

    #1191633

  • RE: Openrowset don't show all columns

    i'm thinking something like this:

    bring everything is as one big field...i'm assuming varchar(8000) would hold it, but it might need varchar(max).

    once in a table, use CHARINDEX2 to chop everything up...

    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 12, 2010 at 12:05 pm

    #1191628

  • RE: Openrowset don't show all columns

    WayneS (7/12/2010)

    Did changing to the SQL Native Client driver help out? As I demonstrated, it seems to work for me.

    Wayne i thought the OP was running into the fact that...

    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 12, 2010 at 9:47 am

    #1191551

  • RE: Maintaining Common Functions & Procedures Across Multiple Servers

    I don't see an advantage to not copying the functions to the new server's master database.

    Cross database functions with a synonym are going to be slow, and have an additional...

    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 12, 2010 at 9:24 am

    #1191529

  • RE: Free online SQl server?

    you can always connect to the tempdb database and run your scripts; your objects will not have any impact anywhere.

    i would simply install a local SQLEXPRESS on my own development...

    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 12, 2010 at 6:32 am

    #1191424

  • RE: Eliminate Duplicate Descriptions for UNIQUE Key value

    Mac:

    CREATE TABLE definition?

    the actual [Account_Code_AK] values for one of the items that is duplicated so we can see?

    names of the tables that reference that alternate key?

    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 11, 2010 at 9:16 am

    #1191225

  • RE: Eliminate Duplicate Descriptions for UNIQUE Key value

    Mac we probably need a little more info...does the table for Account Code have an identity/primary key, in addition to the two columns you showed us? are their foreign keys...

    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 11, 2010 at 8:33 am

    #1191212

  • RE: Block Users from using sql server query analyzer

    here's another example i posted that has additional logic, and check out the thread it came from for more info:

    http://www.sqlservercentral.com/Forums/Topic927131-359-1.aspx

    in this case, i'm trying to prevent SSMS and also...

    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 10, 2010 at 12:18 am

    #1191113

  • RE: is there really no way to do this? turn rows into columns?

    oops..

    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 10, 2010 at 12:17 am

    #1191112

  • RE: Need help with cursor

    forget the cursor, you can and should do this with a single update:

    UPDATE SOMETABLE

    SET new_date = start_date

    WHERE new_date <> start_date

    AND status <> 'reopen'

    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 9, 2010 at 12:34 pm

    #1190986

  • RE: is there really no way to do this? turn rows into columns?

    here's an example, but i don't think you can generate then column names dynamically this way(i know you will ask that!)..i think the AS 'Val' + RN will not work.

    ;with...

    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 9, 2010 at 12:26 pm

    #1190983

Viewing 15 posts - 9,061 through 9,075 (of 13,460 total)