(Mohd Manzoor Ahmed) The objective here is to create a country locator in which we have SQL server database with a single table which contains a lookup of locations of all the countries with their associated Latitude and Longitudes. So, the table is to be populated with the following data:
Other News
Why do you need to gather CBO Statistics?
(Carlos Sierra) As I help a peer with a SQL Tuning engagement, I face the frequent case of: “We do not want to gather CBO schema object statistics because we don’t want our Execution Plans to change”. Well, the bad news is that: not gathering stats only gives you a false sense of safety because your
OLTP Compression, Drop Column, Partition Exchange
(Dominic Brooks) With Basic Compression, you cannot drop a column.
Is Oracle Database 12c (12.1.0.2.0) Faster Than Previous Releases?
(Craig Shallahamer) I was wondering if the new Oracle Database 12c version 12.1.0.2.0 in-memory column store feature will SLOW performance when it is NOT being used. I think this is a fair question because most Oracle Database systems will NOT be using this feature.
Making UUID() and RAND() replication safe
(Shlomi Noach) MySQL’s UUID() and RAND() functions both provide with (pseudo) indeterministic result. UUID()’s result is moreover bound to the host on which it executes. For this reason, both are unsafe to replicate with STATEMENT binlog format. As an example, consider:
Determine size of the file using T-SQL/Powershell/Ole Objects
(Prashanth Jayaram) There are many ways to find the filesize.
Versioning In Your SQL Database
(Chris Bell) Now, I’m not talking about version control, I am talking about stamping your database with a version number so you can keep track of how many modifications may be made in an environment not completely in your control.
Installing Teradata Client Tools to use with SQL Server Integration Services
(Junaith Haja) The company where I work migrated their data warehousing environment to Teradata. The requirement is to download and install the Teradata Client utilities to access the newly built data warehouse and to extract data from Teradata to SQL Server using SQL Server Integration Services.
Interesting Animation Effects with WPF
(Peter Shaw) As is often the case with these posts, this one started out as something completely different 🙂 I was going to do a simple post on a nice animated splash screen for your WPF apps, but I got a bit carried away with the animation stuff.
Restricting Columns Retrieved in Entity Framework
(Peter Vogel) A couple of months ago, I wrote a column on how to avoid downloading columns in a table that has hundreds of columns or columns containing large objects (or, at least, only downloading those columns when you want them). But that solution only makes sense when getting the columns you wa