In this issue

Featured Contents

Editorial

Featured Script

 
 advertisement
 
SQL Backup Pro Gold Community Choice Award for SQL Backup Pro
Try award-winning SQL Backup Pro for faster, smaller, fully verified SQL Server backups. Download a free trial now.
 
SOurce control databases with SQL Source Control The best way to version control T-SQL
SSMS plug-in SQL Source Control connects SVN, TFS, Git, Hg and all others to SQL Server. Learn more.
 
SQL Monitor Monitor the data you care about the most
SQL Monitor's customisable monitoring and alerting keeps you up to date with SQL Server performance, wherever you are. Free trial.

In This Issue

Templates and teamwork

SQL Server expert David Poole discusses how teams can work together and share templates in Management Studio. More »


Custom Metric - Indexes with Excessive Writes

A new custom metric is available at SQL Monitor Metrics. This tracks indexes that have more writes than reads. Use this code if you want to find out if you might be over indexing your tables. More »


SQL Server 2012 Integration Services - Introduction to Managing SQL Server with PowerShell

Marcin Policht presents the fundamental principles of PowerShell in the context of SQL Server 2012. Join him as he steps through its initial setup and configuration, and reviews specific management areas where its advantages can be realized. More »


From the SQLServerCentral Blogs - I'm an Administrator Why Can't I Copy Files

Hello Dear Reader!  I've been working on setting up a virtual environment for quite some time. When last I wrote... More »


Editorial - A New Type of Colocation Facility

Many of us in the technology industry have worked with a data center of some sort. It might be a closet in our employer's building, a dedicated room with separate power and cooling, or perhaps rented space at a data center facility. In my career, I've worked with a variety of data centers over the years, and it's been interesting to watch them evolve as new knowledge and technology becomes available. 

I remember having a dedicated room so cold that I kept a coat in by cube, even during the 95F summers. These days I have space in a Denver center that has hot and cold aisles. The latter still requires me to carry a coat, but any significant amount of time in the former means I'm down to just a t-shirt.

As cloud computing grows, capacity becomes important (along with bandwidth and reliability), but the ability to scale your computing capacity up or down may be more important as your customer base grows. Microsoft is taking on this challenge and looking to build"generation 4" data centers, which may be empty buildings that have power. In some places, these data centers might just be parking lots with power feeds and a fence.

The cost of construction can be extremely high for new facilities, but imagine a section of a parking garage, or even a secured lot next to your building. A container of servers is dropped off and you connect power, network, and maybe cooling lines (or maybe no cooling). We could potentially even have containers of computing machines and containers of storage. If we ever get cloud computing software inside of companies, this might be the way in which we handle our future data center needs.

» 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. Comments are definitely appreciated and wanted, and you can get feeds from there. Overall 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.

You can also follow Steve Jones on Twitter:

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


Question of the Day

Today's Question:

Can we create another computed column that depends on already created computed columns?

Consider the following table creation

CREATE TABLE COMPUTED_COL
(
A INT,
B INT,
c int,
d AS (A+B)
,e AS d+C
)
;
Will the table be created?

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

This question is worth 1 point in this category: computed column. 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.

SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.

Get your copy from Amazon today



Yesterday's Question of the Day

In SQL Server, large-value data types, because of their size, are sometimes stored separately from the normal row data on special purpose pages. Is data compression available for the data that is stored separately?

Answer: No

Explanation: The data stored off the row is not compressed.

Ref: Data Compression - http://msdn.microsoft.com/en-us/library/cc280449.aspx

» Discuss this question and answer on the forums

SQL Server 2012 Integration Services Design Patterns

SQL Server 2012 Integration Services Design Patterns is a book of recipes for SQL Server Integration Services (SSIS). Design patterns in the book show how to solve common problems encountered when developing data integration solutions. Because you do not have to build the code from scratch each time, using design patterns improves your efficiency as an SSIS developer. In SSIS Design Patterns, we take you through several of these snippets in detail, providing the technical details of the resolution.

