SQLServerCentral - www.sqlservercentral.com

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

The Voice of the DBA

The Vacation Struggle

It's a little over halfway through the year and once again I'm struggling to get away from work and get through my vacation. It's not that my boss won't give me time off, which is a common complaints from many workers in the technology industry. Instead it's my fault. I've got a lot of ongoing work to get done, various commitments for events, preparation for travel, and most of all, I enjoy my job. I'll add that a few family events have prevented us from executing on vacation plans along the way as well.

Skipping vacation is not the best way to go through your career, and during the last month I've stopped to take stock of the situation and do something about it. I have a generous vacation allowance and there's no need to hoard it, saving for a once-a-year-two-week trip. I have some family coming into town soon, and I booked a few days off while they are here. I've also extended one of my trips, planning on a mini-vacation with my daughter. I plan on saving some days to ski near the end of the year, but I'll also be taking some long weekends and trying to recharge my interest in life, coming back to work refreshed.

It can be hard to plan and take vacation, and I'm sure many of you have tips and tricks that you'll share on how you get away from work and enjoy your life. Many of us see our careers as important, necessary, and hopefully fulfilling, but we also need breaks away from the stress and pressures of work.

We should work in order to live, and enjoy, the rest of our lives. Time with family, friends, hobbies, and more is important. Life passes by quickly, and sometimes unexpectedly. One of the things I've learned as I age is that each day is precious, and that could end at any time. I seem to lose friends and acquaintances  all too frequently. All too often I find people passing that are well below retirement age, which is sad, tragic, and a reminder that life is short.

Take your vacation. Get away from work when you can, if for no other reason than to see what else in the world there is for you to experience.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com with  comments definitely appreciated. Overall RSS Feeds:  

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

 You can also follow Steve Jones on Twitter and find links and database related items and announcements.

ADVERTISEMENT
SQL Data Compare

Save time when comparing and synchronizing database contents

"It has also streamlined our daily update process and cut back literally a good solid hour per day." George Pantela, GPAnalysis.com. Download a free trial of SQL Data Compare now.

SQL Monitor

Check SQL Server performance at a glance

We consulted 1000 SQL Server professionals to make SQL Monitor’s UI as clear as possible. Start monitoring with a free trial.

SQL Developer Bundle

12 essential tools for database professionals

The SQL Developer Bundle contains 12 tools designed with the SQL Server developer and DBA in mind. Try it now.

Featured Contents

 

Sending E-Mail from SQL 2008 Express

Andrew Prisk from SQLServerCentral.com

This article provides a comprehensive solution to sending email from SQL Express 2008 and Express 2008 R2. More »


 

Security for SQL Server User Defined Data Types

Additional Articles from MSSQLTips.com

I have a group of developers that I support and they are reporting they cannot see columns within their tables. I have granted them db_datareader permissions which is a standard at my company for QA environments. Why can't they see their column definitions? Check out this tip to learn more. More »


 

From the SQLServerCentral Blogs - SQL Server – How to change SQL Server ERRORLOG location

Vishal.Gajjar from SQLServerCentral.com

By default SQL Server ERRORLOG is stored in "C:\Program Files\Microsoft SQL Server\InstanceFolder\MSSQL\Log" folder. The ERRORLOG location is configured as a... More »

Question of the Day

Today's Question (by Steve Jones):

You have enabled TDE on an important database in your organization. While preparing your DR plan, you realize that you need to make backups of certain objects in order to be able to restore your TDE database on a new instance at your remote location. Which objects do you need to back up?

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 2 points in this category: Security.

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

ADVERTISEMENT

SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by RUPESH PATEL):

declare @value int
set @value = 5555555
PRINT CONVERT(varchar(6), @value) 

What will be the output?

Answer: *

Explanation: Since this value exceeds the range of the data type, an asterisk (*) is returned.

Ref: http://msdn.microsoft.com/en-us/library/ms187928.aspx


» Discuss this question and answer on the forums

ADVERTISEMENT

SQL Server 2012 Data Integration Recipes

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.

Get your copy from Amazon today.

Featured Script

Simple and efficient way to split string with seperator

Steven Rao from SQLServerCentral.com

   I have seen too many people write function to split string with loop. This maybe not efficient, especially if you want to apply the function with large tables.
   The function fn_SplitString here is very simple and it is also very efficient. It does not use any looping. So we can apply it to a large table with very good performance. 
   I had few very good experience using similar idea to parse address string with large tables in the past.
    It uses an internal table master..spt_values from SQL server, which is avaliable for all version of SQL server. This table is also available from Sybase. So this same function and same idea will work with Sybase too.
    Currently the function remove the potential empty space at end of begin of the string value, but you may choose not to do that.
     If you prefer not to use internal system table, you can use other ways to generate a table with list of numbers.
     
     The function is easy to use, for example:
     
     select stringNumber, stringValue from fn_SplitString('split;my;string;with;a;separator',';')

       This is what you get as the result:

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 2005 : Administering

