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

Moving to the Heartland

This editorial was originally published on Oct 17, 2008. It is being republished as Steve is on vacation.

This is kind of a US-based editorial, but I suspect that it applies in other countries as well. I caught this article about data center growth in Iowa, traditionally a farming state in the US. Iowa is making efforts to attract companies, including large ones like Microsoft and Google, to built data centers within its borders.

Quite a few data centers have been built lately in the middle of the US, in non-traditional IT or Telecom power areas. Not that some big cities haven't gotten data centers as well, but it seems more and more that data centers are being built in out-of-the way places. I've seen Google add data centers in Oregon and Iowa, Microsoft adding them in Boulder and Dublin, as well as Quincy, Washington. Microsoft has added some large ones in big cities like Chicago and San Antonio as well.

It's interesting that as we grow more and more, and with greater needs to be connected and in contact with each other that our technological advances have leveled the cost of entry into many industries. The publishing and music industries are struggling as every person can become their own producer, publisher, distributor, and talent. No longer does a musician need to move to Los Angeles or New York to get noticed. And no longer does a writer need to struggle along hoping to get a book contract. In both cases the Internet and various on-demand technologies enable each person to get their own content out into the real world and sell it themselves.

For those of us working in technology, it means that Silicon Valley and other technological hotbeds are not necessarily the place we need to live. More and more people are forgoing the need to build their business in a large city and instead doing it where they want to live. A company today might pick a place where the founder grew up, or where they went to school, or some other criteria.

Just as cities grew by attracting businesses to the places with large and diverse workforces, now small towns can do the same, by offering different types of amenities, tax structures, and more. And with large companies like Google and Microsoft helping to invest in some of these places, it might be that your next high-tech job is in someplace like Boulder, CO, which has seen tremendous data center growth.

Maybe I should even consider dedicating an acre or two out here at the ranch for a small data center. Anyone want to come work in Elbert County, CO?

Steve Jones from SQLServerCentral.com

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


Video and Audio versions

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.

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

Steve Jones

Windows Media Video ( 32.9MB) feed

MP4 iPod Video ( 27.5MB) feed

MP3 Audio ( 5.6MB) feed

Feeds are available at iTunes and Mevio

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

ADVERTISEMENT
CloudDevelop

The premiere cloud computing conference in the Midwest

Gain real-world insights from those that have "been there, done that" with Windows Azure, AWS, Heroku, & more. Join the fun at CloudDevelop, Aug. 30th.

sqlmonitor

Understand Locking, Blocking & Row Versioning

Read Kalen Delaney's eBook to understand SQL Server concurrency, and use SQL Monitor to pinpoint excessive blocking and deadlocking. Download free resources.

sqlinthecity

SQL in the City – Free SQL Server Training the Red Gate way

Red Gate is hosting free seminars and events in the US this summer and fall. Learn about best practices for SQL Server database development and administration from top SQL Server MVPs. Find out more and register

Featured Contents

 

Stairway to Server-side Tracing - Level 3: Creating a SQL Trace Using SQL Server Profiler

Dan Guzman from SQLServerCentral.com

In this third article of our Stairway Series on tracing, Dan Guzman goes into the method of using Profiler to help you create a custom trace of the events that you need to monitor. More »


 

SQL Saturday #236 St Louis, MO

Press Release from SQLServerCentral.com

SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there. More »


 

Free eBook: SQL Server Hardware

Press Release from Red-Gate

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS. More »


 

Rendering images from a database on SSRS reports

Additional Articles from MSSQLTips.com

Looking for a way to put images on SSRS reports and allow the business users to change the images every so often? This article explains how to implement this in such a way that you don't have to modify a report when the image is changed. More »


 

From the SQLServerCentral Blogs - SQL Server: Performance Tuning :Understanding Set Statistics IO output

nelsonaloor from SQLServerCentral.com

Performance tuning is one of the important task of DBA. Many times people comes to us with different types of... More »

Question of the Day

Today's Question (by Kapil Singh):

What will be output of following scenarios? (the answers are the results of the three scenarios)

CREATE TABLE [dbo].[Customer](
[CustomerID] [int] IDENTITY(1001,1) NOT NULL,
[CustomerName] [varchar](50) NOT NULL,
[CEO] [varchar](40) NULL,
[Phone] [varchar](20) NOT NULL
PRIMARY KEY CLUSTERED 
(
[CustomerID] ASC
)
)
go
-- Create view
Create  VIEW vw_customer
 WITH SCHEMABINDING 
AS 
 SELECT  CustomerID, CustomerName
  from dbo.Customer
  ;
--Scenario 1
Create index IX_CustomerID 
 ON vw_customer (CustomerID);

--Scenario 2
Create unique clustered index IX_CustomerID 
 ON vw_customer (CustomerID);

