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

Back in the Office

It's been 7 weeks since I've been back in my office. I spent six weeks on a sabbatical and as soon as that ended, I flew to the UK for a visit to the Red Gate offices and then SQL Bits.

Steve Jones from SQLServerCentral.com

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

Back from Sabbatical

It's been a little over six weeks since I last logged into SQLServerCentral, but I'm back from my sabbatical. Relaxed, refreshed, charged, and ready for work. And back to work it is, with my sabbatical ending with a trip to the UK for a few days at the Red Gate office and then speaking at SQL Bits. It feels like the start of a race, going from zero to full speed as fast as possible.

I'm ready to come back to work. I enjoyed the time off, and certainly had the chance to view the world in a much different light, interacting with people and projects in a way I haven't done in decades. But I also realized that the SQLServerCentral, and larger SQL Server/#SQLFamily, communities are close and engaging in a way that I don't see in the rest of the world. We have something special in our little technology niche, and I hope all of you appreciate it.

The time off also helped verify something I've thought for a long time: Red Gate is a fantastic company. The highest complement I could pay the is that they run the kind of company I'd want to run if I started another business. Talking with so many people from other industries and companies exposes the contrast in just how much difference a good company makes to a job.

The sabbatical is a nice perk, and one I'd certainly recommend to employers that really care about retaining their employees. I'm not confident many managers will agree, but I'd say that it's just the type of refreshing break that might help you get better work from those you depend on use their minds to grow your business.

Steve Jones from SQLServerCentral.com

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

ADVERTISEMENT
Just Azure

Getting started with Microsoft Azure Diagnostics?

Read Michael Collier’s free article to get tips and advice on Microsoft Azure Diagnostics, including using the Diagnostics Agent and how to extract the data. Read the article here.

SQL Monitor

An accidental DBA? Try SQL Monitor

Use the 30-day full product free trial to get easy-to-understand insights into SQL Server, and get suggestions on how to solve the type of issues that are uncovered. Begin your free trial.

SQL Developer Bundle

10 must-have SQL Server tools

The award-winning SQL Developer Bundle contains 10 tools for faster, simpler SQL Server development. Download a free trial.

Featured Contents

 

Data Mining: Part 12 DMX for Data Mining

Daniel Calbimonte from SQLServerCentral.com

In this lesson we will learn the basics of DMX and create some samples. More »


 

13 Questions about SQL Server Data Types You were Too Shy to Ask

Additional Articles from SimpleTalk

Although SQL Data Types seem to cause a lot of grief for database developers and can be tricky in their use, we seem to be expected to know all about them, and so it is embarrassing to ask questions about them in forums. Rob Sheldon continues in his mission to answer all those questions that we hesitate to ask. More »


 

SQL in the City: Save the Date

Press Release from SQL in the City

SQL in the City is coming back to London and Seattle in 2014. The London event will take place on October 24 (before Tech Ed Europe) and in Seattle on November 3 (before PASS Summit). Keep an eye on the event website and @redgate for updates. More »

Question of the Day

Today's Question (by Steve Jones):

Can I create a regular table in tempdb?


use tempdb;
go
create table MyTable
  (
    myid int
  , mychar varchar(200)
  );

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

SQL Server 2012 AlwaysOn Joes 2 Pros®: A Tutorial for Implementing High Availability and Disaster Recovery using AlwaysOn Availability Groups

SQL Server 2012 brought in some great new features and one of the important ones is scalability and performance via AlwaysOn. AlwaysOn is a superset feature and is a combination of many things you will learn about. As the language suggests, this technology achieves a SQL Server infrastructure that can be "always on". For businesses that run 24x7 downtime means the loss of business. This type of risk is out of the question for these businesses. This book discusses in detail the concepts of SQL Server AlwaysOn starting from the basics.

 

Yesterday's Question of the Day

Yesterday's Question (by Phil Factor):

