Forum Replies Created

Viewing 15 posts - 9,361 through 9,375 (of 13,460 total)

  • RE: estimate disk size for system dbs for a 50 GB app db.

    for me, i use a rule of thumb of 10% of the mdf size as the needed log size, but the correct answer is "it depends".

    If your database is in...

    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!

    May 26, 2010 at 7:09 am

    #1172681

  • RE: Create DB Script

    you didn't print the actual error, so this is just a guess: the error was constraint name "pk_username_profile " already exists

    search your script for pk_username_profile and see if it...

    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!

    May 26, 2010 at 7:01 am

    #1172672

  • RE: http call embedded in stored proc

    J this thread was the most valuable thing of the week for me; i learned a lot. thank you very much.

    I had to change your udf very slightly; i converted...

    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!

    May 25, 2010 at 3:57 pm

    #1172389

  • RE: http call embedded in stored proc

    J that got me looking in the right direction;

    for whatever reason, my dll's class name is a little weird; i used hte deploy option, and then when i scripted 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!

    May 25, 2010 at 3:39 pm

    #1172382

  • RE: http call embedded in stored proc

    J i've got a question for you regarding deployment;

    i created a new VS project named "MyCLRProjects, and added only your Partial Public class as an example;

    it compiled, and i was...

    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!

    May 25, 2010 at 1:16 pm

    #1172316

  • RE: ERROR: Can't Connect to MySQL Server

    do you still have FTP access to the root of your web site? can't you download the suite of pages, as well as the mySQL database and rehost it somewhere...

    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!

    May 25, 2010 at 11:42 am

    #1172267

  • RE: Possible to pass many records to sp_send_dbmail without using a loop?

    Maxthere is not a ton of options,as you've identified;

    the parameter @recipients,@copy_recipients and @blind_copy_recipients for sp_send_dbmail is a varchar max, expecting a semicolon seperated list of recipients;

    if all the recipients 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!

    May 25, 2010 at 11:37 am

    #1172264

  • RE: Concatenate 2 integer columns and check value in WHERE clause

    bigclick (5/25/2010)

    .... Unfortunately this is an old legacy system where the database isn't controlled by the company ....

    oh yeah I've suffered through that same situation before, I feel 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!

    May 25, 2010 at 11:24 am

    #1172261

  • RE: Concatenate 2 integer columns and check value in WHERE clause

    _ms65g_ (5/25/2010)

    SELECT TOP 100 CLACCT, DATE

    FROM

    (

    SELECT CLACCT, CAST(MONTH AS VARCHAR(2)) + CAST(YEAR AS VARCHAR(4)) AS DATE

    FROM cu102 (nolock)

    ) D

    WHERE DATE > 062007

    this should be a lesson to never store...

    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!

    May 25, 2010 at 10:04 am

    #1172204

  • RE: Identifying ASCII characters in NVARCHAR columns

    proof of concept for Steve's idea;i thought that was kind of neat:

    --results:

    Status cnv ...

    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!

    May 25, 2010 at 9:33 am

    #1172183

  • RE: How to kill the "Sessions inactive for a long time"

    first, i would suggest not killing any connections, whether you know they are in use or not.

    just because they 've connected for a long time, does not mean they are...

    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!

    May 25, 2010 at 8:37 am

    #1172107

  • RE: Modifying a Column To Computed Column

    without dropping it, the calculated column would need a different name; it depends on what you really need;

    since I would prefer not to delete delete data by dropping a column,i...

    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!

    May 25, 2010 at 8:24 am

    #1172097

  • RE: Most Efficient Approach

    Vishal Singh (5/25/2010)

    This is how the sample data looks like:

    INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,78628,4,1)

    INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,89059,4,1)

    INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,89230,4,1)

    INSERT INTO [tbl1] ([PrimaryID],[RelatedID],[RelationID],[PosID])VALUES(1,89235,4,1)

    looks very easy to re-format; all four values appear...

    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!

    May 25, 2010 at 7:24 am

    #1172047

  • RE: Most Efficient Approach

    ugg; one-time imports are sometimes the most time consuming...can we see a row or two of sample data? enough to make a format file so you could test a bcp...

    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!

    May 25, 2010 at 7:01 am

    #1172029

  • RE: Most Efficient Approach

    Vishal in my experience, a text filefilled with INSERT INTO....commands is much much slower than using BULK INSERT or bcp to bring in a text doucment filled with raw data;

    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!

    May 25, 2010 at 6:50 am

    #1172025

Viewing 15 posts - 9,361 through 9,375 (of 13,460 total)