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

The Cloud

I like the cloud. It's very handy for a lot of the things I do. I like having backups restored for my iPhone upgrade. I appreciate having my documents synced through Evernote, Dropbox, and OneDrive (formerly SkyDrive) automatically moving to new machines. These services are incredibly convenient and handy. I expect that my mail will be accessible from multiple machines and my blog posts can be created, edited, and published from anywhere. Many of us work in a similar fashion, using the cloud as a service construct in much of our lives. In fact, many of us expect our own knowledge will be supplemented by the cloud. We use Google to search, getting us syntax,  solutions, or ideas from sources that we expect to just be there.

Someone was talking to me about their concerns with the cloud recently. This person thought the cloud would be a fad that passes quickly and businesses will get back to owning, hosting, and managing their servers from the bare metal up to the network connection. I disagreed, and not because I use the cloud personally.

I remember setting up a web server in 1996 for a company. I remember installing an email server in 1999. I would never do either of those things again for my own company, and I wouldn't expect it from most companies. These days we've learned that email can easily be handled by a third party and more and more companies are using email services instead of managing their own systems. Web servers are mostly a shared service that we rent from any number of other companies, sometimes even stitching together a presence across multiple providers. Even many companies that want to manage their own host operating system are turning to third party companies to manage the hardware and networking. More and more we accept renting the things we need from others.

We'll get there with databases as well. Not all databases, but more and more of them will be hosted at third party companies. Whether this is in some type of VM environment or a service that hosts data, it will still be hosted at a third party. We will have concerns and we will have reasons to not do this, but I think for more and more of our data, we won't care.

Companies have lots of systems in place. They have legacy investments in infrastructure and facilities. In those cases, it's hard to justify the cost of cloud computing. However as we grow into new areas, or with new companies, we'll have to re-evaluate whether it is a good idea to continue to make those investments. As the management of software grows to allow the quick scale up and down of assets, I think we'll be much more likely to consider moving applications into the cloud than ever before. 

We'll never be 100% in the cloud, or out of it, in the future, but increasingly, we'll be partners with the cloud.

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 ( 3.4MB) podcast or subscribe to the feed at iTunes and Mevio . 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

WANTED

Joe DeeBeay
Hard-earned lessons
Resident of I/O Gulch

THE CHARGE:
CRIMES AGAINST THE DATABASE


KNOWN ASSOCIATES:
"SCARY DBA"
JON KEYAHIAS
STEVE JONES


READ THE TERRIFYING TALE OF THESE DATABASE DESPERADOS
SQL Server Backup and Restore eBook

FREE eBook - SQL Server Backup and Restore

Download Shawn McGehee's free eBook and learn how to set up a reliable backup and restore plan. Then, use SQL Compare to compare and synchronize databases straight from a backup. Get the eBook.

Featured Contents

 

Sending a Variable Number of Elements in a Parameter

Alex Grinberg from SQLServerCentral.com

What are your options for sending a variable number of choices in a parameter to a stored procedure? Alex Grinberg looks at three techniques you can use. More »


 

The Performance of the T-SQL Window Functions

Additional Articles from SimpleTalk

Window Functions in SQL greatly simplify a whole range of financial and statistical aggregations on sets of data. Because there is less SQL on the page, it is easy to assume that the performance is better too: but is it? Dwain gets out the test harness to investigate. More »


 

From the SQLServerCentral Blogs - Virtualization resource consumption counters lie to you

kleegeek from SQLServerCentral Blogs

OK, so maybe they do not lie to you, but I got your attention. In virtualized environments, the performance statistics... More »

Question of the Day

Today's Question (by Steven Neumersky):

A week of Analysis Services

What operations can run in a parallel (multi-threaded) manner in an SSAS 2012 Tabular Solution? 

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: Performance Tuning.

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 Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steven Neumersky):

A week of Analysis Services

True or False: DAX is the only query language supported by the Analysis Services Tabular Model.

Answer: False

Explanation:

False!

Although DAX (Data Analysis Expressions) is the primary query language for the SSAS 2012 Tabular Model, the tabular model will accept MDX queries.

Ref: http://technet.microsoft.com/en-us/library/hh212940.aspx#bkmk_lang