--Now alter the view after Scenario 2 
Alter VIEW vw_customer
 WITH SCHEMABINDING AS 
 SELECT CustomerID, CustomerName, getdate() CurrentDate
  from dbo.Customer
;
Alter  VIEW vw_customer
 WITH SCHEMABINDING 
AS 
 SELECT  CustomerID, CustomerName 
  from dbo.Customer
  ;

--Scenario 3
Create index IX_CustomerID 
 ON vw_customer (CustomerID);

-- cleanup
DROP VIEW vw_customer;
DROP TABLE customer;

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.

Did you miss yesterday's question, The OUTPUT clause and T-SQL Syntax? Answer now.

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

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!

Featured Script

Find unused jobs

Dennis Post from SQLServerCentral.com

Job list cluttered?
This script will return a list of jobs that either have not run in X months or where the next schedule run date is older than today.

Just run this against any server. Investigate if the job can be deleted. To be on the safe side, you can always script the job by: Right clicking the job / Script job as / Create to

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

insufficient system memory to run this query - Sql 2005 - Hi, We are getting right now following error: We have Sql 2005 with 4 GB Memory There is insufficient system memory to run...

Filegroups ClusteredIndex - Non-Clustered NDF - For performance sake. I have a server with drives D:, E:, & F:. I have a large table I want to...

sql server 2005 sp1 is slow - users experience slowness on the sql server 2005 sp1. Windows Server 2003 Standard Edition SP1 Physical RAM: 3.25 GB I set the...

BACKUP WITH NORECOVERY - CAN Any one clarify my doubt please, What exactly BACKUP ......... WITH NORECOVERY will do Difference b/n BACKUP... AND BACKUP...WITH NORECOVERY thanks

SQL Server 2005 : Backups

Will doing a backup slow down the system - Hi I need to do a backup of our database I was just wondering if I could do it during normal...

SQL Server 2005 : Development

SQL Question - Hello, I need your help in the following scenario. I have customer information in two tables, ProductA_Customer and ProductB_Customer. I am trying...

Table Level Mask - Hi Experts, I have a requirement wherein, we do not want any users accessing SQL server to read the data using...

Adding SQL Objects to VS201 errors - I am trying to add database objects of existing SQL database to source control. Here are the steps I am using: 1:...

SQL Server 2005 : SQL Server 2005 General Discussion

How to join multiple tables to show all Exceptions but avoid cartesian product - Hi all, Ive got the following SQL query which takes all the trades from the trade table and joins a number...

SQL Server 2005 : SS2K5 Replication

Snapshot Replication Error - Hey guys, So I have setup replication between our source production database to replicate to our reporting database so we are...

Trans replication with remote distributor, publisher upgrade question. - Hello there, I'm after a bit of advice. We have a 2K5SP4 publisher database with a 2K5SP4 remote distributor and over...

Replication issue - We are currently in the process of migrating our environments. We have multiple publication servers, a central distributor, and multiple...

transactional replication error in sql 2000 server: violation of primary key - Hello, We have sql 2000 replication in our environment. recently, we have been getting error saying 'Violation of PRIMARY KEY constraint...

SQL Server 2005 : SQL Server 2005 Performance Tuning

select query does not return any resultset - hi all, i have a table with 74 rows. when i run a select statement on it, it does not return...

SQL Server 2005 : SQL Server 2005 Integration Services

SSIS Logic - SSIS Package: 1) I am trying to get the value from a look up table into a @intial variable : example say...

how to merge single page tiff file to multi page tiff file - Hi I have a requirement to merge single page tiff files stroed in a table to a muli page tiff file... Can...

handling row length in SSIS - I have created a SSIS package in BIDS for loading data from text file. I have bad rows where the...

Use parameters with Execute SQL task - I would like to use a parameter with the execute sql task but nothing is working like BOL says it...

SQL Server 2005 : T-SQL (SS2K5)

Delete From Scripting Help - Hello – I currently have an SSIS package running and the first part of it deletes all data in (Table A)...

SQL Server 7,2000 : SQL Server Newbies

Backup failed - Hello Maters, I have one SQL Server 2000 in my database environment, Our wintel team gimme a message that their filesystem...

SQL Server 7,2000 : T-SQL

Group by based upon condition - SQL Server 2000 Enterprise Edition create table student ( rollno int, name varchar(30), class varchar(20) ) insert into student values (1,'Robert','IT') insert into student values (2,'John','Arts') insert into student...

Continue control from rollback in trigger to procedure - Hi Dear, [code="sql"]CREATE TABLE TestTable ( ID INT, Name NVARCHAR(100) ) GO CREATE TRIGGER TestTable_Insert ON TestTable FOR INSERT AS DECLARE @ID INT SELECT @ID = [ID] FROM INSERTED IF @ID = 1 ROLLBACK TRANSACTION GO CREATE PROCEDURE p1 AS DECLARE...

