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

Summer, Summer, Summertime

It's getting close to the end of summer, at least for my family. The kids start school activities and sports on Aug 11, so we're just a few weeks away from me starting to wake up early each day and move them around. It's been an amazing summer for me, one that I never would have imagined at the start of the year, and we still have a couple more activities planned.

Most of my summer was my incredible sabbatical, which was the experience of a lifetime. My family had a few other events, and we've got a short vacation planned before school starts. While I'm sure most of you don't have anything like a 6 week adventure away from work, I am hoping you had some memorable times. With that in mind, I wanted a poll away from work this week.

What fun things have you done this summer (or this year) away from work?

Many of you have kids, or at least plan some summertime holiday. We've seen traffic go down at SQLServerCentral, so we know at least a good percentage of you haven't been diving into work each day and continuing your education. I suppose some of you have been working very hard on a project and haven't had time to take breaks to learn something, which is a good problem to have. At least in the short term.

Perhaps you have exciting plans coming up, but in either case, let us know what was a fun break from work this summer.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 2.0MB) podcast or subscribe to the feed at iTunes and LibSyn. feed

The Voice of the DBA 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.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

ADVERTISEMENT

ricky leeks presents
Ricky Leeks on Learning .NET Memory Management
Article 1
Avoiding Garbage Collection
 
  Article 2
Managed / Unmanaged Interoperability
Article 3
WPF and Silverlight Gotchas
 
  Article 4
Top 5 Misconceptions
Article 5
Top 5 Fundamentals of .NET
 
  Article 6
Memory Management Gotchas
Get all six articles in one FREE download.

Featured Contents

 

Exploring Recursive CTEs by Example

Dwain Camps from SQLServerCentral.com

Recursive CTEs can be confusing and scary, so examining some non-standard examples may cast light upon these shadowy demons. More »


 

Why Put Your Database into Source Control?

Additional Articles from SimpleTalk

Checking program code into source control is a daily ritual for most developers, but versioning database code is less well-understood. Grant Fritchey argues that getting your databases under source control is not only vital for the stability of development and deployment, but it will make your life easier when something does go wrong. More »


 

SQL Monitor Custom Metric: WriteLog Wait Time

Press Release from Red-Gate

During a transaction, data is written to the log cache so that it’s ready to be written to the log file on commit, or can be rolled back if necessary. When the log cache is being flushed to disk, the SQL Server session will wait on the WriteLog wait type. If this happens all the time, it may suggest disk bottlenecks where the transaction log is stored. More »


 

From the SQLServerCentral Blogs - SSIS: Value does not Fall Within the Expected Range

Jason Brimhall from SQLServerCentral Blogs

Every now and again I find myself working with SSIS for one reason or another.  Every now and again I... More »


 

From the SQLServerCentral Blogs - Speaker Buddy System

Bill (DBAOnTheGo) from SQLServerCentral Blogs

SirSQL made a rather stirring post recently. He talked about a speaker buddy system to help out new speakers in... More »

Question of the Day

Today's Question (by Sarvesh Gupta):

Which of these describes how a correlated subquery is processed?

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 Execution Plans

SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!

Yesterday's Question of the Day

Yesterday's Question (by Dave):

Evaluate the following statement and choose the most correct answer:

The staging process for importing data with Master Data Services (MDS) in SQL Server 2014 has changed since 2008 R2. You must rewrite 2008 R2 processes or they will fail.

Answer: This is incorrect because the staging process in 2014 has changed but the 2008 R2 processes will still work

Explanation:

According MSDN, the staging process in 2014 has changed but the 2008 R2 processes will still work.

Reference: http://msdn.microsoft.com/en-us/library/ee633726.aspx

Enjoy!


» Discuss this question and answer on the forums

Featured Script

Yet another way to defrag indexes

Gaby Abed from SQLServerCentral.com

Lovingly modified from example D in the world famous dm_db_index_physical_stats books online entry.