» Discuss this question and answer on the forums

Featured Script

Server_Config_Script_2012

Patrick Akhamie from SQLServerCentral.com

Here's a quick query you can run across all your servers (2012) to find a wealth of information like service pack, edition, number of CPUs and RAM.
Even more information is available if you want to add additional SERVERPROPERTY attributes or fields from one of the DMVs.

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 : Development - SQL Server 2014

Hierarchical order by TSQL - Dear Sir create table Hierarchy ( ParentID int, ChildID int ) go insert into Hierarchy values (101,1),(1,6),(101,2),(2,4),(2,5),(5,6),(5,7),(101,3),(3,5) Please refer the Hierarchical order Diagram in order to understand how...

Please help - enter------------------------------intvalue--------out----------------intvalue 2014-02-05 08:56:51.230 -- 1----2014-02-05 08:57:05.990--- 2 2014-02-05 08:56:49.320--- 1---- 2014-02-05 08:57:03.490--- 2 2014-02-05 08:56:45.097--- 1---- 2014-02-05 08:56:57.840--- 2 2014-02-05 08:56:42.640--- 1---- 2014-02-05 08:56:55.727--- 2 2014-02-05 08:56:42.640--- 1---- 2014-02-05 11:37:46.493--- 2 2014-

UNABLE TO RETRIEVE data while using between operator - Hi Experts, I came across a weird issue this morning while using Between operator am unable to retrieve data that starts with...

Subtotal when vendorcode changed. - Hi Experts, i need to write a stored procedure for a table with below columns for instance the table had 5 columns...


SQL Server 2012 : SQL 2012 - General

Scripting objects into TFS automatically - I'm looking for a way to automatically script database objects into TFS nightly. I've looked at ApexSQL Diff, Red-Gate, Randolph,...

How do I find out server name and instance name? Thanks - A very silly question: :blush: I just upgraded from SQL 2008 R2 to SQL 2012 and also installed Data Tools. I tried...

permission to users? - HI, 1.perticular user is only created for databses only? 2.perticular user is only created for stored procedures nad alterd also? 3.perticular user is...

OS Disk Capacity Information - Hi I'm looking for the most straight forward way of populating a table that will record OS Disk space used for...

linked server creted permission to a user - I want to assign such rights to a remote user so he can create a new linked server and can...

Getting wrong data from Oracle when using SQL Server Data Tools using Attunity - I am creating an SSIS package. The package reads data from a table in Oracle and then inserts it in...

smo scripter changing the ordinal position of columns - I am using powershell and the smo.scripter object to create scripts to create tables. About 10% of the tables that...

Msg 0, Level 11, State 0, Line 0 in SQL Server 2012 - I have received this message on two different activities. The first time was when trying to move one table to...

Downsides of running 2012 MSX with a mix of 2012 and 2008R2 TSX's? Is it supported? - Per this TechNet article, older version TSX is not supported with a more recent version of MSX. However, I have...


SQL Server 2012 : SQL Server 2012 - T-SQL

Odd (n)VarChar Behavior - Run the following: [code] Declare @v nVarChar(4000); -- Test 1 Set @v='Select * from sys.indexes where type=0'; Select @v,Len(@v),DataLength(@v),Cast(@v as VarBinary(128)); Print @v; RaisError(@v,10,1) with NoWait; Exec(@v); Exec sp_executesql @v; --...

Bad performance when using parameterized query with like in where clause. - Hi all, from MS Dynamics NAV 2013 I get a lot of querries that have a where clause like this: where...

Exclude NULL values from select statement - Hi, Can anyone help me with this problem? I wrote a select statement, I only want to see orders with max...

sql case when statement - Hi below is the scenario which I have currently in my query. I need to write this query without any hardoce...

Get list of all workers having same SET of Rates - Hi All, I have attached some test data for you that has two temp tables "#worker" and "#worker_rate". The issue...

Exclude Weekends and Holidays - Hello, I have already created a table name 'tblHolidays' and populated with 2014 Holidays. What I would like is be able...

using a user defined function in a view - need help - Hi, I have a function that accespts a string and a delimeter returns the results in a temp table. I am...