SQL Server 2008 : SQL Server 2008 - General

Page Compression - Syntax - is this syntax right for compression. I have a table which is partitioned, has a clus idx and two nc...

Errors while querying over VPN connection after moving to Windows 7 64-bit - I am having trouble executing queries on a new Windows 7 64-bit machine. The target database is accessed through a...

Snapshot Replication Error - Hey guys, So I have setup replication between our source production database to replicate to our reporting database so we are...

exclude specific tables during the database restore - Hi All, Is there a way to exclude specific tables during the SQL database restore? Thanks

Viewing an xml plan as a graphical plan - I am having trouble viewing the query plan as a graphical plan. I am running 2008 r2 sp1 on the...

differences - what are the differences while installing sql 2005 vs sql 2008 ?

Conditional Join - Hi, I have 3 tables TableA, TableB, TableC. I have to update data in TableA with TableB or TableC If there is data...

Query taking non-consistent time to execute - I have a query which takes large time to execute sometimes.When i checked the speed it was taking 15 seconds.But...

view pdf in report - HI Please assist. I have a table with PDF files. I would like to display these files in a report. i have...

How to find ladder in sql query - Hi, I have table like below col1 5 10 15 20 I need result like Col1 Col2 5 05--9 10 10--14 15 15--19 20 20-24 Plz...

substring problem causing an error - I have a query in one of my procedures which causes an error. [code] select substring(expirydate,1,(charindex(' ',expirydate) -1)) as expirydate from newtable [/code] this...

SQLPS issue - I have two node windows cluster on which SQL2008 R2 is running. When I execute SQLPS, it throws error [b]"Drive...

Sql server query help - Ok I hope I can explain my dilema I need a sql select statement that will Select part_number from RCTOOL the...

do I need to use case explicily - I have a database that imported some students' info from a text file. When importing into the raw table, the studentID...

between sql server and sql server agent - hi soory for stupid question but whats difference between sql server and sql server agent ??? arent both windows services .if...

SQL 2008 R2 Build 10.50.1790.0 - MS11-049 is this a windows update. I can get sql to 1777 build. Using cu packs. How do I use...

Execution Plan Changes With "TOP 1" And problem with the response time - Hi, I have a view like : [i] alter VIEW View_IdPERSON as select em.EMAIL_VALUE as liste_email ,e.PERSON_id as Liste_DMID ,ed.DATA_BIRTHDATE as Liste_DMDATENAISSANCE...

No history of job execution in a particular instance - Hi, I have a job scheduled to run every 2 hours during the week. The job started to run at 1:15 PM...

SQL erroring for windows authentification when mixed is selected - Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only....

Ranking Based of Advert Breaks - Hi People, This is a tough one for me. Let me start by explaining what i want to do then posting...

SQL Server 2008 : T-SQL (SS2K8)

how to return email id if it contains dell.com otherwise any one email in the group - if an email contains %dell.com% then return it otherwise max(email) / min(email) just one please help me, [b]DDL[/b] create table #onner (acctno int,...

Job shows communication link failure when VPN connects - Hi friends, I am running a job in SQL server which shows communication link failure when the machine connects to...

Convert given Date to various formats - I have declare Start Date in below format. Declare @StartDate date = '2013-01-01' I want get output for below 2 col's as follows ...

Basic about clustered index ! - Is the same space used by Clustered index and the column on which the primary key is declared?

search values in a temp table with like operator - Hi, I have a SQL proc with a search-parameter (given as coma separated values) which should return all data of...

Hi Please help to resolve this Problem: Advance Thanks for given Solution - Table1: Reportid | IdetityID(Pimary key) -------- | --------- 2 | 1 2 2 2 3 2 4 2 5 Table2: Reportid | IdetityID(Primary key) -------- | --------- 3 | 1 3 | 2 3 | 3 3 4 3 5 I want to insert above values in to Table3 leke below: Hear P

previous week query 0700 - 0700 - HI all I have been asked to generate reports from my c# package I have created every Monday at 0700hrs,...

SQL Server 2008 : SQL Server Newbies

Creating a view with Declare - I am trying to create a view with the below query. it should be a view as data in other...

Multi database Sum Process - There are 3 table this table [img]http://s21.postimg.org/41fxzjb4n/sql.png[/img] I want to as a result CUSTOMER----PAYMENT------------ORDER Name ------ SUM(TOTAL)--------SUM(TOTAL) Jean -------- 1500----------------- 500 Ali ---------1000------------------250 This will make the process the query.. thank...

SQL Server 2008 : SQL Server 2008 High Availability

Splitting and shrink a Windows Volume without Cluster's downtime? - Ok. Got a quick question, maybe for Perry or whoever can clarify. Got a SQL 2012 failover instance running on Windows 2008...