By putting the script in an query that can be executed, it lets me pass database names to it, without having to create the proc in each DB.  Feel free to play with the defaults, but these seem to work for us.  Because these are very critical online systems, I have decided to keep the ONLINE=ON setting by default.  But because there are tables that may have column types that can't be built online, such as text or XML, then a TRY/CATCH block switches it to OFF.

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

Experienced Enterprise DBA wanted for 2 - 3 days freelance consultancy in Manchester, UK - We are looking for a DBA to assist us in advising our group on best practices in administering our multiple...

SSL Implementation related Query - Hi , we have two data sources, both exchange data through SSIS packages, so do i need to implement SSL on...

Analysis Services Tabular AND Multidimensional on the same Server - Hi guys Is it possible to have Analysis Services in both modes or are they mutually exclusive? I have a machine setup...


SQL Server 2014 : Development - SQL Server 2014

How to keep Canadian and US customers database separate in their country - We have a need to keep MS SQL server data of users in their country, USA and Canada. We have...

How to join INFORMATION_SCHEMA.COLUMNS, COLUMNS_UPDATED ( ), inserted and deleted tables - Hi :) On google, i found a script for Update Trigger without using a Cursor (). Line 32 to 74 http://beyondrelational.com/modules/2/blogs/71/posts/11988/how-to-find-the-right-columns-updated.aspx And here is...

how to call dynamic query stored procedure in select statement - Hello, i have created a stored procedure with dynamic query and using [b]sp_executesql[/b] . stored procedure is work fine. now i...


SQL Server 2012 : SQL 2012 - General

SSIS Config file question (couldn't find SSIS forum for 2012) - Hello, I have about 120 SSIS packages and one single CONFIG file. I also have a master package that runs each...

What could be blocking my app server from connecting to my SQL Database - I'm not a network guy at all and not the best at SQL to be honest. I'm setting up a...

Failure in starting process for user instance - I am trying to use SQL Server 2012 for the first time. I am running Win 8.1. I create a...

Changing collation - Hi, I need a bit of advice, I am currently going through a migration to a new data centre and SQL...

SQL Server Distribution Synchronisation Error - I have been attempted to setup a transactional replication across two servers. I am using two separate Virtual Machines. One is...

Creating a Test DB from a full backup of Prod - I am attempting to create a Test db from a full backup of the production db. With 2012, I cannot...

SQL Alias between client and server - Hi, I am trying to set up a client alias to connect to a named instance on another server but for...

Powershell and Register-WMIEvent for blocked process report Issue - Hi All Im trying to follow http://shellyourexperience.com/2011/09/14/powershell-and-sql-server-eventsblocked-process-report-and-sp_whoisactive/ in order to capture blocked processes using powershell All is fine until I try and...

Sql agent job failure alert. - Currently have something setup so job A runs and when it is finished it kicks off another job. It is...

Attempt to Add New Job for SSIS Package type causing SQL Server to restart - I want a SQL Server Agent job to regularly run a SQL Server Integration Services Package but during configuration of...

SQL Server 2012 Service Pack 2 - Good Morning, Does anyone know if there is a time frame for the release of SQL Server 2012 SP2? Thanks, Andrew


SQL Server 2012 : SQL Server 2012 - T-SQL

SQL Pivot? - I have data like: [code] ItemId CustomerItemId Customer Plant UnitPrice CustomerPO 637 82604029-5 C1 P1 0.7208 P1000 637 82604029-5 C2 P1 0.6889 441670 637 82604029-5 C2 P1 0.6889 411754 637 82604029-5 C2 P1 0.6889 412530 [/code] I need it like this: [code] ItemId CustomerItemId Customer Plant UnitPrice CustomerPO CustomerItemId Customer Plant UnitPrice Cust

condition to identify values that are +/- than 2 cents - I want to identify rows that go negative but only for 2 cents or more as well as identify rows...

XML Import into multiple tables with data translation - Hi All, I've never had to do this before, so forgive me if I'm not explaining the question well, I'll...

T-SQL : Problem with WHEN ... CASE - Hi, I have a little problm.. or not :) On my database, I have many [i]NULL [/i]values and when I run my...