SQL Server 2008 : SQL Server 2008 - General

OS file mover software (please read) - I know this isn't the right place to ask this, but I can't find any other place to ask. I'm looking...

export output of set statistics io to excel sheet - Does anyone know how to export output of Statistics SET IO On to excel sheet?

Unknown Query... - Hi All, We have a Cube that will be refreshed daily, and lately its been taking more than an hour for...

How To Capture ALL Data Retrieval Actions Regardless of Method - How to construct a SQL Profiler Trace That Will Capture all Data Retrieval actions from a specified SQL Login I need...

Error from a service. - We have a service that runs regularly. What type I have no idea, Im new here. Developed in C# .net...

The SSCM SQL Server Service - The server threw an exception. [0x80010105] - Hello, I need you help good people. I installed SQL Server 2008 R2 Ent SP CU6 on windows server 2012 failover...

Issue with UNION in stored procedure - Hello, I am creating an SSRS report for that I written a stored procedure where it describes the total amount...

table with a column be primary key and foreign key at same time - hi everybody I have two table that have many to many relationship so i add table between them.and this table column...

Using Profiler to obtain SQL executed by an encrypted Stored procedure - Hi Everyone, Is it possible to use SQL Server Profiler to viewthe SQL that is being run by an encrypted Stored...

bcp import error numeric value out of range - Hello, I have table with columns of type int. I export this table by using bcp: bcp dbo.int_table out file.dat -q...

First and last records by reference number - Hi all I've got to be able to pick up the first and last records from a list and I need...

Time between range - Shift_table Shiftno starttime endtime 1 06:00:00 14:00:00 2 14:00:00 22:00:00 3 22:00:00 06:00:00 Now i've an information that an employee works @ 03:30 AM, need to...

update stats - i need to find when the last update of stats on a database and also need to check the fragmentation...

using for XML PATH to make html by SQL - Hello I want to make HTML below by for xml path in sql. <div class="navi clr"> <span class="prev disabled"> <i></i> </span> <span class="active">1</span> <a...

getting substring of column data - I wish to get a substring of data from a column which has URL. example: http://www.xyz.com/region/department.asp?FID=8907 is the data in column...

Remote Stored Procedure call - Hi, I have two different databases in two servers(server1, server2). i would like to call the server2 database SP in server1...

Help with date in sQL - I have date field named "[Latest Filled Date]" - format smalltimedate. I'm trying to do-If the "[Latest Filled Date]" equals the...

Error 233 - Hi, I am not very professional in sql server. I restored msdb from another server, but I did not pay...

Need case expression for sql select statement - Hello, how can I write a sql select statement using case I have a column called type id which contains id's of...

Suitable SQL Server Management tool - Hi First time poster on this forum so I apologise if there is already a topic about this elsewhere or even...

Does LiteSpeed works good for SQL 2012 - Can you advice whether to go for Litespeed. I've >1TB databases setup on SQL 2012.

SQL case when statement( without hardcode values) - Hi below is the scenario which I have currently in my query. I need to write this query without any hardoce...

Processor Affinity - Why does this happen? - I've been battling away with a very badly designed application which is causing some issues on one of my SQL...

