Database Administrators Weekly Newsletter - Friday, June 27, 2014

Top new questions this week: "Cannot create a row of size 8074 which is greater than the allowable maximum row size of 8060" while altering the table I am trying to alter a column in a table. The existing table is like this: CREATE TABLE [dbo].[table]( [id1] [int] NOT NULL, [id2] [int] NOT NULL, [id3] [int] NOT NULL, [name] [nvarchar](255) NOT … sql sql-server sql-server-2012   asked by Sonal Maheshwari 10 votes answered by Paul White 15 votes Performance tuning a Great Circle distance calculation I have a query that I am using to find locations that are within 1km of a known point. To do this, I am using the Spherical Law of Cosines formula with my latitude and longitudes. Currently, the … sql-server sql performance functions tuning   asked by Steve 6 votes answered by Rob Farley 5 votes SQL Server: Are there any performance benefits from indexing a table <8kb in size? If a table is <8kb in size in SQL Server then presumably it is all stored on a single page. Thus - aside from enforcing a unique constraint - is there any performance benefit that could be obtained … sql-server index database-internals   asked by BI Monkey 5 votes answered by Martin Smith 6 votes Virtual Log Files (VLFs) Fragmentation I have a database with 160 VLFs. How do I determine whether the VLFs are fragmented? Further, how do I find the percentage of fragmentation? Another thing that I want to confirm: Are the following … sql-server sql sql-server-2008 sql-server-2008-r2 transaction-log   asked by AA.SC 4 votes answered by Sean Perkins 1 vote SQL Agent Permissions - Job Level We currently have an SQL Job that runs an SSIS package. The output of the package is required for a report. As a result, the application that can create the report on demand first tries to run the … sql-server-2008-r2 security ssis sql-agent   asked by Dave Johnson 3 votes answered by Aaron Bertrand 1 vote Set simple recovery mode and shrink log files for all user created databases I hope you can point me in the right direction. I'm not a frequent user of T-SQL, but I did some googleing, and found the script below. I corrected the script a bit. I want the script to: To select … sql-server-2012 t-sql   asked by Arviddk 3 votes answered by AA.SC 2 votes PostgreSQL custom operator for equality I want to build a custom equality operator in PostgreSQL, which can be used in GROUP BY, UNION and DISTINCT [ON] for the json type (just for the sake of curiosity, not for real-world implementation -- … postgresql postgresql-9.3 json operator   asked by pozs 3 votes Greatest hits from previous weeks: Why shouldn't we allow NULLs? I remember reading this one article about database design and I also remember it said you should have field properties of NOT NULL. I don't remember why this was the case though. All I can seem to … database-design null   asked by Thomas Stringer 44 votes answered by Aaron Bertrand 101 votes "ORA-03113: end-of-file on communication channel" on startup I have been reading posts here, on Oracle support, and anywhere else I can find for the last three days and I've given up on this problem... An Oracle database hung. Shutdown of the database sat for … oracle startup   asked by kainaw 2 votes answered by kainaw 2 votes Can you answer these? Flush procedure cache or drop and create? Okay I had a very strange issue today on SQL Server 2005. We had a stored procedure update that added new parameters to part of it. One database out of ~150 or more seem to not work properly. Using … sql-server-2005 cache plan-cache procedure-cache   asked by David George 1 vote Why does this MySQL date_sub statement return wrong values? I had a complex statement that was returning strange values and I traced it to the following line: SELECT id, updated FROM status WHERE updated > date_sub(NOW(), INTERVAL 6 MINUTE) ORDER BY … mysql datetime   asked by Steve H. 1 vote How to avoid hardcoding a database link name in a package body I have a PL/SQL package that copies data from a remote DB2 database using a database link. To keep the package configuration-independent I wrapped the remote table in a view. But a single field in a … oracle db2 plsql database-link dblink   asked by Alexey 1 vote

Subscribe to more Stack Exchange newsletters Unsubscribe from this newsletter or change your email preferences by visiting your subscriptions page on stackexchange.com. Questions? Comments? Let us know on our feedback site. If you no longer want to receive mail from Stack Exchange, unsubscribe from all stackexchange.com emails. Stack Exchange, Inc. 110 William St, 28th Floor, NY NY 10038 <3