SQL Server 2008 : SQL Server 2008 Administration

Need a blocking script with specific details - Hello All, I am looking for a script that will give me these details. 1) spid 2) Total number of spids...

Cache Memory - Hi, How to find out Total amount of dynamic memory (in megabytes) that the server is using for the dynamic SQL cache.

Linked Server - Works Except With Insert Statement - I am trying to get Job information from ServerB, and populate a Table Variable on ServerA. From ServerA, I am...

Dumb question about data types - Using SSMS 2008 R2. This is driving me nuts. I have a table that has a LOT of foreign keys....

shared & Exculsive latches? - Hi, PAGEIOLATCH_SH --------------- wiat_time_S 175094.26 Pct 1.05 Running_Pct 96.99 PAGEIOLATCH_EX -------------- wiat_time_S 119320.6 Pct 0.71 Running_Pct 98.53 these shared & Exculsive latchs acquired in waits stats in cummulative number since restarted server,...

SQL 2008 cluster installation failed - Today we tried installing SQL 2008 cluster. It failed with error "[b]Wait on the database engine recovery handle failed[/b]". We...

Can’t use connect using (local) or localhost as a server name - Hello everyone I have a laptop with SQL Server 2008 installed locally. I can only connect to the server by specifying...

Transaction Log growth out of control - Last weekend I re-indexed some Databases. Before doing so I backed up the Databases and Set them to simple recovery mode. After...

Can we Create sql server instance through script? - Hi, I am using SQL server 2008 standard edition. Is there a way to create a new server Instance by...

Memory Issues on production sql server - Please help me in this situation. Total memory on box : 10 GB Single node, non clustered production box Min memory is set to...

Cannot backup - Old killed backup still running - Hi I have one DB that on a multi DB server that people cannot connect to. I'm not familar with...

Career : Certification

How many tests do I need for 2012 after I get my MCITP - OK, I'm desperate to figure out how many exams I have to take after I finish the SQL 2008 exams...

Programming : XML

Should XML Parser apply XSD Schema restrictions to CDATA? - Hi, I'm importing some XML files into SQL which have an XSD schema which I am validating against. The "issue" I've...

Programming : Powershell

Integrity check output to file using Invoke-Sqlcmd failing - Hi all, I am having fun trying to get a PowerShell called database integrity check to output to a file....

Powershell error - Ok in ISE , fails in Agent job - Morning all. I am trying to run script to get Translog details. The script works fine in ISE and produces report...

SQLServerCentral.com : Anything that is NOT about SQL!

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

SQLServerCentral.com : SQLServerCentral.com Website Issues

Add a generic replication forum. - I've just posted a problem that I've been having about replication, I put it in the 2005 forums as that...

Reporting Services : Reporting Services

Special Characters in field name - Hello all. I have a situation where my company has a report which has fields named with special characters such...

Any issues with installing .NET 4.5 on SSRS / SQL 2008R2? - I have Windows 2008 R2, SQL 2008 R2 box with SSRS working just fine (not Sharepoint, just regular SSRS). I'm...

SSRS Report : Help Me to display text box values in Header of the report - Hello guys, sorry if I am posting in the wrong section of the Forum, I am looking for the help on...

Database Design : Design Ideas and Questions

Database Log - I am a Newbie DBA please Help me. My Database transaction log always more than 55% every 12 hour. i saw it...

Data Warehousing : Integration Services

DEPLOYING SSIS 2008R2 PACKAGE - The Gurus, I am tasked with managing a package which was working without any problem but a colleague errorneously reported a...

SCript component Binary code code not found error always - SSIS2012 - I have spent three days on this not able to find an anserr Added script component transform open the edit script...

Incremental Load using SQL SERVER 2008 - I have to perform incremental load using ssis. The workflow and architecture is as follows: I have an etl process in...

Data Transfer - data not transfered in order - hi there, I have a table with 371 751 rows. I have a standard SSIS package that transfers data from table...

Records Missing when SSIS dumping Data to Oracle Staging. - Hi All, I have got a situation where my SSIS package dumps Data from a SQl Server source to a Oracle...

Mixed formatted Input Text Files - I'm new to SSIS packages so feel free to yell at me if I'm making this more difficult, and please...

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

Data Transfer queries - Hi there, If I could advise on my situation at present. I have been asked to create a Datawarehouse soloution...

Data Warehousing : Strategies and Ideas

Extend or migrate a Fact Table? - Hi Folks, I`m facing a Situation, in which the reference data of our data warehouse is changing. Basically a new System...

Data Warehousing : Analysis Services

Cube dimension listings - I'm trying to recreate an old SSAS 2000 cube in 2008, and I've got most everything done. The problem is...

Data Warehousing : Data Transformation Services (DTS)

Change Tracking - Hi, We have a need to load some OLTP data into DW based on last time the data got updated/inserted....

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