dcsimg

Search:

Type: Posts; User: cory_jackson

Page 1 of 13 1 2 3 4

Search: Search took 0.17 seconds.

  1. VS 2017 Re: Adding to a list - the value changes afterwards

    That's a good way to describe it John.
  2. VS 2017 Re: Adding to a list - the value changes afterwards

    Is it a List of String? And is line_data of type string? Then I think it should work.
    I'm not proficient at VB but when I have a class, not just string, and create a List of that class, I need to...
  3. SQL Server Import Wizard newline problem

    I have an ASCII text, no-header, fixed-width text file I am importing with the Import Wizard. Lines are terminated with CRLF set. I have the column names and widths defined properly. The last column...
  4. Re: SQL Join, manipulate and comma delimit column

    I would write a program that would go through each row. I'd split using the commas into a List of String and use RegEx to detect and extract your numbers. If there's no RegEx match, use the item...
  5. Re: How do I schedule a query in Azure Db?

    Thanks a million John. You saved me time looking for something i don't have. I don't want to learn about WebJob and the App service yet so I think I'll just make an app on my desktop computer and...
  6. [RESOLVED] How do I schedule a query in Azure Db?

    I have an Azure SQL Server Db, not one running on a VM, and I would like to schedule a simple SQL Query to run periodically to delete rows from a table based on age. I can make the query, but how...
  7. Re: [RESOLVED] Help me understand primary key in a DataTable

    Thanks guys.
  8. Re: [RESOLVED] Help me understand primary key in a DataTable

    I don't think I was a bad person and I don't think any of you thought I was a bad person.
    Thanks for reporting it so it could be moved.
    I found the button to report! I didn't realize the triangle...
  9. Re: [RESOLVED] Help me understand primary key in a DataTable

    If Not TaxIDs.Rows.Contains(strTaxID) Then
    Seems to work perfectly. You're right John, need to look in the rows for data. Thanks again.
  10. Re: Help me understand primary key in a DataTable

    I think I understand John. I'll give that a try and do some experiments. Thank you.
  11. Re: Help me understand primary key in a DataTable

    I can't find any instructions or methods to move my inappropriate post. I've sent a message to the sysop asking for help. If any of you can point me to instructions, I'd appreciate it. Or you can...
  12. Re: Help me understand primary key in a DataTable

    I'm sorry John. I didn't mean to offend anyone by posting i there. I will try to get it moved ASAP and mark it resolved.
  13. Re: Help me understand primary key in a DataTable

    If Not TaxIDs.PrimaryKey.Contains(strTaxID) Then
    Thanks all. I still don't understand why I can't do what MS had. I must have something wrong. So I can see that the PrimaryKey would be like an...
  14. Re: Help me understand primary key in a DataTable

    Sorry Shaggy. I thought DataTables were something one worked with when interacting with databases so I thought this would be a better group. Normally I post things in a more general category and I...
  15. [RESOLVED] Help me understand primary key in a DataTable

    Dim TaxIDs As New DataTable("TaxIDs")
    TaxIDs.Columns.Add("JDX", GetType(Integer))
    TaxIDs.Columns.Add("TaxID", GetType(String))
    TaxIDs.PrimaryKey = New DataColumn() {TaxIDs.Columns("TaxID")}
    Is...
  16. Re: Do SQL row updates cause fragmentation?

    I've found two articles that have me convinced that memory is not allocated for future data in VARCHAR. And nullable adds to the width. So it seems to me that populating a row with many VARCHAR will...
  17. Re: Do SQL row updates cause fragmentation?

    As I understand it MAX is a different animal. I believe that this data is not stored in the same physical location and that VarChar(max) is a fixed width which is to hold the address I think. But i...
  18. Re: Do SQL row updates cause fragmentation?

    In this case I would not be changing the index.

    Gary your comment about a row increasing in size is exactly the heart of what I'm trying to discover. Does it really increase in size?
    Long ago I...
  19. Re: Do SQL row updates cause fragmentation?

    Sorry. I should have said Azure SQL Server.
  20. [RESOLVED] Do SQL row updates cause fragmentation?

    I understand that rows of data are stored in 8K pages and that deleting and inserting can cause fragmentation, but what about updates? In this case my table columns are all normal types like VarChar,...
  21. Re: Does Columnstore eliminate the need for indexes?

    In my case the point is moot. I got to learn all about index fragmentation and once de-fragged (2 hours) the performance returned. Another thing is this table I'm working on is both. Entire rows are...
  22. Re: Does Columnstore eliminate the need for indexes?

    Holy mackerel.
    Yeah, that makes sense. Thanks.
  23. [RESOLVED] Does Columnstore eliminate the need for indexes?

    Columnstore is available on Azure SQL S3 and above and my client is considering the upgrade. I have read some about Columnstore and it sounds great the way is stores data in columns instead of rows,...
  24. Re: How to display index properties in SSMS

    Going back to my original question, I think this has been answered. In Azure FTP the properties page does not exist. One must use a query to get that information.
    Thank you again everyone for your...
  25. Re: How to display index properties in SSMS

    si_the_geek that's kind of what I was starting to think. Thank you for setting that straight in my mind. The queries are running very slow and some use columns that are not indexed. But the first...
  26. Re: How to display index properties in SSMS

    John I poked around in the portal and I can't find anything that shows fragmentation. But the tech gave me some queries and they show much fragmentation.

    I have another request. I understand 8k...
  27. Re: How to display index properties in SSMS

    Funky I thank you for exposing me to Columnstore. I had not heard of this and am boning up on it now. But I have an MS tech who has helped with some scripts to display fragmentation. And it appears...
  28. Re: How to display index properties in SSMS

    18.2: Dunno. I went out and downloaded it form the site.

    Azure portal.... That's a grand idea. I'll check later. Thank you.
  29. Re: How to display index properties in SSMS

    Thank you. I upgraded to 18.2 just to make sure we were the same. I see now how to get to that properties window in the first part. But that's the design properties. I was looking at examples online...
  30. [RESOLVED] How to display index properties in SSMS

    v17.9.1
    I feel stupid for asking, but I'm trying to learn some things about indexing and fragmentation and I see many tutorials that show a user highlighting the index and displaying it's...
  31. VS 2019 Re: [RESOLVED] Installer insists 4.6.1 isn't installed.

    I solved my problem. After doing to wizard setup again and then doing it manually, it still had this problem. When I look under Detected Dependencies I double clicked on "Microsoft .NET Framework"....
  32. VS 2019 Re: Installer insists 4.6.1 isn't installed.

    I discovered under the Launch Conditions a condition for .NET framework. And it's looking for 4.6.1. I am guessing the wizard added this? But if my targeted version in the main project is 4.8.0, why...
  33. VS 2019 [RESOLVED] Installer insists 4.6.1 isn't installed.

    I have an normal WebForm app targeting .NET 4.8.0. I added an installer to it just now, but when I run it, the installer insists i need 4.6.1 installed. But I have 4.6.1 installed, and I'm not...
  34. Replies
    2
    Views
    346

    VS 2010 Re: how can i take this number

    I typically use RegEx to grab the text when web scraping. The expression in this case would be "<span class="value--2NhHD"> (\d+) </span>". The \d+ in parentesis creates capture group #1. Of course...
  35. Re: what is weakness and problems with this code?

    Peter is right. Entering your code here with the highlight option and make the highlight type "vb.net" will make it easier for others to read.

    I'm no expert. Here's a couple thoughts though:
    You...
  36. Re: Access to the path "C:\Program Files (x86)\My Project\LogTest.txt' is denied.

    I use the normal User temp folder. I like to create my own folder so I can delete the contents before and after each use just in a case something it left over from a program crash or error in my...
  37. VS 2010 Re: Random number generator and linear search on text file

    You don't need to create a string variable "number". You can add the .tostring method at the end of the integer variable.

    All you need is a stream reader to read one line at a time from the file....
  38. Re: "Not" with multiple conditions

    Thank you. I wasn't thinking clearly about the "not" in front of each. Thanks for clarifying.
  39. [RESOLVED] "Not" with multiple conditions

    If False Or True = True
    If Not False Or True = True
    If Not False Or Not True = True
    If Not (False Or True) = False

    I've distilled this down to eliminate the comparisons and variables and...
  40. VS 2019 Re: Problem with FTP path for file download

    I found the solution in a post on Stack Overflow. By adding a double slash at the beginning of the path, it forces the remote system build the path from the root. I'm posting this so others might...
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width