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 Systems Engineer - V.L.S Systems Inc - Peoria, IL
(Indexed 2010-09-06):
As a SQL Server Systems Engineer Consultant, you will... skillsExtremely strong SQL Server Skills.Database ClusteringPerformance tuningSQL Operations and... From Net Temps - 06 Sep 2010 04:40:56 GMT - job details - View all Pe...(truncated)...
Data Warehouse, Sql Server, Jasper, Business Intelligence - Harrison Reed Computer Consulting - White Plains, NY
(Indexed 2010-09-06):
experience 5+ years SQL server experience or similar database development experience SQL 2005/2008... and physical design for SQL server data warehouses... From Net Temps - 06 Sep 2010 04:39:01 GMT - job details - View all Whi...(truncated)...
SQL Server Developer - Info Technologies, Inc. - Pennsylvania
(Indexed 2010-09-06):
# : 10-05717 Title : SQL Server Developer Location... 2010 / 08/30/2011 Description REQUIRED SKILLS: MS SQL Server 2005 &/or 2008, good communicator, organized... From BusinessWorkforce.com - 06 Sep 2010 03:03:36 GMT - job details ...(truncated)...
SQL Server 2005/2008 Developer - Info Technologies, Inc. - Jacksonville, FL
(Indexed 2010-09-06):
of Microsoft SQL Server 2005 or 2008. He/She must have previous experience on working with SQL Server in a... Skills: SQL Server 2005/2008, T-SQL Programming Plus... From BusinessWorkforce.com - 06 Sep 2010 03:03:39 GMT - job details ...(truncated)...
SQL Server DBA - iStaff - Atlanta, GA
(Indexed 2010-09-05):
SQL Server DBA - with some development experience Duties and Responsibilities: Assisting in... which includes: o The server is running with optimal... From HAH - 05 Sep 2010 03:42:07 GMT - job details - View all Atlanta jobs
Sr. BI Architect - SQL Server - Fort Lauderdale, FL
(Indexed 2010-09-05):
Reporting Services,DBA developer, senior DBA, database, applications DBA, SQL data warehouse, ETL The role of the Senior Architect, Business Intelligence is to... From Asian-Jobs.com - 05 Sep 2010 03:35:27 GMT - job details - ...(truncated)...
SQL Server DBA - Washington, DC
(Indexed 2010-09-05):
SQL based programs/Stored Procedures to generate XML files in the Production SQL Server 2005 database... SQL Server 2005 using SSIS/Informatica and SQL Server... From Asian-Jobs.com - 05 Sep 2010 03:31:00 GMT - job details - V...(truncated)...
Jr - Mid MS SQL Server DBA - Atlanta, GA
(Indexed 2010-09-05):
administration of SQL Server 2005 and 2008 systems... of three years work experience with SQL 2000/2005/2008 and T-SQL development. * Proficiency in database... From Asian-Jobs.com - 05 Sep 2010 03:31:14 GMT - job details - Vi...(truncated)...
SQL Server 2005/2008 Developer: Boston - AVID Technical Resources - Massachusetts
(Indexed 2010-09-04):
aSQL Server 2005/2008Developer that is focused on SQL Development and has strong Database and SQL Server... of mainstream RDBMS (SQL Server, Oracle) and the... From LuckyDogJobs.com - 04 Sep 2010 05:45:22 GMT - job details - V...(truncated)...
SQL Server Reporting Services - Vayu,Inc - Richmond, VA
(Indexed 2010-09-04):
SQL Server Reporting Services solutions. Individual must have track record in these areas: SQL Server... configure and deploy the SQL Server Reporting Svcs... From Vayu,Inc - 04 Sep 2010 04:10:40 GMT - job details - View all R...(truncated)...