A database that is important to the organisation has become damaged and gone offline. You have the task of recovering it. You determine that it is set to the full recovery model, has a weekly full backup, and a daily differential backup. In addition it has an hourly transaction log backup. What should be the first step in recovering this database?

Answer: Try to take a tail-log backup by using the WITH CONTINUE_AFTER_ERROR option

Explanation:

If a database is offline and fails to start and you need to restore the database, first back up the tail of the log. Because no transactions can occur at this time, using the WITH NORECOVERY is optional. If a database is damaged, try to take a tail-log backup by using the WITH CONTINUE_AFTER_ERROR option of the BACKUP statement. (The NO_TRUNCATE option of BACKUP LOG is equivalent to specifying both COPY_ONLY and CONTINUE_AFTER_ERROR. COPY_ONLY specifies that the backup is a copy-only backup, which isn't a requirement here.)

If a tail-log backup cannot be created, any transactions committed after the latest log backup are lost.

(The TRUNCATE_ONLY isn't part of a restore procedure and has been discontinued.)

See:


» Discuss this question and answer on the forums

Featured Script

Object dependencies in xml format

Peter Sloboda from SQLServerCentral.com

Since we have sys.dm_sql_referenced_entities, dynamic view, which contains the dependency tree, I gave it a try and used it to display all objects in xml format.
The stored procedure uses the view to retrieve the hierarchy, stores it in a table (#tree) which is later traversed using recursive CTE.
Just create the stored procedure, pass it an object name and expand the xml result.
I didn't include check for the level of recursion, but we all know that it'll break if the depth reaches 32. I don't mean to preach, but if any of your sql objects have dependency that deep, you're in trouble.

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

News::: The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

HD PV@@@ The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

PC@@@@ The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

Today Gane??????? The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

WatcH@@@ The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

HD Live$$$$$ The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

pc.... The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

enjoy&&&& The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

Tiger woods Final>>>The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

2014 Final golf^^^ The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

FREE Liverpool>>>>> The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

Final game :The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

MatcH starT??????????? The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

softer Live??????? The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

PLay!!!!!!!!! The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

Golf!!!!! The Open Championship Live - I think, your are surfing internet for get your favorite teams match The Final game Open Championship live Royal Liverpool...

Final golf>> ((skb)) The Open Championship live - Welcome To join here for watching!! Final Golf 2014 You Are Most welcome to watch and enjoy Golf your are...

What is Automation in sql server? - What is Automation In SQL Server


SQL Server 2012 : SQL 2012 - General

dk will take a look at it - https://www.facebook.com/battlegroundthemoves http://www.reddit.com/r/crossingconel/comments/2b7g32/watch_wwebattleground2014livestreamonlinefree/ http://www.reddit.com/r/crossingconel/comments/2b7g32/ http://www.reddit.com/r/crossingconel/comments/2b7g94/watchwwebattleground2014livestreamfreeonline/ http://www.reddit.com/r/crossingconel/comments/2b7g94/ http://drupalladder.org/lesson/

DR Approach - Hi, In my new environment we have very big database. This is my first time working with large database. They asking...

android sets iPhone cloning factory - [url=http://www.reddit.com/r/day4/comments/2b7285/]2014 British Open Live Stream[/url]

Suggestions on how to improve this View that is using correlated subqueries - Hello everyone, Can anyone please suggest me on how can I avoid using correlated subqueries in the following create view statement:...


SQL Server 2012 : SQL Server 2012 - T-SQL

the top honors - [url=http://drupalladder.org/lesson/6918b69c-06eb-471f-ba34-63ef1ff42045]WWE Battleground 2014 Live Stream[/url]

XML Query Help - I have four tables and I want to create one XML file. I provided the temp tables with data and...


SQL Server 2008 : SQL Server 2008 - General

Transaction log full in sql server 2008 - I read the following artticle from MSDN for resolving transaction log issues if it becomes full. I am a sql server...

not sure why DBCC CHECKDB is running - Hi, I have no maintenance plans scheduled to run.. but I can see dbcc check running on all my users...

let's have a look - [url=http://www.reddit.com/r/imt39/comments/2b85b7/]WWE Battleground 2014 Live Stream[/url]

rewards can be enormous - [url=http://www.reddit.com/r/ten71/comments/2b74m5/]British Open 2014 Live Stream[/url]

The Open Golf Championship Live - Welcome to Watch THE OPEN LIVE | Open Golf Live Stream which will scheduled this July & broadcast by ESPN| 2014 Open...

Watch The Open Golf Championship Live Stream online - Welcome to Watch THE OPEN LIVE | Open Golf Live Stream which will scheduled this July & broadcast by ESPN| 2014 Open...

The Open Golf Championship Live Stream - Welcome to Watch THE OPEN LIVE | Open Golf Live Stream which will scheduled this July & broadcast by ESPN| 2014 Open...

Full Text Search Problems - Hi I have a single table which I populate periodically from other tables, and then I have a full text index...

How to efficiently import data in .rpt format into SQL 2008 - Good day, I have been told to import 100G data generated in SSMS and in .rpt format (10+ files) back to...

The same index but different fragmentation number - Hi All, I wonder why I got data that consist of the same index name with the same table and schema...

delete large chunk of data on replicated DB - Hi, I have 4 SQL Servers 2008 with a merge replication. Replication runs every 10 minutes. Now, my client asked me to...

SQL Server Agent running powershell commands - Hi All, I am trying to run the following powershell script as a job from SQL server Agent (2008 R2),...


SQL Server 2008 : Working with Oracle

mac os server - http://drupalladder.org/lesson/ef5935f0-70fc-4ac9-8c35-a2b5ecf82f29 http://drupalladder.org/lesson/ddaed2cc-ff70-4407-a9ab-839646e499e4 http://drupalladder.org/lesson/4de4042d-349f-47f2-a07c-ad6d7d86b1cc http://www.sahra.org.za/organisations/free-watch-purge-anarchy-2-full-movie-online-2014 http://www.sahra.org.za/organisations/free-watch-dawn-planet-apes-full-movie-online-2014 http://www.sah

eror finding - http://drupalladder.org/lesson/ef5935f0-70fc-4ac9-8c35-a2b5ecf82f29 http://drupalladder.org/lesson/ddaed2cc-ff70-4407-a9ab-839646e499e4 http://drupalladder.org/lesson/4de4042d-349f-47f2-a07c-ad6d7d86b1cc http://www.sahra.org.za/organisations/free-watch-purge-anarchy-2-full-movie-online-2014 http://www.sahra.org.za/organisations/free-watch-dawn-planet-apes-full-movie-online-2014 http://www.sah


SQL Server 2008 : SQL Server 2008 High Availability

Peer to peer replication - How can I disable P2P replication logging to SQL Server Error Log Thanks Omar


SQL Server 2008 : SQL Server 2008 Administration

How can we DBAs get alerts when SQL resources don't come online after a cluster failover ? - Hi All, How can we DBAs get alerts when SQL resources don't come online after a cluster failover ? Can we set...


SQL Server 2005 : SQL Server 2005 Integration Services

Importing Poorly Formatted Text File - I am trying to import a text file to a SQL server table using SISS. I use SSIS but this...


Data Warehousing : Integration Services

Create SQL table from an Excel spreadsheet - Is there a way using SSIS to create a SQL table based on the headers of an Excel workbook/sheet? The table...


SQLServerCentral.com : Anything that is NOT about SQL!

Anyone going to SQL Bits 17-19 June Telford ICC, UK - Is anyone going to SQL bits who would like to meet up on the Wednesday or Thursday. @Gail - I know you...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


Career : Employers and Employees

Definition of a Database Architect - Been a loooong time since I last came here, seems like forever and yet remarkably familiar. Anyways, really got my curiosity...

This email has been sent to {user_email}. 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 ©2014 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com