Mirroring Standard and Enterprise - I have a pair of 2005 Standard Edition servers setup with mirroring. I want to upgrade to Enterprise so I...

DATABASE SLOW - Hie, can any one help me what are the steps to b take when database is running slow?

Database in Recovery Pending State - One of my databases is in [b]Recovery pending[/b] state. I tried to run an Alter command on the database to...

SQL Server 2005 : Business Intelligence

How to change the connection string of child packages in Execute Package task? - Hi Friends, I am tryting to execute multiple packages so i am using Execute Package Task to run the packages...

SQL Server 2005 : Development

Data in date column to decrement with one - Hi, problem. I have a table that is having composite primary key e.g startdate, counterparty, center, costname, currency, month, year start date...

SQL Server 2005 : SQL Server 2005 General Discussion

how to List out all tables indexes having index fragmentation more than 50% of databases. - HI to every one can any one guide me to find out this if any incident occurred in sql server...

SQL Server 2005 : SS2K5 Replication

Queue reader agent - Hello experts, please let me know how do we check whether queue reader gaent and distribution agent down ? its urgent thanks

SQL Server 2005 : SQL Server 2005 Integration Services

SSIS - Problem import with large column size in XLS - Hey Everyone, I'm having a problem importing an Excel file that has a column with a variable data size but can...

SSIS: Custom Logging Using Event Handlers - hi im trying to create an event lof for when thinks fail in my ssis package im using the following code...

SQL Server 2005 : T-SQL (SS2K5)

Deleted items still appears in output - Hi All, I'm a real newbie in SQL. My job demands me to learn it which I found out to really...

SQL Server 2005 : SQL Server Newbies

Help me buddy's... in sql server 2005 (topic:columns update) - Hi everyone, I would appreciate if anyone help me in this topic.In brief i will describe about my work done; 1) I...

SQL Server 2008 : SQL Server 2008 - General

A little help needed with simple Custom Function - This should be a simple task but I think I'm tripping over the syntax. I have data from a database...

backup via .mdf and .ldf ok? - I was asking the network/system guy whether a third-party app's databases were being backed up. He did some checking and...

how i can identify local windows service that coresponds to sql spid? - Good morning Everyone, Our environment: sql server 2008 r2 sp2 on windows 2008 r2 enterprise sp1, 2 node active/passive cluster; 200...

conditional table selection - how to select particular table after condition is true? i want to select table only if it has rows more than...

Is this a crazy way to migrate from one OS version to another? - I need to migrate all the servers I support from Windows Server 2008, to 2008 R2 by the end of...

How can I find the Total free memory in the windows machine where a sqlserver instances are installed? - Hello, I need to find the free memory in the machine where a SQL server 2008 r2 is installed, and I...

Require help to get number of hits to sql server 2008 R2 in a day - Hello All, Please help me to find out number of hits to sql server 2008 R2 in a day. Thanks, Sumit Rastogi:-)

Update to Base Table from Details Table - Create Table #Customer_Profile_Master1 ( Lnno Varchar(15), Co_apcode_1_categ Varchar(200), Co_apcode_2_categ Varchar(200), Co_apcode_3_categ Varchar(200), Co_apcode_4_categ Varchar(200) ) Insert Into #Customer_Profile_Master1(Lnno) Values ('1') Select * from #Customer_Profile_Master1 Drop table #Temp1 Create...

Analysis Services in Named Instance - I have set up a 2008R2 SQL cluster with several named instances and a default instance. The application using SQL...

Deadlock on Import - Good Day We try to import data into a tabe from a file , but we get deadlocks on insert . We added...

Filegroup - Hi All, Please let me know whether it is possible to use the same secondary filegroup for 2 different databases. I tried...

SSMS - Databases are not Visible - Hi Team, After connecting SSMS [b]'Databases, Security, Server Objects, Management' [/b] folders are not showing in the object explorer, again i...

is there a way to tell when a login was created or revoked? - Hi sqlcentral colleagues - is there a way to tell when a login was created or revoked? I haven't created any...

Extract String between Special characters - Hi All, I have a string like this Building Management - Ex. Existing Facility\Keys & locks\Project Co to ensure that 400 complete...

Data center migration - I hope this forum is "general" enough for this question. I figure most people here have experienced this issue in...

Does anyone have an explanation for this behavior? or another reason to always schema qualify your tables - I was faced this week with a problem. One job was behaving in a odd manner and we could not...

how to modify sql job to remove extra information coming in text file - I am exporting the sql query result set to a text file and its writing without the issue, i want...

Insert bulk failed due to a schema change of the target table. - Hello Expert. First time I used sqlbulkcopy its performance is impressive, however my application threw a SQL exception after processed about...