Get your copy from Amazon today



Featured Script

Change database compatability level of all databases

Changes the database compatibility level of all databases to the given level. 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

Any experience with IBM D7000 Storage? - Note: Title of post should be V7000 not D7000! I have been involved in several disk subsystem upgrades and whenever the...

10 physical disks available - best configuration for data/log/backup? - I have 10 300GB SAS 15k rpm 6Gb disks available to me on a HP P2000 SAN. I have a...

java.net.SocketException: No buffer space available (maximum connections reached?): connect - Hi, I am using MSSql server 2005 SE with Windows 2003 Server 64Bit SP2 with 8GB RAM. I am using Java...

SHOW ADVANCED OPTION - Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. Msg 5832, Level 16, State 1,...

SQL Server 2005 : Business Intelligence

Replace function in ssrs - Hi All, am using a Stored Procedure in my report, for that I need to pass 3 parameter @string, @storeKey, @language. when...

how to create a radio button in ssrs - hi i want create a radio button in ssrs if i click radio butto(true) i want display some parameter else...

Custom DLL deployment - Hi, I have two SSIS packages which uses the Custom DLL in a script task. This Custom DLL has code which...

SQL Server 2005 : Data Corruption

Found a database error and need advice - I was testing some backups on a test server and found that a database generated an error when running CHECKDB...

SQL Server 2005 : SQL Server 2005 General Discussion

SQL 2005 Full Text Search / Contains Formsof Thesaurus not working - Hi, I can't seem to use a modified Thesaurus xml file on SQL 2005. I've modified the tsENG.xml, tsGLOBAL.xml, and the...

SQL Server 2005 : SQL Server 2005 Performance Tuning

Script to find Foreign Key missing Index? - Hi, just now I'm working with performance tuning on a SQL Server 2005. I need an script that can find...

SQL Server 2005 : SQL Server 2005 Integration Services

Identity column import - I need to import data of a table from prod environment to my dev DB. This table is having one identity...

SQL Server 2005 : T-SQL (SS2K5)

Getting recent 100 Records with filter on date range - Hello, We have one complex procedure which returns top 100 recent records ,it was taking too much time because of data,...

plz i need help!!!! - i want the entry for adding 2 value but i want show in the third cloumn all result with null...

How to Get Instance Name from T-SQL - Hi All, How to get Current Instance Name of SQL Server from T-SQL (i.e. from Query window)? Thanks in advance, Regards, Arun

SQL Server 2005 : SQL Server Newbies

Returning Windows Logon Credentials to a SQL Query - Hi All, I am using a trigger to update a table based on data changes - which is working well - but as...

SQL Server 7,2000 : Administration

float to decimal - Hi I have SQL Server 2000 - 8.00.2066 (Intel X86) Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3) with...

SQL Server 2008 : SQL Server 2008 - General

Stored Procedure as Data Source with SSRS - Hi All, I have a stored procedure with multiple paramaters like Start Date- custom calendar End Date-custom calendar Status - they contain multiple values Group namethey...

"kind of bug" with sql server 2008 - Seems like I posted my original post in wrong topic so putting it here again. Please ignore my old post...

How long a SP executed - Hi, I want to check how long an SP executed. The last last execution time was 2 hrs ago. Can any...

transfering data from one database to another - I'm needing to copy all the records from one database to another for just one table. Both DB;s are int...

Indexed Views - need some examples and advantages of indexed Views Please Regards AS

I am not able to connect sql server from cmd - in windows cmd prompt i typed the below command First.... C:\Users\sony>sqlcmd 1> second... C:\Users\sony>sqlcmd -U sa -P nuware@123 Msg 18456, Level 14, State 1, Server SONY-VAIO,...

SQL SERVER 2008 R2 Cluster and performi sql server backups to one shared drive - We have setup a SQL SERVER 2008 R2 Cluster with two nodes(Active/Passive) and three instances(i.e. one default and two named)....

