SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

Would You Move For a Job?

Today we have a guest editorial from Andy Warren as Steve is on vacation.

It’s a fun question to ask to help understand where someone is in life and how they see life – would you move for a job? Assuming the salary adjusted for the cost of living is equivalent or better, would you be willing to move to a different place if you saw the right opportunity? That opportunity might be truly more money, a promotion of some type, or maybe the chance to work for a mega company with tons of resources. Or maybe it’s about where – you long for cold weather, or warm weather, urban transit, night life, or something else.

What’s my answer? Nope, not moving for a job. I might at some point (hard to envision!) leave Orlando, but I’d be moving to some place I wanted to go (Sarasota maybe) or at least a type of place I wanted to go (warm weather, sunny). All kinds of factors go into that. Stability for the kids in school, kids being close to grandma, owning a home, family in the area are the obvious ones for me, but if you dig deeper it’s more about how I approach risk and change. I’m not opposed to risk, yet clearly I am! I would see deciding to move and then finding a job to support it as reasonable, but not moving just to take a job. Strange isn’t it?

Years ago I met a friend who travelled a lot and only booked his hotel one night at a time. If he was in town multiple days he would go down each morning ready to check out and would ask if they had the same rate or better for another day. If they did, he would stay and if not, he checked out and then later in the day he’d book a room for that night. I’d find it stressful, he found it invigorating. I have no doubt he would move for a job and if it didn’t work out he would just move again. I admire that confidence and outlook – it’s just not me, at least not yet.

It’s a question with no right answer. Having set some boundaries about re-locating and even commuting limits me, but it does so in a way that supports the things I value. I can see someone else looking at moving as a way to support their values.

What about you? Would you, or have you moved for a job? Was it more or less stressful than expected? Advice for those trying to decide if considering if moving should be an option during their job search?

Andy Warren from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

ADVERTISEMENT
SQL Monitor

How to fix SQL Server deadlocks (without using a hammer)

In this new article, Grant Fritchey talks you through the standard approaches to fixing SQL Server deadlocks – traceflags, extended events, and XPath – then shows you how to fix the problem even faster with Redgate SQL Monitor. Read now.

SQL Developer Suite

9 must-have SQL Server tools

The SQL Developer Suite contains 9 tools for faster, simpler SQL Server development. Download a free trial.

SQL Prompt

SQL Prompt v7 now supports Visual Studio 2015 as well as SSMS 2016

It also lets you create your own placeholders in snippets, open an actions list when you select text in a query, use different tab colors, and find more invalid objects. Find out how. Find out how.

Featured Contents

 

Move an Existing Log Shipping Database to a New Monitor Server

Dane Boulton from SQLServerCentral.com

How to a log shipping database to a new monitor server without removing and rebuilding the log shipping setup. More »


 

Bad Cardinality Estimates from SSMS Plans – Redux

Additional Articles from SQLPerformance.com

Aaron Bertrand shares some insight about early changes to Plan Explorer that help to provide you with the most accurate information we can. More »


 

From the SQLServerCentral Blogs - When a calculated measure is added NON EMPTY stopped working

Sherry Li's BI Corner from SQLServerCentral Blogs

We use NON EMPTY key word on the rows axis to remove rows with NULL values. It works only when all... More »


 

From the SQLServerCentral Blogs - The OUPUT Clause in an INSERT–#SQLNewBlogger

Steve Jones from SQLServerCentral Blogs

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as... More »

Question of the Day

Today's Question (by Steve Jones):

Which of these OpenXX statements is used against a linked server in the FROM clause of a query?

Think you know the answer? Click here, and find out if you are right.


We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: T-SQL.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

ADVERTISEMENT

Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012

Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.

Maximize your performance on the exam by learning how to:

  • Create database objects
  • Work with data
  • Modify data
  • Troubleshoot and optimize queries

You also get an exam discount voucher—making this book an exceptional value and a great career investment.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

What was the code name for the In-Memory OLTP table technology that was built into SQL Server 2014? Hint: This is Greek for hundredfold.

Answer: Hekaton

Explanation:

The code name was Hekaton, which is Greek for hundred or hundredfold.

Ref: https://en.wikipedia.org/wiki/List_of_Microsoft_codenames#SQL_Server_family


» Discuss this question and answer on the forums

Featured Script

Querying deadlock graph from SQL Extended Events

Marcelo Fonseca from SQLServerCentral.com

Hello all,

This is my first time writing a SQL Server post.

I was studying last week about Extended Events and wrote this script to help identify deadlocks using the default XEvent system_health.

I'd like to share it and I'd appreciate if anyone could add suggestions, improvements or fix something, because I haven't tested it on many scenarios.

Basically, all you need is to force a deadlock error and run the script on SQL Server 2008+ filtering by date (if you want) and collect the results. It may take a few seconds to show the new event.

If the object name and/or index name were not shown, you can use the hobt_id value to query the object using sys.partitions (also on column hobt id).

I hope it may help anyone.

Marcelo

More »

Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2014 : Administration - SQL Server 2014

Why is this happening? - It's SQL Server Management Studio 2014 http://imgur.com/SlWjziv http://imgur.com/cSVP2IY


SQL Server 2014 : Development - SQL Server 2014

Convert Value Returned by Row_Number() Function to Text Based on Relationship to Overall Result Set - I'm using the SELECT below to pull a list of parts and rank them by the number of times that...

TSQL query to get employee name from employee table by using id from user table - How to write a sql statement that can get the name from employee table by using id from user table...

Need help with shrink - Hello experts, I'd like to setup a job that will take a log backup, and then shrink the log file for...

Where to start? - I've just installed SQL Server Express 2014 on my development machine, and I'm looking at the Management Studio Object Explorer....


SQL Server 2012 : SQL 2012 - General

Count patterns of behaviour in a certain order - Hi, I'm looking for a method to count the number of people in a dataset of Peoples Actions who have completed...

SQL upgrading values in XML - I have created code similar to below. This is slow since this is a very large table. Is there a...


SQL Server 2008 : SQL Server 2008 - General

played for high stakes and it is believed - [url=https://www.reddit.com/live/wotyzd6amnrc]Barcelona vs Real Madrid Live Streaming[/url]

remarkably similar to modern football - [url=https://www.reddit.com/4d2gbv/]El Clasico 2016 Live Streaming[/url]

often on important professional - [url=https://www.reddit.com/live/wotbt75j7iyk]El Clasico 2016 Live Streaming[/url]

By date - I would like to run for 100 days of data. getdate() - 6 april 7april - 14 april and so on.. How can I break into...

Processing strings. - Hello Processing strings. Examples are replace, DelimitedSplit8K. And lots more. What is a good way to process the string, but not process the...

"##MS_PolicyEventProcessingLogin##" errors - I installed the Oracle 11g client on my (Windows 2008 SPK2/SQL 2008 R2) and set up a Linked server to...


SQL Server 2008 : T-SQL (SS2K8)

DDL Trigger for Preventing Sysadmin roles. - Hi All, Can some one provide DDL Trigger script to Prevent Sysadmin Roles. Regards, Shenkar Gade

drop temp table owned in another session - Almost silly question that I'm curious about. Can I drop a local temp table owned by myself in another session? I can't...

Creating a Dynamic Temp Table - We know that a statement like 'SELECT f1, f2, f3 INTO #temp FROM Table1' will create a temp table called...


SQL Server 2008 : Working with Oracle

Oracle BETWEEN DateTime statement - Hello, I've connected to a new database at work via VBA. I've entered SQL script into my VB code and it...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Complicated performance issue - Hi All, We have 2 live environments both with same database structure and application but there is a big difference in...


Data Warehousing : Analysis Services

installation issue-services - Hi all could you please suggest what is the error in installation,all the services are installed but i am unable to...


SQL Server 2005 : Administering

why i can't shrink tempdb data file - Hi, my tempdb database is 30GB(datafile). i try to shrink it with all those options but no luck. use tempdb go DBCC SHRINKFILE (tempdev,5000) go DBCC SHRINKFILE...

This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com