Extract ispac file from SSISDB - Hi - I need to extract the .ispac file from the SSISDB. I can retrieve the stream with catalog.get_project sp. However,...

Need to understand how queries and this sample query is processed. - I took the Adventure works example below and created my own sample to see if I can understand how this...


SQL Server 2008 : SQL Server 2008 - General

SQL Server Database Projects - I'm really hoping someone may be able to point me in some type of direction with this. I'd like to...

Restore of db fails - We have a SQL2008R2 db backup given to us by a vendor that is 127Gig in size which is using...

Using Sort and Merge join Question - Hello All, I am using sort on two tables before using merge join but it is effecting the performance. I...

Backup on shared drive failing - Hi, I have a 4 node cluster with 6 instances. Lets said my 4 nodes are named as Node A, Node B,...

DB Slowdown running DBCC FREEPROCCACHE speed restored - We have a Database that on occasion will slow down to a mere crawl. When we run DBCC FREEPROCCACHE the...

Backup Job in Stored Procedure, issues - Dear all I'm all new to SQL so I apologize if this question seems trivial to you. I have pasted the...

How this works? - Hi there , I got this code from web, I cant understand how it works can anybody suggest me with links...

Query on Linked Server - Hi, I have a query if we can populate the same table A in a database D with data coming from...

Backup Testing - Hi guys, How often should I test my backups? We do full backups Weekly, every Sunday. Daily for differential and hourly...

SQL procedure Query Performance issue - Hi , I have a issue regarding a query showing very late response on one server while it works perfectly on...

Below Update statement is not working! any Idea why - create table #tmpcopylibrary ( dataid int, value int ) insert #tmpcopylibrary select 1,999 UPDATE TableA SET Value = isnull((select top 1 Value from #tmpcopylibrary where dataid = TableA.dataid), 0) here...

I am Confused about SQL Server performance - Hello Everyone, About two months ago me and two of my friends tried to see for ourselves whether Oracle is faster...

What causes my log size to get bigger ? Difference btw dbcc opentran and Select * from sysprocesses where open_tran>0 - Hi Guys, Somehow my db log size was increased suddenly. This is happening very frequently recently. Is there any way to...

Insert Data into Access - Hello All, I am trying to insert sql data into access database but having the error. "Test Connection failed of an error...

What could be disabling triggers? - Everyone: In a couple of occasions, on two different databases, on two different servers (two different customers of ours)... we found...

Display Duplicates - I have a Contact db. It has the usual Columns: Company, FirstName, LastName, Address, City, ST, etc.. When I SELECT DISTINCT on...

DB transaction log file on a shared hosting service - Hi, Thanks to this forum. It's great. I have a SQL DB on a shared hosting service (NewTek/The SBA) with 400Mb disk...

1 Quick question for all the DBA's - I am wondering if someone can help me out. I have become a SQL Server DBA about 7 months ago,...

Need Help parsing through the XML - i have an XML that needs to be written onto a table here is what i have done i created...

Index grows really fast! - Hi all , I have just created an index but it grows so fast... in 3 hours it becomes 95% fragmented...

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

Help with creating a SQL script. - I am wondering if I can get some help with what I am trying to achieve here. I have no...

SSPI handshake failed with error code 0x80090311 - we got the below error for 2 mins on production sql server error log. Please advise what could be the...

Latin1_General_BIN Collation - I am installing SQL Server 2008 R2 Standard Edition with required SQL_Latin1_General_BIN collation, but this particular collation is not found...

SQL Server Error S1T00 - Hello there. My company converted to SQL Server 2008 R2 as the backend for its inventory database about a month...


SQL Server 2008 : T-SQL (SS2K8)

MERGE Statement MULTIPLE INSERT into different tables - Hello, Can we insert into multiple table using merge statement ? If not then what are the alternatives ... please suggest. I'm using...

Trying to SUM row with Current Date to Row with "Last Month" Date - Hello, I am trying to SUM a column of ActivityDebit with current Calendar_Month to a Column of Trial_Balance_Debit from Last...

