Search Results

Search found 13 results on 1 pages for 'linchi shea'.

Page 1/1 | 1 

• Sybase ASE

  - by Linchi Shea

  I sat in a Sybase ASE class last week for five days. Although it didn't cover the more advanced features introduced in the more recent versions of Sybase ASE, the class did touch all the basics of administering Sybase ASE. While I was successful in suppressing any urge to openly compare Sybase ASE with Microsoft SQL Server in the class, I could not…

  Read the article

• Performance impact: What is the optimal payload for SqlBulkCopy.WriteToServer()?

  - by Linchi Shea

  For many years, I have been using a C# program to generate the TPC-C compliant data for testing. The program relies on the SqlBulkCopy class to load the data generated by the program into the SQL Server tables. In general, the performance of this C# data loader is satisfactory. Lately however, I found myself in a situation where I needed to…

  Read the article

• Linked servers and performance impact: Direction matters!

  - by Linchi Shea

  When you have some data on a SQL Server instance (say SQL01) and you want to move the data to another SQL Server instance (say SQL02) through openquery(), you can either push the data from SQL01, or pull the data from SQL02. To push the data, you can run a SQL script like the following on SQL01, which is the source server: -- The push…

  Read the article

• Survey: How do you manage the source code for your personal projects?

  - by Linchi Shea

  This seems to be the survey season. Andy’s post on source controlling T-SQL code triggered a question that I always wanted to ask. Do you version control the source code for your various personal projects (i.e. not projects of your customer or employer)? Do you use a computer at home for your source control repository, or do you use a…

  Read the article

• SQL Trace challenge: a simple requirement

  - by Linchi Shea

  SQL Trace (or SQL Profiler) is no doubt an excellent tool. But its filtering capability is rather primitive, and is very poorly documented. Here is a request that is simple and seems to be rather reasonable. Create a trace to filter for the following: 1. All the update/delete statements, and 2. All the select/insert statements whose…

  Read the article

• Table or index that goes nowhere

  - by Linchi Shea

  SQL Server allows you to create a table or an index on a filegroup that has no file assigned to it. Because there is no data file to hold anything, the table or the index thus created cannot be used. This may not be a problem because often you would probably use the table or the index 'immeidately', and would realize the problem.…

  Read the article

• Prevent users from Router 2 seeing Router 1 computers

  - by Patrick Robert Shea O'Connor

  I've got 2 Netgear N300 (WNR2000v3) routers. Here's my setup: Modem Router 1 Private Users/Router 2 Public Wireless Users on "Guest" Network. I want to prevent users who are connected to Router 2's "Guest" network from accessing anything that is connected to Router 1. There is an option when setting up the "Guest" network…

  Read the article

• Cherrypy web application won't communicate outside localhost via VPN

  - by Geoffrey Shea

  I'm trying to run a Python2.7/Cherrypy web server on Win 7 which is connected to a VPN to establish a dedicate IP address. (If I run the exact same application on Win XP connected to the VPN it works fine.) On Win 7 I tried configuring it to use port 8080, 8005, or 80 with no improvements. I turned off Windows Firewall…

  Read the article

• Xcode Disable Colon-aligning Auto-indent

  - by Andy Shea

  Is there any way to disable the auto-indent Xcode performs to align colons when breaking up a long method name into multiple lines? That is, I'd rather not have this: UIBarButtonItem *longDescriptiveButton = [[UIBarButtonItem alloc] initWithTitle:@"Title of Button" …

  Read the article

• Retrieve Core Data Entities in Order of Insertion

  - by Andy Shea

  Is there an internal ID variable or timestamp I can use in a NSSortDescriptor to retrieve Core Data entities in the order they were inserted? I would rather not have to create such properties if there is a cleaner way, though will obviously do so if there are no other alternatives.

  Read the article

• Does MATLAB perform tail call optimization?

  - by Shea Levy

  I've recently learned Haskell, and am trying to carry the pure functional style over to my other code when possible. An important aspect of this is treating all variables as immutable, i.e. constants. In order to do so, many computations that would be implemented using loops in an imperative style have to be performed…

  Read the article

• Strange behavior with Javascript's __defineSetter__

  - by Shea Barton

  I have a large project in which I need to intercept assignments to things like element.src, element.href, element.style, etc. I figured out to do this with defineSetter, but it is behaving very strangely (using Chrome 8.0.552.231) An example: var attribs = ["href", "src", "background", "action", "onblur", "style",…

  Read the article

• Fast parsing of PHP in C#

  - by Jessica Shea

  Hello there, I've got a requirement for parsing PHP files in C#. We essentially require some of the devs in another country to upload PHP files and once uploaded we need to check the php files and get a list of all the methods and classes/functions etc. I thought of using a regex but I can't workout if a function…

  Read the article

1