In this issue

Featured Contents

Editorial

Featured Script

 
 advertisement
 
SQL Monitor "It's the freaking iPhone of SQL monitoring"
"Everyone just gets it…that has tremendous value" - Rob Sullivan, DBA, IdeasRun. Get started with SQL Monitor today - download a free trial.
 
Deployment Manager NEW! Deployment Manager Early Access Release
Deploy SQL Server changes and .NET applications fast, frequently, and without fuss, using Deployment Manager, the new tool from Red Gate. Try the Early Access Release to get a 20% discount on Version 1. Download the Early Access Release.
 
SQL Backup Pro "Impressed is the word!
Cut our backup times in half and reduced the space used by 80%!" Tobie Dunn, SQL Backup Pro 7 user. See what savings you can achieve - download a free trial today.

In This Issue

Stairway to XML: Level 7 - Updating Data in an XML Instance

You need to provide the necessary keywords and define the XQuery and value expressions in your XML DML expression in order to use the modify() method to update element and attribute values in either typed or untyped XML instances in an XML column. Robert Sheldon explains how. More »


The PoSh DBA: Solutions using PowerShell and SQL Server

PowerShell is worth using when it is the quickest way to providing a solution. For the DBA, it is much more than getting information from SQL Server instances via PowerShell; it can also be run from SQL Server as part of a system that helps with administrative and monitoring tasks. More »


Last chance for a day of free SQL Server training at SQL in the City 2012

SQL Server developers and database administrators have one last chance for a full day of free training and networking at SQL in the City 2012. More »


From the SQLServerCentral Blogs - Virtualizing Your Business Critical SQL Servers Anthology

This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical... More »


Editorial - TTYL

Today's editorial was originally released on Nov 20, 2007. It is being republished as Steve is at DevConnections.

OMG! The DB if FUBAR.

The sysop added an HDD and did a RAID rebuild OTF. AFAIK, the Vol with the MDFs got wiped for the CRM that runs 24/7.

I'm ROFLMAO. AWHFY? TTYL.

Can you imagine someone talking to you like that. I mean actually speaking with "words" like "T-T-Y-L?"

I saw this article about how most people are speaking English in business today, but with the globalization of many companies, it's easy to not only mis-communicate, but also offend. And that can be a big problem with not only co-workers, but also customers.

Whether we standardize on English or some other communication, I hope that we continue to keep the skills of our language alive. The new generation of workers, working in shorthands and their own slang, seem to be losing out on the ability to effectively communicate with others. Too often they want to bang something out on a keyboard rather than talking directly to someone.

I'm sure I sound like an old man, lamenting the good old days of paper, ink, and phones without voicemail. However it's not the shorthand or slang that bothers me as much as the lack of the ability to clearly articulate themselves that plagues many people in the IT world. When I started in this business, it was always an issue communicating because things were so highly technical and few people understood how computers worked. The geeks that could truly make a computer sing had trouble communicating with business users.

I think the same thing is true today with communication, despite the advances in making computer interations simpler, greater familiarity, and a comfort level with technology by many business users. For every step we've made in computing becoming more accepted by users in all aspects of society, we've gotten worse in our overall communication skills with acronym and shorthand overload. I almost shudder to think of the text-messaging generation entering the workforce.

Technical jargon is important. It helps us quickly, clearly, and easily communicate with other IT workers with very specific meanings, but it's not the way that we should communicate with those outside of IT. Even if you are never any type of analyst, designer, architect, it pays to be able to clearly and effectively communicate your ideas, thoughts, and concerns to others.

Save the shorthand and slang for those times when it's appropriate and be sure that you can communicate using clear and generally accepted English (or your native language) with everyone else you encounter in your career.

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


The Voice of the DBA Podcasts

Everyday Jones

The podcast feeds are now available at sqlservercentral.podshow.comto get better bandwidth and maybe a little more exposure :). Comments are definitely appreciated and wanted, and you can get feeds from there.

The RSS Feed: or now on iTunes!

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.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

» To submit an article, rant or editorial, log in to the Contribution Center


Question of the Day

Today's Question:

--create table
CREATE TABLE [dbo].[Musician] 
( [Musician_ID] [int] IDENTITY(1,1) NOT NULL,
  [Last_Name] [nvarchar] (50) NULL,
  [First_Name] [nvarchar] (50) NULL,
   CONSTRAINT [PK_Musician] PRIMARY KEY CLUSTERED 
    ( [Musician_ID] ASC )
  WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] 
)
ON [PRIMARY]
GO