Unintended Escape\Continuation Character, BackSlash, in Executed Variable? - I was trying to see if there is any documentation regarding the backslash symbol "\" as a escape or continuation character...

need to merge two tables - Hi, I've One table that contains all current appointments booked as below. RN appt_id clinic_id derived_location_id provider_id appt_date_time appt_date_endtime 1 10218 601 1 43 5/27/14 8:30 5/27/14 9:00 AM 2 10219 601 1 43 5/27/14 9:30 5/27/14 10:00 AM 3 10220 601 1 43 5/27/14 10:30 5/27/14 11:00 AM 4 10221 601 1 43 5/27/14...

T-SQL Pivot Question - Hello Everyone. This should be an easy one. It's been a long time since I have used PIVOT and think...


SQL Server 2008 : Working with Oracle

Error when selecting top N records from oracle - I am writing a large select statement in MS SQL to select data from linked Oracle 11g server. Started with this e.g. Select...


SQL Server 2008 : SQL Server Newbies

Get next 2 weeks - I am trying to get the numbers for the next two week from now . Need help with querying this .. The...

create tables and database - I am trying do the below. I can create simple table like in steps (a) and (b) but not sure...

daily report - I have to supply a daily report. I have written the correct query in T-SQL. Is there a way to...


SQL Server 2008 : SQL Server 2008 High Availability

Bring Secondary Log Shipping DB online WITHOUT .TUF file - So if you have a database out of sync with its primary and you have lost the .TUF and old...

question on cluster private and public network - Hi, On a cluster, we have 2 networks i.e private network and public network. Private network is used for cluster communication(LooksAlive and...

How to upgrade an Active & Active sql cluster? - Hi Experts, How to upgrade an Active & Active sql cluster? Is there any difference in upgrade for sql 2005 Active-Active cluster and...

NetApp & clustering dependencies - Hi guys, Just a quick Q... should the clustered SQL Server instance have a dependency on the snapinfo LUN when using...

Automatic Mirroring fail over and see Login failed errors in error log of current Mirror server - Hi, We have high safety with automatic failover setup in our Sql Server 2008 R2 environment, and automatic failover is functioning...


SQL Server 2008 : SQL Server 2008 Administration

ASPState Session management sessions not expiring... - Hi all. We are running a SQL 2008 SP3 environment. Our users access the database servers through a web front-end. In...

Maintenance Plan setup - potentially .NET issue - I'm stumped on this one. A network admin I am NOT. When I try to create a new maintenance plan on...

TempDB and Mount Points - Hi, I have created a volume for TempDB data files (G:\) and now created another volume for TempDB data files as...

Need Script for Automating Find and Fix Orphand users - Hi Friends, I have 10 Databases . Irefresh these databases from PROD to TEST server. after refresh i have to fix the orphand...

Shirnk Tlog(LDF) size? - Hi, Database High availability - Mirror setup configured, Principal server Tlog (.LDF) file size 25 GB, also warning messages recording at error...

Backing up a DB with log shipping turned on - I have a Db which has log shipping turned on. If I create a separate maintenance plan to do a...


SQL Server 2008 : SQL Server 2008 Performance Tuning

High to troubleshoot high cpu and high memory usage happening on the same time? - Hi Experts. What would be the proper troubleshooting approach for the below performance issue. Server is 100% cpu and 90% memory...

Index Seek on Non Clustered Index cost is very high (92%) how to reduce this ? - Hi ALl, Please give your suggestions to resolve this problem. Index Seek on Non Clustered Index cost is very high (92%) how...


SQL Server 2005 : Administering

Database is in Recovery Pending Status - Hi, My Production database is in Recovery pending status. I checked and found due to Hard disk space it went into...

Login failed for user 'NT AUTHORITY\SYSTEM', Very straing - I get hundreds of these messages in my SQL Server logs every day (Exactly every 15 minutes). The messages have a...


SQL Server 2005 : Backups

Netapp SnapManager for SQL - Hello, Is anyone using Netapp's Snapmanager for SQL to do backups/restores? Have you had any issues with it? All comments are...


SQL Server 2005 : Business Intelligence

What are the best way to move data securely over the network by SSIS? - Need to design ssis package to copy data from local database server to another database server which is public and...


SQL Server 2005 : SQL Server 2005 General Discussion

Update XML Column - I have a table "table1" that has an XML column (by the name of VariableData) in it. I need to...


SQL Server 2005 : SQL Server 2005 Integration Services

format the output column in destination .csv - Hello, in ssis, I use a oledb source to execute a stored procedure and a flat file source to have the...


SQL Server 2005 : T-SQL (SS2K5)

Need help converting Dynamic Pivot output to XML / HTML - G'day. I need some help converting the output from a pivot statement to HTML. I can't seem to get my...


Reporting Services : Reporting Services

Setting arithabort on in SSRS - Anyone know if this is possible? Have been consistently using a plan which does not have arithabort even though I...

address overflow at Parameters!Value(1) when not checked - Hi guys, I have an Visual Studio 2005 SSRS Report. There are some report columns – january, february, … , december that must have...

SSRS Migration tool like SSIS package upgrade wizard - Hello and Happy Friday! I have been searching for a migration tool for SSRS that is similar to the SSIS package...

Report Manager Layout Different after migrating from SQL Server 2005 SSRS to SQL Server 2012 SSRS - Hi! We've recently migrated from a SQL Server 2005 server with Report Manager running in IE 7 to SQL Server...

Open microsoft outlook by clicking field on SSRS report - I know this is possible in Business Objects, maybe it is here too, but I cannot seem to figure it...


Reporting Services : Reporting Services 2008/R2 Administration

reporting services - I have two reporting services environments. First one is a native running on the same sql 2008r2 box using the...


Programming : General

conversion error data type - Error msg inserting - When I run the Select statement without the insert, it does not return any records. I don't know why I...


Programming : XML

XML to file - I have a query that, when run in SSMS with 'Results to Grid' selected, provides a link (in the grid)....

Unable to get Value from XML - <?xml version="1.0" encoding="utf-8"?> <DataSet xmlns="http://tempuri.org/"> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxO


Data Warehousing : Integration Services

SSIS variables - Greetings :) I've a one-off task to input a bunch of CSV files and feel ... this is a job for ssis. There...

