Forum Replies Created

Viewing 15 posts - 5,911 through 5,925 (of 13,460 total)

  • RE: how to do Automated restore script for UAT refresh for all the Database

    pretty loose on the details.

    do you have to copy the backup(s) from somewhere to the UAT server now?

    do you have the current backup(s) scripted out already so you can just...

    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!

    February 22, 2012 at 11:23 am

    #1450470

  • RE: Login information

    unless you already have created a trace which is capturing that information, it's not available anywhere. SQL server does not keep track of successful logins unless you enabled it or...

    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!

    February 22, 2012 at 8:33 am

    #1450358

  • RE: SQL 2005 64 bit Consuming RAM Rapidly (Please Help)

    Different application hitting the server, or the identical application and same traffic?

    It's been mentioned at least half a dozen times that SQL using all the memory is perfectly normal, but...

    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!

    February 22, 2012 at 6:58 am

    #1450245

  • RE: SQL 2005 64 bit Consuming RAM Rapidly (Please Help)

    AWE settings have no affect on 64 bit isntallations.

    by default, SQL will consume 100% of the memory, or up to 100% of the maximum you set.

    What can be a little...

    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!

    February 21, 2012 at 2:12 pm

    #1449961

  • RE: year get

    Eugene Elutin (2/21/2012)

    try this:

    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    should help to get the most relevant answer in minutes.

    link from above updated: the link had an extra

    character in it after the forum rendered...

    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!

    February 21, 2012 at 9:57 am

    #1449818

  • RE: proc call inside proc call not showing in trace

    what events are you using?

    my traces usually have both SQL:BatchCompleted and RPC:Completed

    RPC:Completed will return code when a proc is executed, whether in TSQL or when a command object has...

    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!

    February 21, 2012 at 9:54 am

    #1449816

  • RE: how to get the Domain group name based on the login name

    and another way, via an extended stored proc:

    EXEC master..xp_logininfo

    @acctname = 'mydomain\lowell',

    @option = 'all' -- Show all paths a user gets his auth from

    go

    EXEC master..xp_logininfo

    ...

    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!

    February 21, 2012 at 9:20 am

    #1449787

  • RE: year get

    from your query so far, i couldn't infer any datetime columns exist that you could pull the year out of.

    there is a YEAR function that will get the year of...

    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!

    February 21, 2012 at 9:14 am

    #1449783

  • RE: Maximum number of values allowed in the parameters drop down

    sambireddy chirra (2/21/2012)

    it's possible,i tried its working.

    I call shenanigans.

    If you tried it, you'd report the same performance hit I was talking about.

    Performance on a page like this sucks., 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!

    February 21, 2012 at 5:03 am

    #1449607

  • RE: Performace hit on server when using sp_send_dbmail

    none.

    no performance impact, because the mail command is asynchronous...the mail is queued to the service broker, and it processed outside of the transaction;

    On a recent email campaign, i queued about...

    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!

    February 20, 2012 at 7:37 pm

    #1449460

  • RE: Index Hint Causing Confusing Error

    the DDL of the table can help us solidly determine why the index gets skipped;

    for example:

    one wild guess: if tbl3.ColA and tbl2.ColA in your example below are not the same...

    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!

    February 17, 2012 at 2:35 pm

    #1448814

  • RE: find the name of a table and column that contains a perticular value

    to find a datavalue, you'll have to use a cursor or it's equivalent of building a SQL command for each varchar/char column and executing it.

    I've done this before, so let...

    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!

    February 17, 2012 at 1:15 pm

    #1448750

  • RE: Annimated GIF avatars

    i think if your animated gif is over a certain size, or gets resized automatically, the format is not gif89a? (animated?), it's a different gif;

    double check you r gif 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!

    February 17, 2012 at 9:50 am

    #1448626

  • RE: Query with variable for "any letter"

    it goes back to what you said you want to do...I might be misunderstanding.

    I thought you said you said both find anything and find anything except...

    will something like this 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!

    February 17, 2012 at 9:18 am

    #1448601

  • RE: Table Structure For 900+ tables

    krishnakhanna (2/17/2012)

    Basically structure data like the following for all users and tables

    Name ...

    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!

    February 17, 2012 at 8:46 am

    #1448578

Viewing 15 posts - 5,911 through 5,925 (of 13,460 total)