I need to read the xml which is passed as an variable in stored procedure ?how to achieve that ? - I need to read the xml which is passed as an variable ,and insert its values to temporary table @msgchunk...

logical consistency-based I/O error - Hello, when i want to see properties of one data base ,or run maitenancetools or backup sqlserver give me this...

Dundas - Hi all, Anyone knows how much the dundas dashboard licence will cost? Thanks

Avoid getting messages while executing Stored Procedure - Hi, When i execute an sp am getting the below message. [quote]"Database name 'tempdb' ignored, referencing object in tempdb."[/quote] In this sp...

Stored Procedure does not pass the data to SSRS Reports - HI All, I have Stored Procedure that is being used by SSRS report as the source... When I select the custom...

Assign the variable based on the input - hi, I am having a requirement like this say if two table name is the input i will take 2 tables and...

T-SQL Question ----- Need Help. urgent - There is a Table. CREATE TABLE TBLCOLOR (ID INT, COLOR VARCHAR(20)) Insert into TBLCOLOR SELECT 1,'RED' UNION ALL SELECT 2,'BLUE' UNION ALL SELECT 3,NULL UNION ALL SELECT 4,'GREEN UNION ALL SELECT 5,'BLACK' UNION...

What Gives Better Performance? - Hello Everyone I hope that everyone is having a Fabulous day. I was in a discussion with a DB2 developer that has...

Script object into a text file - Hi All, After this: EXEC master.dbo.sp_configure 'show advanced options', 1 RECONFIGURE EXEC master.dbo.sp_configure 'xp_cmdshell', 1 RECONFIGURE --This works [code="sql"]declare @str varchar(100) select @str = 'declare @i int' print @str select...

Xquery -- Select not returning all the attributes - I have a table: [code="sql"]CREATE TABLE [dbo].[XmlTable]( [XmlId] [int] IDENTITY(1,1) NOT NULL, [XmlDocument] [xml] NOT NULL, CONSTRAINT [PK_XmlTable] PRIMARY KEY CLUSTERED ( [XmlId] ASC )WITH...

Seems simple, must be hard!! Cluster Instances, Linked Servers -- adjust Max Memory?? - This seems like it should be so simple, but apparently not! I have a 2-node, 2-Instance SQL cluster. Each server has...

Database replication - Hello folks - new to the forum and relatively new to SQL 2008. I have been given the task of trying to...

Failed Jobs report - Hi Guys, I need a script that will send me a complete list of failed jobs by looping through all the...

Corrupted Database - Issue: The database in corrupt status So far Tried: ALTER DATABASE @database SET EMERGENCY; GO ALTER DATABASE @database SET SINGLE_USER; GO DBCC CHECKDB (@database, REPAIR_ALLOW_DATA_LOSS) WITH...

Shrinking log is bad? - Hi All, I am aware that shrinking leads to fragmentation and doing it often is a very bad practice. Shrinking mdf...

Stored procedure explanation - Hi all, this is the first time am working on stored procedures, I need to make changes to the existing SP...

SQL SERVER CPU Usage 100 % even at no traffic time - HI, SQL SERVER CPU Usage shoots up to 100 % even at a time when user is not accessing application or any...

An easy way to synchronize data - We are about to begin User Acceptance Testing. The business users want to use a copy of "live" production data...

Import Excel using OPENROWSET only works for SA - In our development environment web application we're uploading excel files to the SQL server and importing them using openrowset. This...

Unable to install sql server 2008 Management studio - Dear Sir/Madam, I downloaded Visual Studio 2010 from microsoft so its automatically installed sql server 2008 R2. In Sql server 2008...

SQL Server 2008 : T-SQL (SS2K8)

Trying to get table size without sysobjects and sysindexes - Hi, I've been trying to replace sysobjects and sysindexes by sys.objects and sys.indexes in the well known query to get table...

How to select comma separated columns data - How to select comma separated columns data, i was using below query but due to large data it is killing...

Is there anybody can help me check the sqlquery to read the MDX query? It can't return any data - Hi who can help me check the openquery below? don't know why it can't return anything. but the MDX query...

Grouping timespans by the avg time per weekday - Hi There Long time - no see. I would appreciate a bit of help on a query I have to write. I work...

URGENT T- SQL QUESTION. NEED HELP. - There is a Table. CREATE TABLE TBLCOLOR (ID INT, COLOR VARCHAR(20)) Insert into TBLCOLOR SELECT 1,'RED' UNION ALL SELECT 2,'BLUE' UNION ALL SELECT 3,NULL UNION ALL SELECT 4,'GREEN UNION ALL SELECT 5,'BLACK' UNION...

identity table use case - SQL 2008R2 How to [b]insert / retrieve 3 identity values[/b] without using GO 3 ??:-) Also insert top(3) ... does not work either ... :w00t: Please...

