Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

Top new questions this week:

What is the logic behind ISNUMERIC for certain special characters?

The ISNUMERIC function has some unexpected behavior. The MSDN documentation says: ISNUMERIC returns 1 when the input expression evaluates to a valid numeric data type; otherwise it returns 0. …

sql-server sql-server-2012  
asked by Jeroen 9 votes
answered by Paul White 9 votes

What is the minimum required compatibility level to use parallel SELECT INTO?

What is the minimum required compatibility level to use parallel SELECT INTO in SQL Server 2014?

sql-server sql-server-2014 parallelism  
asked by usr 5 votes
answered by usr 4 votes

SQL Server Database File Groups on a SAN: Relevant or Not?

I am about to build out a new SQL Server and I was planning to make extensive use of file groups. I expect heavy growth, and heavy read/write to 5 different databases on this server. I was planning on …

sql-server filegroups san  
asked by OregonDBA 4 votes

SQL Server cluster resource won't come online unless its on port 1433

The 2-node SQL Server 2008 R2 cluster works fine until one of the resources got removed. I successfully added it back. However, the cluster is not able to online the SQL Service unless it is on 1433 …

sql-server sql-server-2008-r2 clustering  
asked by dba 4 votes
answered by Jason Cumberland 1 vote

Replace relational database with "poor" design in software product with non-relational DB?

Think of a software system you look at, based on classic, relational databases (SQL Server, Oracle), NHibernate as object-relational mapper (ORM), a business logic model layer on top and a huge number …

relational nosql database-denormalization orm document-oriented  
asked by Erik Hart 4 votes
answered by Thomas Kejser 4 votes

Find reason long running stored proc SQL Server

I have a stored proc which is called every 2.5 seconds by a program, 24-7. This proc normally runs under the 10 milliseconds. A few times a day (3 -5 times) it takes around 42953 milliseconds to run …

sql-server sql-server-2008-r2 profiler  
asked by pexxxy 4 votes
answered by Remus Rusanu 5 votes

Possible reasons for really long database recovery

This is cross-posted at SSC, but restore is now going on 6 hours. Hello, Overnight I ran restores with NORECOVERY for a 5tb database, along with several other 250GB - 1.3tb databases. I did that …

sql-server sql-server-2012  
asked by sqldriver 3 votes
answered by Max Vernon 2 votes

Greatest hits from previous weeks:

Access denied for user 'root'@'%'

I used to access the root user in MySQL just fine. But recently, I am no longer able to. I am able to login fine : mysql -u root -p Here is the mysql status after login : mysql> status …

mysql authentication users  
asked by jules testard 13 votes
answered by RolandoMySQLDBA 5 votes

How to insert (file) data into a PostgreSQL bytea column

This question is not about bytea v. oid v. blobs v. large objects, etc. I have a table containing a primary key integer field and a bytea field. I'd like to enter data into the bytea field. This …

postgresql  
asked by SabreWolfy 11 votes
answered by Jack Douglas 7 votes

Can you answer these?

Find columns referenced by virtual column expression

Does anyone know of any Oracle dictionary views that hold references of 'real' columns to virtual columns? For example lets say I have a table like this: create table t ( c1 varchar2(5) ,c2 as (c1 …

oracle virtual-columns  
asked by Horrendo 1 vote

I am not able to create/reindex a unique index in a table

I have a table that contains user locations (called public.user_location) and is the following: Column | Type | Modifiers id | …

postgresql index postgresql-9.1 index-tuning postgis  
asked by angelst00ne 1 vote

Implementation of SSL ON SQL SERVER DEFAULT INSTANCE

We've purchased an SSL certificate for our Server with a specific CN and implemented the certificate on IIS. We imported the same certificate on the SQL Server machine. However, when trying to …

sql-server sql-server-2008-r2 ssl  
asked by Harsimranjeet Singh 2 votes
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