Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

Top new questions this week:

SQL Server UniqueIdentifier / GUID internal representation

A colleague of mine sent me an interesting question, that I can't entirely explain. He ran some code (included below) and got somewhat unexpected results from it. Essentially, when converting a ...

sql-server sql sql-server-2014 uniqueidentifier guid  
asked by EBrown 13 votes
answered by srutzky 15 votes

Moving Databases to New Datacenters

My company is moving our infrastructure to new data center and I am trying to figure out the best way to keep the database on the new server in sync with the current production database until the new ...

sql-server-2005 sql-server-2014 database-migration  
asked by Snake_Plissken 5 votes
answered by Kin 4 votes

Doubts in a Glenn Berry Query ( CPU per Database )

Please, if this is not place to post questions like these, let me know and I will delete it. Inside the Glenn berry's Diagnostic queries, there is a query to show how much CPU a database is using. ...

sql-server-2008-r2 performance  
asked by Rafael Piccinelli 5 votes
answered by Aaron Bertrand 5 votes

Why should I "Avoid partitioning dimension tables" on SQL Server?

SQL Cat have a list of tips titled Top 10 Best Practices for Building a Large Scale Relational Data Warehouse. Under section 4 - Design dimension tables appropriately they state: Avoid ...

sql-server database-design partitioning data-warehouse  
asked by futureSPQR 5 votes

SQL Server Backup Schedule Overlap

I have a SQL SERVER DB that i want to backup via automated schedule (using GUI maintenance plan) . I have 2 choices when configuring a schedule : 1) do not bother about log backup , full backup and ...

sql-server backup  
asked by Java Main 5 votes
answered by Shawn Melton 4 votes

sa doesn't have permissions to other database through synonyms with the Service Broker

I've been trying to get this Service Broker and timers thing to work for over a week straight now, so bear with me if this comes off as.. uh.. ragey. I'm also fairly inexperienced when it comes to SQL ...

sql-server-2014 service-broker  
asked by Brandon 4 votes
answered by Kin 2 votes

Does index rebuild time depend on the fragmentation level?

Is the required time for index rebuild dependent on the level of fragmentation? Does the rebuild of a 80% fragmented index approximately take 2 minutes if the rebuild of the same index fragmented ...

sql-server-2008-r2 index maintenance fragmentation  
asked by Magier 3 votes
answered by Stoleg 3 votes

Greatest hits from previous weeks:

ALTER TABLE - Rename a column

This got me nuts! I want to rename a column from read-more to read_more in blog table Tried all this: ALTER TABLE blog RENAME COLUMN read-more to read_more; ALTER TABLE blog CHANGE COLUMN ...

mysql mysql-5.5 mysql-5  
asked by Bojan 13 votes
answered by GhostGambler 14 votes

How do I list all columns for a specified table

I'm looking for a precise piece of information in a database which I have no knowledge about. It's a 3rd party product, they are slow on answering some questions, and I know the data is lying inside ...

postgresql information-schema catalogs  
asked by Stephane Rolland 50 votes
answered by bhamby 68 votes

Can you answer these?

possible to order a result by an array intersection count in postgres 9.4

I'm interested in having an array of intergers like user_ids_who_like and provide an array of users (like users you follow) to sort that intersection. something like: select * from items where ...

sql postgresql  
asked by timpone 1 vote

SQL Bulk Insert Impersonation issue

I am running Microsoft SQL Server 2012 SP on a Windows Server 2008 R2 Standard SP1 box. The SQL Server service is running as a simple windows domain user (nothing special, no admin rights, etc.) I am ...

sql-server sql-server-2012 network bulkinsert  
asked by Jim 2 votes

How Can I Increase Performance of This MERGE Statement?

I have a INSERT INTO/MERGE statement that is part of a stored procedure that needs to be really efficient. The execution plan shows that 90% of the procedure is due to the following statement shown ...

sql-server sql query-performance t-sql performance-tuning  
asked by Ryan 1 vote
Subscribe to more Stack Exchange newsletters

Unsubscribe from this newsletter or change your email preferences by visiting your subscriptions page on

Questions? Comments? Let us know on our feedback site. If you no longer want to receive mail from Stack Exchange, unsubscribe from all emails.

Stack Exchange, Inc. 110 William St, 28th Floor, NY NY 10038 <3