Forum Replies Created

Viewing 15 posts - 11,416 through 11,430 (of 13,460 total)

  • RE: Out of date statistics

    Krishna (3/16/2009)

    Do not put Autoupdate stats ON, it does affect your database performance. I would prefer running a job to update statistics now and then after analyzing the data.

    AFAIK, disabling...

    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 17, 2009 at 12:09 pm

    #961298

  • RE: Drop All Users in the Database

    i just slapped this together.

    i'm using sp_revokeaccess instead of sp_dropuser, because the users might be orphaned and not tied to a login;

    this yanks them out the way i expected:

    [font="Courier New"]ALTER...

    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 16, 2009 at 11:42 am

    #960474

  • RE: A theoretical flat file database, how could it work well?

    when i think "database", i think SQL server, so that multiple connections can get to a source of data and select/insert/update.

    i think of a flat file as a snapshot ofdata...

    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 16, 2009 at 11:00 am

    #960421

  • RE: A theoretical flat file database, how could it work well?

    in .NET, your Datasource has the ability to .WriteXML(pathToFile) and .ReadXML(pathToFile), so it's very easy to load tables into your dataset form say, SQL server, and then write them 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!

    March 16, 2009 at 10:20 am

    #960393

  • RE: Trigger Issue forUpdation

    the virtual table INSERTED, which exists only for the duration of the trigger, has all the records that were updated.

    if you show us your current trigger in SQL, we can...

    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 16, 2009 at 7:33 am

    #960214

  • RE: T-Sql rant

    a cursor is like the add + function, where set based is like multiplication.

    Using addition as

    yeah you can do 2+2+2+2+2+2+2+2 = 16, because that's what you are used 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!

    March 13, 2009 at 3:13 pm

    #959482

  • RE: T-Sql rant

    the only things you identified so far is a slight shortening of a couple of keywords....saving a handful of keystrokes doesn't mean that's an improvement, just a preference.

    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 13, 2009 at 2:36 pm

    #959452

  • RE: change first 12 characters from numbers to ****

    same thing, different way:

    [font="Courier New"]UPDATE mytable

    SET myfield= '************' + RIGHT(myfield,4)

    WHERE LEN(myfield) = 16 --only change items that are exactly 16 chars

    SELECT * FROM mytable WHERE LEN(myfield) <> 16 [[/font]

    ...

    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 13, 2009 at 11:57 am

    #959360

  • RE: PHP with MS SQL SERVER CONNECTIONS

    do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

    everyone uses the "View Latest Posts", so you need to post this only...

    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 13, 2009 at 11:09 am

    #959325

  • RE: PHP with MS SQL SERVER CONNECTIONS

    do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

    everyone uses the "View Latest Posts", so you need to post this only...

    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 13, 2009 at 11:08 am

    #959323

  • RE: PHP with MS SQL SERVER CONNECTIONS

    do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

    everyone uses the "View Latest Posts", so you need to post this only...

    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 13, 2009 at 11:07 am

    #959322

  • RE: PHP with MS SQL SERVER CONNECTIONS

    do not spam the same question into multiple forums. it was's everyones time and disjoints all the answers.

    everyone uses the "View Latest Posts", so you need to post this only...

    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 13, 2009 at 11:07 am

    #959321

  • RE: SQL data export to end customer setup ?

    I've done something similar, but made sure it was an application that happens to conenct to SQL server, not do it via SQL server itself.

    .NET DataSource object has the ability...

    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 13, 2009 at 8:23 am

    #959137

  • RE: Kill sessions before restore command

    eashoori (3/13/2009)

    Thank you so much Lowell, do we call this procedure before restore command in another SSIS step or cna we just incorporate it in the same?

    thanks a lot 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!

    March 13, 2009 at 7:37 am

    #959094

  • RE: SQL Server - Selectively inserting fields into temp table

    if the stored procedure returns 10 columns, you'll have to have a temp table that catches all ten columns...after that, you could ignore the other columns and continue from...

    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 12, 2009 at 9:15 pm

    #958893

Viewing 15 posts - 11,416 through 11,430 (of 13,460 total)