INSERT INTO Musician (Last_Name, First_Name)
 SELECT 'Lennon', 'John'
UNION ALL
 SELECT 'McCartney', 'Paul'
UNION ALL
 SELECT 'Harrison', 'George'
UNION ALL
 SELECT 'Star', 'Ringo'

--1
SELECT First_Name
 FROM Musician
 WHERE Musician_ID in (2)

--2
SELECT First_Name
 FROM Musician
 WHERE Musician_ID in ((2))

--3
SELECT First_Name 
 FROM Musician
 WHERE Musician_ID in (2,3)

--4
SELECT First_Name
 FROM Musician
 WHERE Musician_ID in ((2,3))

Which query (queries) will return an error ?

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

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

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

 Inside the SQL Server Query Optimizer

This book will take you from the fundamentals of Statistics, Cost Estimation, Index Selection, and the Execution Engine, and guide you through the inner workings of the Query Optimization process, and throws in a pragmatic look at Parameterization and Hints along the way. Grab your copy today from Amazon!


Yesterday's Question of the Day

We have this script:

create table Person
( id int
, name varchar(80)
)
go
select Id as ColA
     , name as colB 
 from Person
select Id, name name
 from Person
select colA = Id
 from Person
select colA = Id
, name = colB 
 from Person

Which of those queries will be NOT executed successfully?  

Answer: select colA = Id, name = colB from Person

Explanation: Invalid column name 'colB'. We can use column alias in a SELECT Statement. When an "=" is used, the right side of the equals must be a valid column.

Ref: SELECT - http://msdn.microsoft.com/en-us/library/aa259187%28v=SQL.80%29.aspx

» Discuss this question and answer on the forums

Performance Tuning with SQL Server Dynamic Management Views

This is the book that will de-mystify the process of using Dynamic Management Views to collect the information you need to troubleshoot SQL Server problems. It will highlight the core techniques and "patterns" that you need to master, and will provide a core set of scripts that you can use and adapt for your own requirements. Grab your copy today from Amazon!


Featured Script

Lists tables, Stored Procedures and other Objects

This stored procedure helps you list all tables, stored procedures, functions, view and triggers in a database. 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

help with this query!!!! - My goal here to apply the condition to the query while joining the table instead of doing it at the...

Total Server Memory Vs Target Server Memory - Hi, We have SQL Server 2005 EE x64 with SP3. RAM = 16 GB Max Server Memory = 12 GB Min Server Memory = 0 default...

SQL Server 2005 : Backups

Suspend log shipping restore for full backup on standby - You can't run a backup on a log-shipping standby database normally because it's either in no recovery or standby. To...

SQL Server 2005 : SQL Server 2005 General Discussion

Using the "IF" function in a column - Is it possible to use the "IF" function in a column at design time as the value for that field?...

SQL Server 2005 : SQL Server 2005 Strategies

Editing cells from with Server Management Studio - (Sorry, headline is supposed to read "from within") Moving (asap) from 2000 to 2005. In 2000, we could easily bring up...

SQL Server 2005 : SQL Server 2005 Integration Services

Replication user account - Hello Could any one explain which login acount we should use while configuring Replication or while providing security credentials during replication...

SQL Server 2005 : T-SQL (SS2K5)

