Database Administrators Weekly Newsletter - Friday, February 27, 2015

Top new questions this week: statistics are up to date, but estimate is incorrect When I do dbcc show_statistics ('Reports_Documents', PK_Reports_Documents) I get the following result for Report ID 18698: For this query: SELECT * FROM Reports_Documents WHERE ReportID = 18698 ... sql-server-2008-r2 t-sql index-statistics   asked by user1151923 8 votes answered by Aaron Bertrand 5 votes High PAGELATCH_* and WRITELOG waits. Are they related? We are seeing very high PAGELATCH_EX and PAGELATCH_SH wait types along with high WRITELOG waits. I've diagnosed the query causing the PAGELATCH waits and can eliminate them by reducing the insertion ... sql-server sql-server-2008-r2 sql-server-2012 sql-server-2014 database-internals   asked by Pixelated 7 votes answered by Shanky 0 votes Unable to restore (error 3456) I have a situation that is not easy to figure out, and thought I'd ask on this forum if others might have suggestions. I'm running SQL Server 2008 R2 Standard SP3 on Windows Server 2008R2 Enterprise. ... sql-server sql-server-2008-r2 recovery database-restore   asked by NedOtter 7 votes answered by Thomas Stringer 6 votes What is this upside-down silver key icon I inherited a SQL Server 2005 3rd party server and database to look into to be able to generate reports and dashboards on. On one table, I found a new icon: a blue-silver upside-down key, alongside ... sql-server-2005 ssms   asked by Philippe 4 votes answered by Aaron Bertrand 6 votes Truncating table without using Alter Table permission So my DBA don't want developers to give Alter table permission. Now one of the procedure that we created requires to Truncate tables (since apparently delete only removes records, but truncate frees ... sql-server t-sql alter-table   asked by Vyom 4 votes answered by Remus Rusanu 6 votes Order In WHERE Clause Matter For SARGability? Suppose that I have a table with 1000 records and I have the below query, which would return 7 total records: SELECT * FROM MyTable WHERE IndexedColumn > 5000 AND OtherIndexedColumn = 2 ... sql-server   asked by user541852587 4 votes answered by Aaron Bertrand 10 votes Will dropping text column on SQL Server 2014 lock the table? I have been tasked to drop a text column from a production SQL Server 2014 table. The table contains 61,683,821 records. Question: will dropping the column lock the table (or cause similar ... sql-server-2014 alter-table lock   asked by Bill Gillingham 3 votes answered by Bill Gillingham 0 votes Greatest hits from previous weeks: How can I monitor the progress of an import of a large .sql file? I am importing a 7 GB foobar.sql to restore a table in a local database. $ mysql -h localhost -u root 'my_data' < foobar.sql $ mysql --version /usr/local/mysql/bin/mysql Ver 14.12 Distrib ... mysql mysqldump import   asked by qazwsx 45 votes answered by Rob 50 votes MySQL error: Access denied for user 'a'@'localhost' (using password: YES) I use the root account created the account 'a'@'%'. But I can't use the it to connect to MySQL server when I specify the host parameter. I can successfully connect without the -h parameter. Please see ... mysql authentication   asked by Ogrish Man 9 votes answered by RolandoMySQLDBA 12 votes Can you answer these? Reporting on a normalized Key-Value pivot ERD & SQL Fiddle provided. We're trying to design a reporting tool for our stakeholders around a normalized Key-Value Pair model. We've tried to find a solution using Pivot Tables but can't seem ... sql normalization reporting   asked by Robert Baldini 2 votes Pass a URI as a pgAdmin parameter I can connect to Heroku with psql passing a URI: $ psql postgres://user:password@ec2-54-243-xxx-xxx.compute-1.amazonaws.com:5432/d7xkxididkdi I want to do the same with pgAdmin: $ pgadmin3 -qc ... postgresql linux pgadmin heroku   asked by Clodoaldo 1 vote Simple avg query on large table much slower in PostgreSQL than SQL Server I have a database with three tables items, parameters and measurements in both servers and want to query the measuerment table. But the query is much slower in PostgeSQL (9.4) vs SQL Server (2012). ... sql-server sql postgresql query-performance group-by   asked by Staeff 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