last 6 months data - Hi, Below is my table structure, Table Name : MemberVisit Columns: Id,Visiteddate,PutchaseAmount sample data: [code="sql"] select * from( select 1 as Id,'2014-01-13' as Visiteddate,20 as PutchaseAmount union all select 1 as...

memory issue: manual memory settings - we have a server which has SQL 2008 R2 on it. Its in a cluster and we have set it up...

Invalid Object Name Mystery - how to find the history of a table - We have a SQL 2008 R2 box and run SSRS in native mode. Last night we had several reports run. Out...

Errors during update Statistics - Hello, I've started getting errors in my nightly maintenance job during the update statistics portion. They're all slightly different, but along...


SQL Server 2008 : T-SQL (SS2K8)

How To Simplify Code Structure - How can the following code be rewritten so it looks like a list rather than repeating Not Like ... [code="sql"]HAVING (NOT...

Sysjobhistory - Step Fails but Job (Step 0) reports as successful - Hi, we have numerous scripts in place to track job failures etc. But I've noticed a few times that our...

add a column and get other column names as its value - here is a sample table [code="sql"]DECLARE @t TABLE(a INT,b INT,c INT); INSERT @t VALUES(1,2,3),(9,8,7),(4,6,5); SELECT * , ( SELECT MAX(val) FROM (VALUES (a) , (b) , (c) ) AS...

Can't get image to update. - I am using Data Compare which does the following: UPDATE [dbo].[EmployeeImage] SET [ImageData].WRITE(0xffd8ffe000104a46494600010001006000600000fffe001f4c45..., NULL, NULL) WHERE [EmployeeImageID] = 9 when I go back later and...

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

Need help on SQL script - Hello, I am learning SQL and wondering if someone can help me with script below – not sure if I am...

Need to capture the Updated Column name - hi i need to capture column name using trigger for a table which are getting changed For Ex: Create table #TempTable1 ( Colum1 int, Colum2...


SQL Server 2008 : SQL Server Newbies

Database mail alert fails for group account - This is a new SQL Server 2008 R2 standard edition 64 bit environment. I've been down this path before. I'm...

Returning multiple records when only one is specified - Hi, can someone please explain something to me. SET @NAMEID = '14359' IF @ADR2 IS NULL AND @ADR3 IS NULL SELECT ADR1, POSTAL_CODE, (STATE_NAME)...

Query with most expensive CPU usage - I find out a few top cpu consuming queries, what should I do with them? Thanks.


SQL Server 2008 : Security (SS2K8)

Multiple Schemas means Multiple Users? - Hello All, I have db consolidation task in hand. We have a one parent db and 10 child dbs. I want...


SQL Server 2008 : SQL Server 2008 High Availability

SQL SERVER 2008 R2 transaction log shipping - I have setup transaction log shipping in dev and QA successfully. But, on Prod log shipping everything working fine, the backup...


SQL Server 2008 : SQL Server 2008 Administration

CPU always utilize 60% constantly? - Hi, CPU always utilize 60 % constantly, attached here execution plan. I checked execution plan handle CompileTime="9" CompileCPU="9" = 81 Entries for that query,...

Query to find blocking is getting blocked. - I have this query to find blocking: [code="sql"] SELECT DISTINCT sp.spid SPID, sp.blocked BlockingSPID, DB_NAME(tl.resource_database_id) DatabaseName, es.Status , (SELECT Text FROM sys.dm_exec_sql_text(sp.sql_handle)) SQLText ,...

DB Average Wait Time is too high - hi guys, i am currently working with setting up scom alerts for my sql 2008 r2 enterprise instance. There is...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Execution Plan vs DTA missing index recommendations - Hi, looking at a whole bunch of select statements with a view to tuning etc etc . For the first one I...

Is this SARGable? - Assuming we have a players table with a kazillion records with PK and clustered index on playerid (BIGINT) and nonclustered...


SQL Server 2005 : Administering

Service Pack question - Hi I just have a question regarding service packs and security patches. We have an old legacy box on 2005...

SQL job is getting hanged - We have sql2005 standered edition and now a days one sql job is getting hanged frequently. But if i stop and...


SQL Server 2005 : Business Intelligence

What transformations will I need? - Hi all, we are rewriting a large number of DTS packages, I have done a quick sample audit of the...

SSAS/MDX Calculated member - Excel Mode function - Hello, I need some help. I am quite new to MDX; I've created a cube (SQL Server 2012)and the measure needs...


SQL Server 2005 : SQL Server 2005 Strategies

snapshot isolation level usage - Dear All, There are some transaction tables in which more than one user add and update records (only). what ever they...


SQL Server 2005 : SQL Server 2005 Integration Services

Script component to convert large csv to multiple .xlsx files in C# - Hi Team, Need to convert large csv file(ex, 5 million) to multiple excel sheets(each sheet of 500,000). Please suggest how to...

How comma separated values are divided into rows? - Hi Experts, I have the input: rank country city 1 india hyderabad, bangalore, delhi, shimla 2 usa newjersey, newyork, washington, texas 3 uk london, greenland, denmark, italy, spain expected output: rank country city 1...

Approach to store the value of gridview checkbox column checked in component UI - All, I am a new bie to SSIS. I am facing a particular problem of trying to communicate the value of...


Reporting Services : Reporting Services

Showing sales territory names on a state map - I can create a basic map of the sales territories. However, the territory name displays multiple times instead of just...

Reporting Database and OLAP combined? - I am planning a couple of projects and wondered if I could combine efforts. We have two specific goals: 1. Reduce load...

Page size problems - A very strange problem - a report (SSRS 2012), when run on a user's machine at another office renders to PDF...


Reporting Services : Reporting Services 2005 Development

How to call different results from stored procedure to SSRS report - Hello, I am creating an SSRS report in that I want to create three fields 1.Subtotal 2.Grand total 3.Admin total For this I created...

create a report with separate tab for each day of month in excelsheet - Hi, I wanted to create a report with separate tab for each day of month in excelsheet . 1. I have table...

Tabbed Reports in SSRS - Gurus, I have a requirement where in the client is asking for Multi - tabbed reports in single report. For Example, In...


Reporting Services : Reporting Services 2008 Development

Show All Rows When a Parameter is Null - I'm working on a report that shows the outcomes of certain activities. The report was built some time ago and...

SSRS 2008 reporting issue - Hello, I'm new to this SSRS development and facing a bug improvement issue. I have one report where data gets...

SSRS 2008 conditional formatting with multiple conditions - Hi, I have a requirement to conditionally format cell (not row) backgroup colors using SSRS expressions (not custom code) based on...


Programming : XML

Xml Query - Hi, I would like to send an email to a customer with deadlock information. I did set up an event notification to...


Data Warehousing : Integration Services

Developers and SSIS Packages settings in Visual Studio - We are using SQL Server 2012 EE SP1 and Visual Studio 2010 Shell. We are just getting into creating SSIS...

SSIS - Copying files from Dropbox - Hi guys 1- I'd like to perform a ForEachLoop in order to get a list of files from Dropbox and subsequently copy/move...

Retaining x number of copies of files and purging the rest? - Hi All, I have a process which grabs a csv, loads it, renames it and moves it into an archive folder....

30 Columns From FLAT file + 1 Column from Table??? - New to SSIS have done mostly Import Export wizard jobs with small modifications. I have a Flat File Source that has...

Deploy package to multiple servers - Hi, we currently have several servers running SSIS packages building tables for a data warehouse. These packages were created once and...


Data Warehousing : Strategies and Ideas

Fact table for each KPI - Still new to BI design methologie. When im building my facts tables is it generally accepted to to have one fact...


Data Warehousing : Analysis Services

UnKnown Query generated in Backhand... - Hi All, We have a Cube that will be refreshed daily, and lately its been taking more than an hour for...

SSAS Multidimensional Model Book - Hi, Can anybody recommend me a good SSAS Multidimensional model book? Preferably 2012 but 2008 is OK as well. I know...


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

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


SQLServerCentral.com : SQLServerCentral.com Website Issues

Not receiving daily newsletters - Has anyone else stopped receiving the daily newsletters via email? The last one I got was Friday 15th Nov.


SQLServerCentral.com : Articles Requested

T-SQL Comparing Rates - A writeup based on this thread. Show how this works and why one method may be better than the other [url]http://www.sqlservercentral.com/Forums/Topic1537283-3077-1.aspx[/url]

Updated Explanation on Parsename - Explain how parsename works and where it's appropriate.

SQL 2012 Paging - A piece that shows how you can page sets of results, say 5 at a time from a table for...


Career : Employers and Employees

I'm .NET Developer with 3 years of experience. Looking to change career to DBA. Advise please. - Hi All, I've been working as .NET Developer ever since I grad from college 3 years ago, I've been staying in...

Interview with the CTO ?! - So I've had three successful interviews (including one technical) with a company and has been scheduled for the last round...

How do you describe what you do? - You're at the dinner table with your in-laws, and the conversation turns to what exactly it [i]is[/i] that you do...

Advice Please - To Specialize or not to Specialize That is the Question - Hi All, I'm hoping for a little advice from people who are more experienced than myself (plenty on here :-)). I...

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