Replace a carriage return in SSIS - Hi All, I have a flat file with data as below: row delimiter: {CR}{LF} column delimiter: | -- Pipe Some times the data is being...

SSIS Analysis Services Processing Task. - Hi SSIS - 2008R2 SSAS - 2012 I have got a very weird problem. I am trying to build a package on SSIS 2008...

Extracting VarBinary(MAX) column to Flat File - Facing Issue. - I’m extracting data from the table to flat file using SSIS,during this process I’m facing the data conversion issue in...


Data Warehousing : Analysis Services

MDX query producing #Error as output - The query below produces an error and I have hard time trying to figure out why. It is something to...

Error when trying to process/browse dimensions and cube - Setup: SQL Server 2012 SP2 clustered running on a VM Twice in the last two we have encountered a problem processing...

Cube file corrupted, cant restore backup - Hi guys, i am getting an error which looks like the cube file is corrupt. [code="xml"]TITLE: Microsoft SQL Server Management Studio ADDITIONAL...


SQLServerCentral.com : Anything that is NOT about SQL!

What does a masters degree in database administration give you - Is there any justification for pursuing a masters degree in database administration? what would be the positives and the negatives?

Fantasy Football 2014 - SQLServerCentral would like to host a Fantasy Football league again in 2014. As of now, we'll run this league the...

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

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 : Certification

I'm totally new. Need some guide on SQL 2012 - Hi folks! I'll put it briefly.. I want to work with DB, but I know nothing about it because I have...


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


Microsoft Access : Microsoft Access

Updating Table uses old data from Linked Table - Process : Table A is a table internal to Access 2007. Table B is a linked table in Access 2007 to SQL...

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