Red lines under third occurance of a table name - Hello. I have an annoying problem and I can't find anything about it. In scripts I have, that are templates created...

linked server issue - Hi Can anybody advise on the following error : [quote]OLE DB provider "SQLNCLI10" for linked server "server1" returned message "The partner transaction...

Updating SQL table using SSRS - Hi everyone I have the following table in sql server: CREATE TABLE [DBO].[SHIFTS] ( [WEEK_ENDING] DATETIME NULL ,[FORENAME] VARCHAR(50) NOT NULL ,[SURNAME] VARCHAR(50) NOT...

calculate working hours between 1 year ? - I have limited table like : FUL NAME DATE ali sever 01-01-2013 12:50 ali sever 01-01-2013 18:30 ali sever 01-01-2013 15:30 ali sever 01-01-2013...

SQL Server 2008 : T-SQL (SS2K8)

Group by and Where filters - I have a query that seems to operate differently than I though SQL handled Group By with Where... I thought WHERE...

passing different values into a variable - Hi I have a an SP that returns the size of the backup files into a table. To execute the Sp...

stored procedure keeps spinning - hi when i run sp in 1 server it keeps spinning and on other server i am getting result what could be...

Check series is valid or not - Hi, I have a scenario in which I have to check that whether I am correct no of series or...

How to add IDENT_CURRENT for foreignkey in procedure? - Hai friends, I ve the table like create table travel_request ( request_id int identity primarykey, travel_purpose varchar(10), total_amount varchar(10) ) and one more...

Store Procedure running slow - Hi Experts, I have a Store Procedure which is running slow in Prod but running fine in Stage. I have rebuild...

Check if Function EXISTS before adding - I'm trying to write of script that checks if a certain Function exists, and if it does not, create it....

blocking remove - hi i am adding new column with default value this table has millions of rows, so while i am executing my query...

Make the formula configurable (can use in different SSIS packages) - I have to use same formula to fill the calculated data in different tables. I want to make this formula...

SQL Server 2008 : Working with Oracle

Cannot convert between unicode and non-unicode string data types - I am working on an SSIS project, to pull data from Oracle 10.2g into SQL Server 2008R2, 64-bit. This project...

SQL Server 2008 : SQL Server Newbies

how to add output parameter to existing sproc - I have been given a sproc which needs to have an output parameter added. It is the the line @UpdBearingStatusComplete INT...

Conversion failed due to datatype. - Hi, I am trying to generate ids as"Compidentity" as varchar . If the record is inserted with productcode- " Health" Column with value H1...

Migration of Maintenance Plans - Server to Server - Hi All, I have setup some Maintenance plans over time and now am looking at installing a replacement server. Is there an...

Invoke Batch file from Remote machine - Hello, I have created a batch file to restart one of the SQL Server service and I would like to invoke...

INSERTING PROBLEM - CREATE TABLE MYTABLE ( NAME NVARCHAR(MAX), ID INT ) INSERT INTO MYTABLE(NAME,ID) VALUES('AAA',1) INSERT INTO MYTABLE(NAME,ID) VALUES('AAA',2) INSERT INTO MYTABLE(NAME,ID) VALUES('AAA',3) so the output is, NAME ID AAA...

Count value once in 30 days - Hello, If I have a customer respond to the same survey in 30 days more than once, I only want to...

non identity auto increment field - Hi all, I"m very new to SQL and have been searching the forums but haven't found what I'm looking for....

Dynamic WHERE statement if stored procedure parameter is null - I have the stored procedure with @StartDate and @EndDate parameters my WHERE statement is using those parameters to filter out data WHERE...

Query Reporting Services subscription start time? - Hi All - I'm trying to gather information regarding the schedules for my subscriptions. Some of the data I need is...

SQL Server Agent won't start - The system cannot find the file specified - Hi, For a while now we have been running SQL for our ERP system. Recently i have noticed that a rebuild indexes...

Upgrade SQL Server 2000 to SQL Server 2008 - I'm looking to upgrade 4-5 SQL Server 2000 database instances to 2008. Most are SP3 but one is RTM. Upgrade...

SQL Server 2008 : SQL Server 2008 High Availability

Should development environment be close or exact to production? - If you have production environment that is a fail over cluster is it a best practice to have your development...

SQL Server 2008 : SQL Server 2008 Administration

SQL Server Memory Usage - I observed that in my Production Server (SQL Server 2005) PF Usage: 496 GB Total RAM: 511 GB Available RAM: 8 GB Database...

Piecemeal restore takes forever - Hi Everyone I have a 1.1TB database with 700GB of data on a SQL Server 2008 R2 SP1 instance. Most data...

Frozen process - Hi, I have a process in "killed/rollback" state for a long time. I found two workarounds for this: 1. Restart the SQL...

Upgrade from Sql 2003 to Sql 2008 - Hi, We are planning to upgrade from Sql 2003 to Sql 2008 and I would like to know what needs to...

Maintainance Plan for my DB - hi all please help me to create good performance plan for my database.In SQL default maintenance plan are there but...

Programming : General

If Statement in a View/Query - Hello, I would like to create a SQL query that will make a decision based on date. For example, if the...

Trying to incorporate a Database Abstract Layer... - I have a goal of creating a Database Abstract Layer (stored procedures and maybe views) as long term project, in...

Programming : Powershell

Powershell script being run as SQL agent job - Hi everyone. I have a powershell script that lists all backup status across various servers. Script runs fine via Powershell gui (Normally)...

SQLServerCentral.com : Anything that is NOT about SQL!

Hyper-V or VMware VDI - We are in the planning phase of implementing VDI and I have been tasked with proposing either VMWare or Hyper-V....

"Throw it on the Big Screen" Like on NCIS tv show - Ok weird request here; NCIS makes this look easy. we've got conference rooms CPU's and projectors or big screens; one of the screens...

PolyServe replacement options - While it seems HP still has not made the official announcement, some of us have had conversations with HP representatives...

Talking baseball - Okay, a topic that has NOTHING to do with SQL . . . Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...

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...

Reporting Services : Reporting Services

Error creating an Oracle DataSource "OCIEnvCreate failed with return code -1 but error message text was not available." - I have a new Report Server installation 2012 and have been moving my reports from RS 2008 to this new...

How to pass parameters in ssrs 2008 through stored procedure? How to get more than 2lakhs data in ssrs-excel? - Hi All, Good Morning!!! I have a problem in ssrs,please suggest your valuable answers. Problem:- I have one report, in that i'm...

Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent - I am running Reporting Services in SQL Server 2000. Is there any way of giving a subscription job a decent name,...

Reporting Services : Reporting Services 2005 Development

How to repeat the two tables in each page of ssrs report - Hi In my report i created two tables with same dataset. second table contains multiple rows.so am showing the second table data...

Database Design : Design Ideas and Questions

Is it Better to use Multiple DB than Single DB? - Hi In need to design an Enterprise level solution which will contain around 8 modules (such as Accounting, Human Resource, Inventory,...

Data Warehousing : Integration Services

Failed to acquire connection (loop container) - I am getting this error half way through the loop container in SSIS, why would it fail connection after certain...

Source data in multiple languages - Hi, confusing myself with possible options for this scenario - Reporting from our DW must be in both English and French, therefore...

Load in different table base on different number of columns in text file. - I have 1000 text files in one folder, text files have 2 or 3 or 4 column. Now I need...

No Columns returned by the query - I was facing an issue while exporting data to a flat file from OLEDB source which contained a stored procedure,...

Data Warehousing : Analysis Services

SSAS ROLES (Dimension Data MDX EXPRESSION) - hi all, Need some help using the mdx expression for dimension data in SSAS Roles. the question is...... in my cube,i got 2...

mdx calculated measure issue - Hi everyone, I have wriiten 2 calculated measures for my cube.. my cal measures are: create member [Measures].[A] as iif([measures].[sales]=0,NULL, [measures].[Latencydays]/[measures].[sales]), visible=1 create member [Measures].[B] as iif([measures].[Responses]=0,NULL, [measures].[Latencydays]/[measures].[Responses]), visible=1 but results...

calculated measure in mdx - Hi everyone, I have wriiten 2 calculated measures for my cube.. my cal measures are: create member [Measures].[A] as iif([measures].[sales]=0,NULL, ([measures].[Latencydays]/[measures].[sales]), visible=1 create member [Measures].[B] as iif([measures].[Responses]=0,NULL, ([measures].[Latencydays]/[measures].[Responses]), visible=1 but results...

Row Header are not display - Hello, I write a MDX like this WITH MEMBER [CPM] AS [Measures].[Net Budget]/[Measures].[grp1] SELECT NONEMPTY( {[MASTER Country 1].[Country Name].Members * [MASTER Company].[Company...

Problem to add Dimension with relation table - Hello, I am very new to SSAS and trying to make some mdx. I am stuck in some problems as follows I...

what is the best impersonation options for data soruces to avoid Development to production migration of SSAS cubtes. - [font="Tahoma"]Hi All, I am new to SSAS and its been difficult in visualizing the way impersonation works from Development Environment to...

Data Warehousing : Data Transformation Services (DTS)

using single DFT can we load multiple excel files into table. - Hi All, My Name is vivek,i have few doubts below any one know to how to resolve please let me know. 1).I...

Microsoft Access : Microsoft Access

Viewer for MS Access 2010 Web Database - Hi, Does anyone know if there is a MSAcess viewer (runtime) that can be used to open a Web database? I know...

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 ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com