Forum Replies Created

Viewing 15 posts - 8,146 through 8,160 (of 13,460 total)

  • RE: fill datagridview with 5 million record & transactions

    Sjeef (2/8/2011)

    why would you go into reading line per line and insert that into the dataview.?

    put the result of your sqlstatement into a dataset

    dim myds as dataset = new dataset("sqlstmt","sqlconenction")

    then...

    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 8, 2011 at 12:31 pm

    #1283986

  • RE: Suggestion on Foreign Key Constraint

    zubairmasoodi (2/8/2011)

    Thanks for your quick reply

    Cannot truncate table 'UserInfo' because it is being referenced by a FOREIGN KEY constraint.

    No, the constraint will not let you delete the Country because 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!

    February 8, 2011 at 11:18 am

    #1283898

  • RE: SQL Help

    Ram this seemed a little too straight forward...simple CONVERT commands seem to work fine for me...what am i missing on your question?

    With tblA(CustomerKey,CustomerID)

    As

    (

    SELECT N'000098878787',N'284005' UNION ALL

    SELECT N'000089898989',N'284005' UNION ALL

    SELECT...

    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 8, 2011 at 10:14 am

    #1283846

  • RE: DDL creation issue

    so your script is using a hardcoded path, and sometimes the path does not exist, right?

    i'd build the path to the files based on the existence of data i 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!

    February 8, 2011 at 9:35 am

    #1283810

  • RE: finding occurences of select *

    doh i didn't even think about if there were any math functions in the bodies; good catch; i'm not sure on the commented comments...

    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 8, 2011 at 8:21 am

    #1283730

  • RE: finding occurences of select *

    i think i got it...try my updated post, which assumes that same function. does that get you where you wanted to be?

    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 8, 2011 at 8:14 am

    #1283719

  • RE: finding occurences of select *

    the second part to test for EXISTs is not so easy;

    looking at our code base, we have a couple of different styles for people using EXISTS:

    IF exists(select specificColumnName

    ---

    IF exists(

    select *...

    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 8, 2011 at 8:04 am

    #1283704

  • RE: finding occurences of select *

    I agree with Gus, it's not all that easy; At first,i couldn't think of how to do it in a single query and thought i might using a cursor 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!

    February 8, 2011 at 7:52 am

    #1283694

  • RE: Removing all the partitions

    my first instinct would be to confirm that the objects that appear in this list need to be scripted to move their clustered index to the default partition(or dropped), 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 7, 2011 at 3:09 pm

    #1283455

  • RE: T-SQL Problem Using "run as user" in job step

    could it be that the step is running in the master database instead of the db the proc is in? what if the command was changed to have the full...

    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 7, 2011 at 1:52 pm

    #1283423

  • RE: Cannot add certain integers to table

    the error "string or binary data would be truncated". is specific to char/varchar fields...it doesn't have anything to do with integer fields.

    since the command you are using doesn't even touch...

    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 7, 2011 at 12:42 pm

    #1283385

  • RE: SQL Server trace

    This should help you Find all the traces on the server, and builds the commands to stop/drop the trace as well...

    avoid using the command to drop teh default trace(is_default =...

    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 7, 2011 at 12:11 pm

    #1283361

  • RE: Date Comparison Using Table Scan ... Sometimes

    I think we'd want to see the actual execution plan to be sure, you might benefit from posting that.

    i think the issue is going to be related to this:

    AND (endDate...

    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 7, 2011 at 11:46 am

    #1283343

  • RE: Tempdb Full - Grown overnight

    wouldn't this occur if the indexes were being rebuilt with the option SORT_IN_TEMPDB?

    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 7, 2011 at 9:50 am

    #1283253

  • RE: fill datagridview with 5 million record & transactions

    paging your data requires some sort of key...whether it's the PK/identity of the table, or by using row number.

    assuming you have a "Next" button on your application to get 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!

    February 7, 2011 at 7:41 am

    #1283117

Viewing 15 posts - 8,146 through 8,160 (of 13,460 total)