Database Administrators Weekly Newsletter
Database Administrators Weekly Newsletter

Top new questions this week:

What's the difference between "expression <=1." and "expression <= 1"?

Reviewing code and a case statement has expression <= 1. as opposed to <= 1 I'm not sure what the purpose of the 1. is. Any thoughts?

sql-server  
asked by Pete Forester 11 votes
answered by mustaccio 18 votes

Is there a cool way of performing CU updates for SQL Server on hundreds of machines?

My company has grown from 50 SQL Servers to over 200 overnight in a merger acquisition. HELP! My questions are: How can I perform CU updates on this many servers and still have a life and keep my ...

sql-server installation automation  
asked by Russ Starksen 8 votes
answered by Shawn Melton 5 votes

SQL Server DB becomes unusable overnight

Yesterday, my SQL Server database was fine. Today it is almost unusable - it's slowed down by a factor of between five to twenty, depending on when I hit it. Some data was added to the server in an ...

sql-server sql-server-2008-r2  
asked by Matt Thrower 8 votes
answered by Ionic 3 votes

Migrating from text and image to varchar(max) and varbinary(max)

I have a SQL Server database which contains a number of image and text columns, and I'm studying potential problems that might arise from migrating them to their non-deprecated counterparts ...

sql-server database-design blob  
asked by Confluence 8 votes
answered by Aaron Bertrand 10 votes

SARG cardinality estimate, why not full-scan?

Why there is no full-scan (On SQL 2008 R2 and 2012)? Test data: DROP TABLE dbo.TestTable GO CREATE TABLE dbo.TestTable ( TestTableID INT IDENTITY PRIMARY KEY, VeryRandomText VarChar(50), ...

sql-server sql-server-2008-r2 sql-server-2012 query-performance  
asked by Jānis 7 votes
answered by Mikael Eriksson 3 votes

Why is SQL Server 2014 consuming so much RAM with no active data stored?

I'm running SQL Server 2014 on my laptop along with a ton of other installed applications, from Visual Studio to video games. This is obviously not a production server, but for development and ...

sql-server sql-server-2014 memory  
asked by Giffyguy 7 votes
answered by Kenneth Fisher 6 votes

How can I combine two event tables into a single timeline, in PostgreSQL?

Given two tables: CREATE TABLE foo (ts timestamp, foo text); CREATE TABLE bar (ts timestamp, bar text); I wish to write a query that returns values for ts, foo, and bar that represents a unified ...

sql postgresql join window-functions  
asked by Christopher Currie 6 votes
answered by Erwin Brandstetter 4 votes

Greatest hits from previous weeks:

What is the difference between Primary key and Super key in DBMS

I am new to DBMS and I am still learning the theory. I am getting really confused with this key business and after googling I have narrowed it down to just 2 keys I dont get (primary and super key) ...

primary-key  
asked by MikeHil 3 votes
answered by Pieter Geerkens 9 votes

Connect to SQL Server with Windows Authentication in a different domain

I am trying to connect to a remote SQL Server on a VPN in a different domain. When I enter the Server name on the SQL Server and choose Additional Connection Parameters to add some extra stuff needed ...

sql-server sql authentication logins  
asked by fxuser 7 votes
answered by Aaron Bertrand 8 votes

Can you answer these?

Percona mysqld got signal 11

I've googled and searched stackexchange, but can't find anything relevant to this particular issue (there are other error 11 issues, just not for this as far as I can tell). We have a server that is ...

mysql-5.5  
asked by Clayton Dukes 3 votes

SSRS - ERROR NUMBER:7357 while passing multiple value parameters using comma delimited string to stored procedure

I am working on a SSRS report to display the logins permissions in a set of databases on a specific server. the server, the logins and the databases are all parameters. NULL shows them all (logins ...

sql-server-2012 linked-server dynamic-sql ssrs-2012 openrowset  
asked by marcelo miorelli 2 votes

Snooping-safe Vote tables

I have a table with both user_id and vote. They are stored together so each user can only give one vote. However it's also problematic because admins can simply read who voted what. Is there a way to ...

database-design security table privileges  
asked by aacom 3 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