Split String into 3 parts with a twist! - I have the following sample data (original and desired results) [code="sql"]with cteOriginal (CompanyName, CompName1, CompName2, CompName3) as ( select 'A V H S L...

Help on how to count guests in hotel every day - I have a table keeps guest records in a hotel. For each guest I have check in date and check...

SQL Server 2008 : SQL Server Newbies

Public Role Question - If a user is in the "public role" only. Do I need to grant them db_datareader to have read access...

create table script generation - Dear All I have created table with column constrains, default values. When I generate the script for this table from SSMS...

"kind of bug" with sql server 2008 - I am not understanding this behaviour of SQL Server 2008 (ent ed, sp3cu2). I configured my model database with adequate...

Worktables & Hash Tables - Hi All After testing and researching - I want to make sure that my understanding is correct regarding Worktables & Hash Tables >Worktables & Hash...

How have Trigger's example after insert send to mail on outlook?. - I create trigger after insert into table i want send mail on outlook and example trigger please. thank you.

Connect to a remote sql server using stunnel - Hello everyone, I am trying to connect to a remote sql server using stunnel. I have already configure the stunnel.conf file...

Stored procedure very slow execution - Hello, Please help me, I'm desperate. I have an old SQL2000 (SP4) - and no, I can't upgrade it, is in my...

Ring Buffers Memory Broker explanation required - Hi everyone, I'm looking at this ring buffer at the moment and i have a few questions about the details of...

SQL Server 2008 : Security (SS2K8)

Cross DB Chaining Madness - At the risk of posting yet [i]another[/i] message on cross chaining... I'm at my wits end. I've read and read...

Script Logins - Hi All Is there any way to script out all the Logins on a SQL Server instance, including server level privileges,...

SQL Server 2008 : SQL Server 2008 High Availability

Jobs not running in cluster - Hi , We have cluster environment with mirroroing . We have configured jobs to take the fullland log backups(all jobs in that...

Can I purge data on the principal without the purging it on the mirror? - Hi, I'm planning on using asynchronous, high performance mirroring to maintain an archive of my production database. The mirror will be used...

Mirroring Log Issue - Hi All, I have a db with mirroing in place and log is growing about 49GB.....Log is growing since log backup...

SQL Server 2008 : SQL Server 2008 Administration

SQL Server 2008 Enterprise SP upgrade - We are planning on doing a SQL service pack upgrade soon. Should we take the databases offline, or can the service...

Clone SQL Logins with same permissions and with different Usernames/Password - I need to create clones of existing logins in SQL Server on the same server (With the same permissions and...

Multi instance license with SQL Server 2008 R2 Standard in cluster - Hi, I have a SQL Server 2008 R2 standard instance installed in a Cluster (in the cluster i have two node). Now...

SQL Server Agent Job Creation and Management - Hi ... I have a requirement where I need to grant users permission to [b][u]create/modify/delete/schedule/execute[/u][/b] SQL Server Agent jobs on SQL...

connection failed - Hi All, I am using an evaluation of SQL SERVER 2008r2. I am using this on my PC to further my...

monitoring software. - Any one have used Solarwinds application server management tool for monitoring sql server and windows, we are looking for both...

Deadlock Graph from the xml from system_health extended event - How to get the Deadlock Graph from the xml extracted from system_health extended event. I'm using SQL Server 2008R2 SP2, and...

Low Performance - High CPU Problem and others... - Hello everyone, I got the Problem, that my SQL Server has always 97-99% CPU usage. We have snapshot isolation mode enabled,...

Red Gate SQL Monitoring fails - I just started a new DBA job and was introduced to SQL Monitoring from Red Gate. The program is not...

To configure the user name and login name for a database - Hi all, I created a database 'emptest' logging in using 'sa'. I have another database 'emp' in which i have used...

Service Pack Update error - Hi I have installed SP2 on 2008 R2 successfully,but when i tried to connect got error Login failed for user '<Domain...

SQL Maintenance job - Manual run/Scheduled run - Hi All, We have a weekly full backup job, daily differential backup job and hourly transaction log backup on our servers....

Invalid Object In SQL Server 2008 database - Hi, I am trying to find out all invalid objects in SQL Server databases.Could anyone of you give me a script...

Career : Certification

Passed 70-448! - I passed the 70-448 exam for the [url=http://www.microsoft.com/learning/en/us/exams/70-448.mspx]MCTS: Microsoft SQL Server 2008 Business Intelligence Development and Maintenance [/url]certification this weekend....

Career : Employers and Employees

To the experienced SQL people out there: How are you titled/how do you title yourself? - I'm a programmer. I've been a programmer for about 14 years, starting with C and C++ (games development), then moving...

SQLServerCentral.com : Anything that is NOT about SQL!

Web application design query - Hello, I am new to web application designing and using .net (MS Visual Studio 2010) to design an application. The issue I...

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

Reporting Services : Reporting Services

RIF document is not compatible with this code version - We are running SSRS 2012 in Native mode and just started getting the following error when trying to render some...

Can anybody tell me where the SQL server SSRS 2008 sample reports are please? - Hello, As the subject says above, I do not want the R2 versions, I need the original 2008 versions, but all...

Separating Report Manager from Database - Is there any way to host the Report manager on an IIS Server and the database for SSRS on a...

Reporting Services : Reporting Services 2005 Development

subscription issue - I have a report developed in ssrs 2005 and it runs on 2008 report server. It has 5 parameters (out...

Database Design : Design Ideas and Questions

Database designing : re-enggineering project - can anybody help me with steps to consider for "designing the database for an re-engineer project" ? or any link or...

Data Warehousing : Integration Services

How to consume WCF service in SSIS with SQL Server 2005 SP2 - hello All, Can someone explain me how can u consume a WCF service in SSIS using sql server 2005, the requirement...

Import and Export Wizard: Invalid Internet Address when importing Excel from a web page - I'm running SQL Server 2008 R2 on a Windows 2008 R2 server. [url= http:\\www.eia.gov\forecasts\steo\xls\STEO_m.xls] http:\\www.eia.gov\forecasts\steo\xls\STEO_m.xls[/url] I can open this file in...

Getting DTS_E_INDUCEDTRANSFORMFAILUREONERROR - Hi, I am using SSIS 2008 and i have to push data from SQL Server 2008 to Excel 2003. In my package...

SSIS DT_NTEXT to DT_STR conversion failure unicode and non-unicode Excel - Just google "derived column dt_ntext to dt_str not working" and you will find numerous cases where people have difficuilties importing...

Data Warehousing : Analysis Services

How Aggregation is calculated in Cube in SSAS - Hi, I am new in ssas. I want to know the why do we need to create aggregation in measure while...

SSAS browser missing Data - Hi all, I have a new SSAS Cube that I have designed and I am finding that the data doesn't seem...

increasing Excel 2007 "Show Details" limit above 1000 rows? - Hello everyone. I am using the Excel 2007 Pivot Table "Show Details" functionality and find it limited to 1000 rows. I thought...