Forum Replies Created

Viewing 15 posts - 5,041 through 5,055 (of 13,460 total)

  • RE: Delete data in tables/performance issues

    if you know it will always be a delete and truncate, vs a merge, i'd import into a new table, and when the import was complete, rename the original table...

    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!

    August 6, 2012 at 10:03 am

    #1522144

  • RE: Are the posted questions getting worse?

    You could add me to a review list; I'd like to see something like an email or page where us "volunteers" go and review potential QOTD periodically, and after 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!

    August 6, 2012 at 9:58 am

    #1522143

  • RE: Want To Be SQL Server 2008 DBA

    for me, there's different "flavors" of DBA's.

    i have this saved in my snippets;

    i recommend reading each of the articles, and test yourself/grade yourself on what you know how to do...

    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!

    August 6, 2012 at 9:50 am

    #1522133

  • RE: Creating a backup plan

    take a look at this peer acclaimed solution to backups.

    http://ola.hallengren.com/sql-server-backup.html

    aside from that, it doesn't matter what you use, unless you test the backups after it was completed.

    running the backups is...

    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!

    August 6, 2012 at 8:50 am

    #1522092

  • RE: Traces running with NULL FileName,MaxSize values

    wierd;

    i cannot get a trace to be created with either the options or the filename to be null;

    it's wierd that you are able to see that.

    i tried stuff like stopping...

    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!

    August 6, 2012 at 7:58 am

    #1522060

  • RE: Sending email from SQL

    back to the first suggestions: get with your mail administrator; tell him the IP address /machine name and account you are trying to use so he can allow relaying.

    after he...

    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!

    August 6, 2012 at 7:46 am

    #1522046

  • RE: Show Right Column to Right User

    include all the columns, but blank them out based on permissions is what i would recommned.

    something like this?

    SELECT

    SomeColumns,

    CASE

    WHEN IsSalesman...

    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!

    August 6, 2012 at 7:39 am

    #1522039

  • RE: How to SEND a report via SPROC

    I've certainly done non-reporting services HTML reports via sprocs and mailed them, is that what you are after?

    the trick is to build an html string, and use FOR XML 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!

    August 6, 2012 at 6:59 am

    #1522007

  • RE: Sending email from SQL

    devanandiiway (8/6/2012)

    Hi,

    Thanks for the reply. I looked into the profile configration we have set basic authentication and we have given the credentials.

    Is that the reason for undelivered?

    Devanand.

    can't say for sure;...

    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!

    August 6, 2012 at 6:22 am

    #1521984

  • RE: Sending email from SQL

    As derek and anthony identified, it'll be an issue with your mail server not allowing relaying; it's an anti spam feature.

    relaying is forwarding/sending emails to a domain outside of 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!

    August 6, 2012 at 5:54 am

    #1521973

  • RE: How to sum over distinct values of two columns

    the real data might be a little more complex, but doesn't a simple group by get you the data you asked for?

    /*

    OrderNumber Item Fee

    ----------- ------ -----------

    52 ...

    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!

    August 3, 2012 at 3:00 pm

    #1521643

  • RE: TSQL Concatenate Error

    BULK insert does not allow variables , nor will it allow concatention to create the file name;

    BULK INSERT BULKACT FROM 'c:\Export_o.txt' --valid

    BULK INSERT BULKACT FROM 'c:\' + @path --error

    BULK INSERT...

    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!

    August 3, 2012 at 1:30 pm

    #1521605

  • RE: SQL Server 2008 - Hosting permissions

    was this even close remotely what you were looking 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!

    August 3, 2012 at 1:19 pm

    #1521598

  • RE: Alter table script

    To add What Sean is saying; changes are often not just DDL schema changes; when you add a new table, you may have added new rows in that new table...

    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!

    August 3, 2012 at 12:15 pm

    #1521577

  • RE: default database for a login

    don't you just need to assign a new default database to the login in question?

    assigning it master as the default is what i typically do.

    ALTER LOGIN login_name WITH DEFAULT_DATABASE =...

    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!

    August 3, 2012 at 11:32 am

    #1521544

Viewing 15 posts - 5,041 through 5,055 (of 13,460 total)