Latest 10 Posts
Database Copy Command & Handling Asynchronous Execution in T-SQL in SQL Azure
Abstract from TSQLNet Weblog - Cihangir Biyikoglu (Indexed 2010-09-01):
Database Copy T-SQL command in SQL Azure, provide the ability to create a identical copy of a database through a pure server side process. You can think of it as a command that backs up a database and restores it at the other end. You can refer to ge...(truncated)...
Slow query performance because inaccurate cardinality estimate when using anti-semi join following upgrade from SQL Server 2000
Abstract from PSS SQL Server Engineers (Indexed 2010-09-01):
We have a few customers who reported that some of their queries run slower following upgrade from SQL Server 2000 to SQL Sever 2005, 2008 and 2008 R2. Specifically, queries experiencing the issue have anti-semi joins in the query plan and the joi...(truncated)...
Optimizing CREATE SET in Cube Calculation Scripts
Abstract from MS SQL Server Development Customer Advisory Team (Indexed 2010-08-31):
Author: Thomas Kejser Reviewers: Peter Adshead, Nicholas Dritsas, Sanjay Nayyar, John Desch, Kevin Cox, Akshai Mirchandani, Anne Zorner In this blog we will describe an important optimization that you should apply to cubes that are processed ofte...(truncated)...
The New World of Work: Unique Tasks
Abstract from Carpe Datum (Indexed 2010-08-26):
In a previous post I mentioned that I’ve seen some Gartner Inc. studies, among others, that state that we’re in a “new world of work”. Since I’ve been working in technology for quite some time, and working around the wor...(truncated)...
SQL Server 2005: Execution Context
Abstract from Laurentiu Cristofors blog (Indexed 2010-08-25):
This post is based on an old presentation I gave several years back. A video of the presentation used to be available here, but today I couldn't get it to work, so I am attempting to make available most of the information from the presentation within...(truncated)...
Query performance and table variables
Abstract from PSS SQL Server Engineers (Indexed 2010-08-24):
Technorati Tags: Performance Frequently, we see our customers using table variables in their stored procedures and batches and experience performance problems. In general, these performance problems are introduced because of large numb...(truncated)...
Why use SQL Server 2008 R2 BPA? Case 1: Missing Updates..
Abstract from PSS SQL Server Engineers (Indexed 2010-08-24):
In June I introduced you to a new Best Practices Analyzer for SQL Server, SQL Server 2008 R2 BPA: http://blogs.msdn.com/b/psssql/archive/2...(truncated)... Ive seen some mixed reaction to this tool. But when I verbally talk to some about the type o...(truncated)...
A combination of crowdsourcing, people helping people, and the best technical community there is
Abstract from Carpe Datum (Indexed 2010-08-19):
I talk a lot about “giving back”. It’s a personal issue with me – I grew up quite poor, and from time to time someone would take notice that my mom and I didn’t have enough to eat, and they would help us out. I’ve ...(truncated)...
How It Works: Timer Outputs in SQL Server 2008 R2 - Invariant TSC
Abstract from PSS SQL Server Engineers (Indexed 2010-08-18):
[Image] I would love nothing more than to take you back to my high-school days running the 440 yard hurdles (yes yards not meters) where timing was done with a stop watch (you know the old, moving dial style) but timers on the PC don't allow th...(truncated)...
Direct Contact with SQL Server's Future
Abstract from Carpe Datum (Indexed 2010-08-17):
Many times I'm asked "does Microsoft ever ask the users what they want in SQL Server"? Yes, we do. A lot, actually. And you can be a part of that conversation. For starters, you can hit the http://connect.microsoft.com site, read up on how it works, ...(truncated)...
View All Posts...
Latest 10 Jobs
SQL SERVER DBA - Beta-Search, Inc. - Hopewell, NJ
(Indexed 2010-09-03):
SQL SERVER DBA'S4 SQL Server DBA's - these are Business applications that will be worked on for performance tuning, volume growth and intergration between... From Net Temps - 03 Sep 2010 05:30:24 GMT - job details - ...(truncated)...
SQL Server Database Administrator - Robert Half Technology - Indianapolis, IN
(Indexed 2010-09-03):
day operations of SQL Server 2005/SQL Server 2008 and... SQL server, data security concepts and Client/Server architecture on SQL Server 2005/SQL Server 2008.2+... From CareerBuilder - 03 Sep 2010 02:56:33 GMT - job details - ...(truncated)...
SQL Server DBA with MS BI Stack - Modis - Denver, CO
(Indexed 2010-09-03):
Location: DenverSQL Server DBA to install/setup/deliver and support Microsoft SQL Server databases and... administration of MS SQL server 2000, 2005 and 2008... From CareerBuilder - 03 Sep 2010 02:40:31 GMT - job details - Vie...(truncated)...
SQL Server DBA - YGC (YouveGotClaims.com) - Pine Brook, NJ
(Indexed 2010-09-03):
Create, modify, and tune SQL Server stored procedures... Highly Desirable Skills: -Knowledge of network and SQL Server administration. -Knowledge of data/folder... From CareerBuilder - 03 Sep 2010 02:36:46 GMT - job details - ...(truncated)...
SQL Server Database Administrator - Green Tree - Saint Paul, MN
(Indexed 2010-09-02):
SQL Server.The position is responsible for installing, configuring, troubleshooting, designing, performance tuning and maintaining Microsoft SQL Server... From Green Tree - 02 Sep 2010 05:40:38 GMT - job details - View all Sai...(truncated)...
Derivatives DBA Manager- Oracle/Sybase/SQL Server - Bachrach Group - Midtown, TN
(Indexed 2010-09-02):
all Oracle/Sybase/Microsoft SQL Server databases and... groups running their databases on Oracle and MS SQL Server for the Derivatives business applications. The... From Bachrach Group - 02 Sep 2010 05:32:40 GMT - job details -...(truncated)...
#13172 .NET Software Developer - C#/WCF/SQL Server - SolutionsIQ - Redmond, WA
(Indexed 2010-09-02):
.NET Software Developer C#/WCF/SQL Server Long-term vendor contract in Redmond Responsibilities... WCF services, C#, ASP.net , T-SQL, SSIS Package, XML... From SolutionsIQ - 02 Sep 2010 05:00:08 GMT - job details - View all...(truncated)...
SQL Server DBA - Ab Ovo, Inc. - Mountain View, CA
(Indexed 2010-09-02):
Over 6 years of SQL Server Development and Database... Support of MS SQL Server 2005 in Production, QA & Development environments. Expertise in MS SQL Server... From Ab Ovo, Inc. - 02 Sep 2010 03:56:23 GMT - job details - View...(truncated)...
SQL Server / Oracle Database Developer - Robert Half Technology - Berkeley Heights, NJ
(Indexed 2010-09-02):
and SQL) Experience writing SSIS packages to Migrated/Transfer Data from SQL Server to Oracle and Oracle to SQL server. Experience in an SAP environment a... From Robert Half Technology - 02 Sep 2010 03:38:19 GMT - job details ...(truncated)...
Sr. SQL Server Solution Engineer - HP - Redmond, WA
(Indexed 2010-09-01):
the SQL Server engineering teams, focusing on server... Desired... SharePoint and SQL Server BI stack expertise... Server and storage performance... From HP - 01 Sep 2010 04:40:28 GMT - job details - View all Redmond jobs