Recursive RunningTotal calculate - Hi All, I need to calculate running total (totalInterestedPaid) for the following temp table (#tmpInterestedPaid) tran_date Calc_interest_accrued Interest_paid TotalInterestPaid 20120908 54.06 NULL 0 20120910 54.06 NULL 0 20120911 24.04 112.35 0 20120913 23.67 ...

SQL Server 7,2000 : Service Packs

FN_GET_SQL missing from my SQL 2000 SP4 installation - I've just discovered that system function FN_GET_SQL is missing from my SQL200 production server. I have it on my SQL...

SQL Server 2008 : SQL Server 2008 - General

Do not wait for Query to completed - Hello Experts, I have an application that does many things, at the end, it calls a stored procedure to perform some...

Hexadecimal to Binary Conversion in SQL Server 2008 R2 - Hello, I am using the following code to try to convert my hexadecimal string to binary format: [code="sql"]DECLARE @MYHEX AS VARCHAR(MAX) SET...

The database 'model' is marked RESTORING - I have 3 SQL instances and every time I reboot the server I have this one instance that I can...

DBCC Slower on new production server - Greetings to all -- I have a brand new DELL 720 server due to go into production in a few weeks....

Is BooksOnline wrong or am I just too dense (on Recovery Paths) - I was just reading BOL on Recovery Paths ([url]http://msdn.microsoft.com/EN-US/library/02414941-9B9F-4843-9EAC-11DFB7FBFC85(VS.110).aspx[/url]) and they have an example which just doesn't make any sense...

Connot connect to server via name but IP works, not a SQL Browser service issue :) - Ok, here is the issue and my steps to troubleshoot: I can connect to my SQl server using SSMS by IP...

Why does TRUNCATE TABLE hang? - I'm trying to empty a staging table using TRUNCATE TABLE in a stored procedure, but the sp just hangs. The...

How do I join tables, but select top 1 from 1-many tbl? - Essentially I have a Contact table and a History table. I'd like to get the join the tables, but only show...

SQL Server 2008 : T-SQL (SS2K8)

Get last row based on duplicate column - I have a table that contains: [u]userid email name[/u] 1 a@a.com Bill 2 a@a.com Billy 3 a@a.com William 4 b@b.com John 5 b@b.com Johnny 6 c@c.com Jimmy 7...

Suggestion to avoid Cursor - Hello comunity I need to replace a Cursor with an example using a WHILE and IF condition, for testing if the...

Loop Through the records - send email - set the value of the field - Need Code Help - -- I am hoping not to use cursor -- Query is select * from Orders where EmailSent = 0 --I want to loop through records...

Convert years - Hi, Can Anyone help me with this, please I have a Table like this Es Year January February March E0003 2008 XXXXX XXXXX...

which is the easy way to Eliminate the duplicates? - Hi, Please suggest me to get the distinct values from below query declare @T as table(id int identity, code varchar(10)) insert into @T(code)...

Extracting Data from single table - I am attempting to pull only open tickets from my table. Thing is we have duplicate records with different status...

Alphanumeric number generation - Hi, I need to write a SQL query to print the following aphanumberic sequence in SQL 2008. 0001, 0002, ... , 0009, 000A, ... , 000Z,...

SQL Server 2008 : SQL Server Newbies

quotation and punctuation in sql server - Does anyone have some rules by which quotation in SQL Server works? An example: Select Year, Max(Case When Name='Tour de France'Then Coureur...

Stored Procedures and updating multiple tables - Was hoping someone could kick me in the right direction in regards stored procedures. My issue is if I have a...

sqlserver 2005 express installation - Hi, I have installed sql server 2005 express management studio. After the successful installation, I try to open it and the connect...

Loop through table to group associated records - Hi All, I have a table containing about 1mil records that i need to loop through, find associated records and insert...

SQL Server 2008 : SQL Server 2008 High Availability

How to reintialize single article in replication - Hello Team, How to reintialize single article in replication sqlserver2008 Thanks in advance

Unable to lanuch replication monitor - Hello Team, I am Unable to lanuch replication monitor using sqlserver2008 Thanks in advance

SQL Server 2008 : SQL Server 2008 Administration

Log space full 100% - Two of my databases are showing 100 % log space. I have no space left on the disk to increase the...

Error Connecting to Named Instance - I had to install a new instance of SQL Server 2008 R2 Express on Windows 2007 because our SQL Server...

DBA basic - Hi, Where/how do you suggest to start learning about the basics of a DBA please? Thanks

SQLServerCentral.com : Anything that is NOT about SQL!

help with this query !!! - Most of my cost is around the filtering which is done at the bottom of the code. My goal is...

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

Data Warehousing : Integration Services

SSIS and READ OpenEdge Progress Db To WRITE SQL SERVER 2008 R2 - Ciao to all people reading this very good Forum.. If you use Open Edge Progress Database and want to pull data...

Data Warehousing : Strategies and Ideas

Anyone use SCD Transformation? - Does anyone use the SCD transformation in their production ETLs? In my two previous DW jobs, we never used the...

Data Warehousing : Analysis Services

nable to build SQL Server OLAP Cube when there is no rows corresponding to foreign key in a table - I am new to SQL Server OLAP Cubes. I am having the following issue like ex I have purchase order and...

SSAS CUBE PROCESSING ERROR - I am new bie trying to learn SSAS. I have these errors in trying to process my cube after it...

Microsoft Access : Microsoft Access

Ms access add record to table via unbound text box - Front end MM Access adp file. On SQL server 2005 Form bound but user must not change data directly Unbound text box...