joewebb
Name: joewebb
Score: 42
Last Seen: 359 days, 5 hours, 12 minutes ago
Member Since: 27 July, 2009
SqlServerKudos
atom rss
3
kudos
spam Kudos Remove

The effects UNION in a SQL query « WebbTech Solutions

published 352 days, 3 hours, 44 minutes ago posted by joewebbjoewebb 359 days, 6 hours, 4 minutes ago
Thursday, August 13, 2009 4:13:26 PM GMT Thursday, August 06, 2009 1:52:30 PM GMT
In a recent blog, I shared some of the natural but sometimes unanticipated consequences of adding DISTINCT to a SELECT statement. Adding DISTINCT ensures that you don’t have duplicated rows in your result set, but that assurance comes at a price. Performance is typically impacted negatively when you add DISTINCT to a query. You can read the blog and see the proof here. But there is another operator that can have some not-so-obvious side affects. Let’s a have look how UNION can affect a query’s performan... (more)
category: Query | clicked: 4 | comment | | source: webbtechsolutions.com
3
kudos
spam Kudos Remove

For shared SQL Server providers : hiding your list of databases from customers

published 368 days, 7 hours, 52 minutes ago posted by sasa 370 days, 14 hours, 23 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Sunday, July 26, 2009 5:33:37 AM GMT
In a shared SQL Server hosting environment, there are several problems that can arise when you let your customers use Management Studio to connect and administer their databases.  In the typical case, you give them a single SQL Authentication username and password, and they are supposed to be able to connect only to their database.  By default, however, Object Explorer and Object Explorer Details will gladly present the entire list of databases on the server.  In this case, not only are you exposing all ... (more)
category: Security | clicked: 8 | comment | | source: sqlblog.com
tags: Database List, Management Studio, Security, Shared Hosting, SSMS