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 Subtle Push to the Cloud

With SQL Server 2014 released, there's the temptation to upgrade for many DBAs. However the licensing costs and debatable improvements in the product will temper the DBA's enthusiasm with the reality of the ROI seen by management. While reading about the licensing changes, I also saw this note from Tom LaRock, where he wrote about the features most of us aren't using. It made me think about upgrades, and perhaps the strategy Microsoft is employing.

As Tom mentioned, the features not being used are Enterprise Edition features. This prevents many of us from upgrading to use them because Enterprise Edition is so expensive. Actually, even Standard Edition is expansive these days, given the per-core licensing, and I suspect lots of companies with SQL Server 2008, 2005, even 2000 are debating whether or not the upgrade is really worth the cost.

The piece also mentions that Azure is much less expensive in the short term, and you should consider it. Of course at some point the money you pay will be more than buying a license and a server, but that assumes you run them for the same length of time. You'll likely upgrade at some point, and if you upgrade both hardware and software, the cloud starts to look more attractive.

It's not simple to move into the cloud, nor is it appropriate for some applications, but it does seem that Microsoft would prefer to have most companies running in Azure, on a single platform they run, they patch, and they support. Many companies might prefer the same thing, though I do worry that we might find the on-premises version of many products becoming second class citizens. Vendors will spend less on development and support if too many customers move to 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 ( 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
The Girl with the Backup Tattoo
Read the free article
Heroes
Robyn Page
Grant Fritchey
Steve Jones
And Introducing:
Maria
Villains
Raul
Bruno
Gabriel
Critics Say...
I'll never look at a Pina Colada again!
- The Daily Backup
 
Bandits, booze, and backups - it's a triumph!
- The Offsite Herald
 
Nobody puts backups in the corner is this story!
- Morning RESTORE
 
Russel & Scott vigorously nod their heads approvingly
 
Read how the DBA Team came to the rescue once again, thwarting a sinister plot of corporate sabotage.
 
Read the free article

Featured Contents

 

Duplicate Detection and Management

Edward Pollack from SQLServerCentral.com

Inevitably, every DBA is eventually asked to delete, merge, or otherwise report on duplicate data. There are many tools at our disposal to make this task both simple and efficient to complete. Read on for simple steps and examples to effectively deal with duplicate data. More »


 

Moving from Practice to Production with Test-Driven Development

Additional Articles from SimpleTalk

Test-driven development is often taught using simple examples, such as calculating the scores for a game of ten-pin bowling. Using the same practice effectively on a real code base isn’t as easy. This article covers some of the questions that arise when dealing with larger code bases and changing requirements. More »


 

From the SQLServerCentral Blogs - FileTables–Inserting Directories from T-SQL

Steve Jones from SQLServerCentral Blogs

Creating a directory in a Filetable share is easy. It looks like this: It’s hard to see, but this was a... More »


 

From the SQLServerCentral Blogs - How to install SQL Server Failover Cluster from SQL Server 2008 onwards ?

Steps to install SQL Server Failover Cluster from SQL Server 2008 onwards :- 1) Open SQL Server Installation Center > Go to... More »

Question of the Day

Today's Question (by Steve Jones):

I have upgraded my instance of SQL Server to 2014 to take advantage of memory-optimized tables. If I do not want the cardinality estimatior to be used in a specific database, what can I do?

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 2 points in this category: Administration.

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

Expert Cube Development with SSAS Multidimensional Models

Expert Cube Development with SSAS Multidimensional Models will teach you tips and tricks for cube design from some of the most experienced Analysis Services experts in the world. Topics covered include designing dimensions and cubes, implementing common MDX calculations, security and performance tuning. Get your copy from Amazon today.

>

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

When is an automatic checkpoint taken for memory-optimized tables in SQL Server 2014?

Answer: When the log file is 512MB larger than the last checkpoint

Explanation:

The automatic checkpoint for memory-optimized tables runs after the log increases 512MB after the previous checkpoint.

Ref: Checkpoint operation for memory-optimized tables - http://msdn.microsoft.com/en-us/library/dn553124%28v=sql.120%29.aspx


» Discuss this question and answer on the forums

Featured Script

Format decimal value to fraction using a tally table.

Adrian Facio from SQLServerCentral.com

This function takes a decimal value and returns fractional representation of this value.

SELECT dbo.DecimalToFraction(12.5) 

Result: 12 1/2

The interesting thing about this code is that it uses a tally table to find the smallest denominator for the decimal part.

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

How to configure transnational replication Between two different domains and non trusted domains - Hi, I am new to replication. Is it possible to configure transnational replication between two different domains also non trusted domains. It's...

IT Bootcamp Training from Mercury Solutions - [b]Bookmybootcamp.com[url=http://bookmybootcamp.com][/url][/b] is the brain child of Mercury Solutions Limited, a leading offshore training provider in India. We offer both open...

Restriction on DML Statements in SSMS - Hi, I would like to know if there is any option to Restrict DML statements in SSMS for a user...

Stilhaus Kitchens Reviews - What a great forum this is. Full of fantastic tips and information. So glad I found it.

Going from SQL 2008 R2 to 2014 - I've got SQL Server 2008 R2 Developer Edition on my desktop (I think it's a 4 year old machine). I've...


SQL Server 2014 : Development - SQL Server 2014

Anyone Using or Planning to Use Memory-Optimized Tables? - I was just wondering if this feature will be used in the real world. Not being able to have identity columns...


SQL Server 2012 : SQL 2012 - General

Backup "fails" - A few months ago, I added a simple, one-line job to backup one of my SQL Server 2012 databases -- a...

Disk Space required for Express edition engine vs Developer - We have a debate in my dev team on what edition of SQL should be installed on a VM template...

Always ON setting up a C node - I have an A & B node set up and running. I now want to add a C NODE. The catch...

SQL 2012 Maintenance Plans[Full-Backups] fails - Hello, I have created a database backup maintenance plan on my new SQL 2012 Instance and they are failing with the...

Rebalancing data in file groups. Need help - I am looking for the easiest way of rebalancing data across multiple files. Instead of creating a secondary filegroup and...

AlwaysOn High Availability group showing all Databases. - Hi guys, I came across an issue while migrating from SQL 2005 to SQL 2012 and using AlwaysOn Group. For...

Syntax error - use msdb if exists (select sysjobs.name as [Job Name], sysjobservers.Last_run_outcome, sysjobservers.last_outcome_message, sysjobservers.last_run_date --sysjobschedules.next_run_date from sysjobs inner join sysjobservers on sysjobservers.job_id = sysjobs.job_id where last_outcome_message like...

Hosting Application server and db server on same machine - Hi, We have request where client want to host both application server(IIS...etc) and MSSQL DB server on same machine.( DB is...

How to Explain to Non-IT people about instances - Hello, This might seem like an odd question, as this is the 1st company where most of our IT servicers are...

SQL Design Question - Hi, I am designing a database and would appreciate some thoughts. I am thinking about creating a Telephone table to handle...

SQL Stress Test Tool - I need to find some sort SQL Server stress test tool to test performance on Inserts, Updates, Deletes possibly on...

Edit script on Script Task hangs when VB is selected but opens when C# is selected - I googled and searched on this and can't find anything about this specific issue. Has anyone ever experienced this? It...

How to Install BOL Books OnLine Locally - Has anyone been able to install BOL on the SQL Server 2012 itself? In 2008 and earlier, if BOL was installed,...

Trigger and commit - Dear All I have a update trigger. In this trigger I need to insert few records in 3 tables. If error...


SQL Server 2012 : SQL Server 2012 - T-SQL

Create view with exploding rows into multiple - I have a table like below: ItemId Amount Tax1 Tax2 SrvType 111 100 10 20 1 112 200 10 2 113 300 10 30 3 Now I want to...

Left join or not Left join ? - Hello, I'm requesting your help for any ideas that could help me to do a better query, I'm trying to match...

update query very slow sql server - Dear friends, my table have 100000000 records. i update the data with query like update ALL_MOBILE_DATA_PART set DistrictID=3 where FULL_ADDRESS...

recursive queries - parent child - Hi everyone i need to make some parent-child transformation. here is test input data: [code="sql"] CREATE TABLE #TestTable( [Code7] [varchar](7) NOT NULL, [Code1] [varchar](1) NOT...

Need set based method to insert missing records into table - right join doesn't work - I apologize if I don't set this up the appropriate way as this is my first time requesting help and...

Get original order quantities and dates, and find any changes or additions to quantities in subsequent order version(s) - I am due to work on this problem, but I have a lot of trouble trying to figure out how...

What is wrong with this syntax? Query will work, but CTE will not "compile" - [code="sql"]with UnloadDates as select DISTINCT ShipmentID, (select Min(starttime) from tblInvoice I where I.ShipmentID = O.shipmentID and DataSent is null ) StartTime, (select Max(Endtime) from tblInvoice I where I.ShipmentID = O.shipmentID and DataSent...


SQL Server 2008 : SQL Server 2008 - General

Copy Database and Identity - We have a database running on a SQL 2008 R2 server. The database has a table with a single column for...

Indicator to remain in one cell - In SSRS, I have a drill down report with three columns. One column says 'yes' or 'no.' The other column...

Select statement - Effective running - Hi All, I have an select statement which needs to be run 15 times with a slightly different where clause and...

Calculate elapsed time in transaction statement - Hello everybody, Is it posible to know the elapsed time after I execute a transaction statement in SQL? I'm killing the...

Access with ADOX too slow - Hi My questrion is about connection to DB. I had migrate my DB Access to DB SQL Server 2008 and I'...

Sample Databases like Adventure works - Hello folks, Does anyone know of any other sample databases other than adventure works for some training purposes(other than Northwind too,...

Transport-level error referring to "network name is no longer available" - but not referring to name... - Hi All, I'm continually getting the following error condition from a C#.NET 4.0 console application we run: A transport-level error has occurred...

how to see discarded job history - Hi All, Is there any way to see discarded job history ? Because I am not able to see the history of...

Restriction on DML Statements in SSMS - Hi, I would like to know if there is any option to Restrict DML statements in SSMS for a user where...

How To Get Login Existence in mutiple databases - I have three databases in sql 2008 such as db1, db2, db3 and a login user "gaurav" this login have...

Adding parameters to SQL in Excel - Hello All, I have excel spreadsheets that I use to connect to SQL Server by ODBC for my end users. I...

Error when opening BIDS 2008 R2 - SQL Server 2008 R2 - Urgent - Hi, from two days when I launch BIDS 2008 R2 I've an error that says it isn't possible to find one...

Creating .mdb file from sql server db - Hello, This is my first time asking a question in this forum. I hope y'all (yes, I'm from the south) can...

Distribution of data, percentile curve. - Dear Reader, Fan: Of Percentile curves in Excel. This presents in Excel a value (or a count of values) and the percentile...

Calculate average through recursive CTE - I am new with CTE and need help from you guys. I have a table FeedFileDetails which stores all the zipfile...

Help, Copying table data with Store Proc - I am needing some help copying data from a table on another server back to my server instance. It will...

unable to connect to the instance - This is the error I am getting: A connection was successfully established with the server, but then an error occurred during...

Installing Management Studio 2012 with SQL Server - Hi Everyone, I have just successfully installed MS SQL Server 2008 R2 onto my Windows 7 (Professional - x64) computer. I would...

Error installing MS SQL Server R2 Enterprise (x64) - Hi Everyone, Recently I attempted to upgrade from MS SQL Server to MS SQL Server R2. However I have encountered an error,...

Transaction replication lock issue - Hello team, I setup transaction replication between 2 servers and facing locks issue where when replication is running no one...

Stopping a check integrity DB job what will happen? - Hi friends, i have a huge datawarehouse DB (750 GB) with 30 tables, i have never run maintenance plan before i.e....


SQL Server 2008 : T-SQL (SS2K8)

Outer Join performance - Can someone please give me advise on a better way to write the following? SELECT a.BoxId, b.field1 as value1, c.field1 as...

SQL DB Mail - Hi, I'm sending report based on below DB Mail query from mentioned data format table. But i'm getting invalid format...

conditional join - I have 6 tables in a query and need to get records from tables like TBL_A,TBL_B and Rest of the...

Performance related question - This query takes 2 mins to execute, Please suggesr if we can improve more on performance SELECT P.ProgramId ,P.Tier4Id ,7...

Create batch file to selectively run SQL files - I have about 1200 sql files in one of my folders. Almost all of these files do data inserts and...

SQL Help requested to Get Daily and Weekly OT - Hello Everyone, I need to pull a report from a table which gives me daily totals, I'm asked to get regular...

Filtered index with IS NULL predicate - Hello everyone. I believe query optimizer can leverage the predicate used to define the filtered index. But I came to a...


SQL Server 2008 : SQL Server Newbies

Error in Drop Create stored procedure. - New at SQL Server 2008 R2 ... The script below generates a stored procedure. Just recently I start getting an error...

Left Outer Join, Multi Tables, To Populate Checkboxes in Classic ASP Application - Hi, I've been working with several tables in sql server 2008, and the data is used in a Classic ASP application. The...


SQL Server 2008 : Security (SS2K8)

General Script or Method to Query/Report Permissons for a SQL Server Instance - Hello, Is there a general SQL script or method for putting together a list of all users and permissions for a...


SQL Server 2008 : SQL Server 2008 Administration

Database collation Change - Hi my Production DB's Server level Collation is SQL_Latin1_General_CP1_CI_AS where as my development DB's Collation is Latin1_General_CI_AI ,often our development team...

Is any one can give the Exact reasons for growing the Log Size - Dear All, Is there any Exact reasons for growing the Log Size , I Have referred some online guides but, I didn't...

Procedure execution count\Time - Hi Experts, When I ran the below script , I got result of around 1700 rows and when I removed the where...

when i am doing BCP out command i am getting this error - when i am doing BCP out command i am getting this error C:\Users\ADMIN>bcp master.sys.syslogins out c:\syslogins.dat -S admin-pc\admin -T SQLState = 08001, NativeError...

sql 2008 Extended Events help - Hi Guys, ive just recently joined the forum and wanted some helpwith Extended Events in SQL 2008, the package sqlserver.sql_text...

How to search for replication information messages e.g "The initial snapshot for publication is not yet available." - I have been working a lot with replication the last few weeks. The replications I was working on are all...

Object already exists, but can't drop it! - Hi All, My client has just started getting a problem with their SQL server. All of a sudden many many of...

Create DML trigger for single table in SQL 2008 and send email alert to group - Hi, i have a requirement to Create DML trigger for single table ( check for any updates ) in SQL 2008 and send...


SQL Server 2008 : SQL Server 2008 Performance Tuning

MERGE and Index Rebuild - Is it a problem? - I'm working on a performance tuning on a 3TB table and tried to rebuild an non clustered index and I...

Insert triggers updating an audit table - Hi, Apologies if this is in the incorrect forum. I have created a trigger using the below code: CREATE TRIGGER [TriggerName] ON [InsertDataIntoThisTable] AFTER INSERT AS UPDATE [AuditTable] SET...

Should nonclustered indexes include clustered column? - Hello, I am confused with the clustered key in nonclustered indexes. Lets say if I have a table with 10...


SQL Server 2005 : Administering

Evaluating CxPacket issues - Hi All, First the configuration details. SQL 2008R2 Standard, SP2, 64Bit on Windows 2008R2 EE 64 Bit. HP DL 380 with 2x4 processor...

Cluster Disk Resources Migration - System Specs 2 Node Cluster Active/Active each with an instance Windows Server 2003 SQL Server 2005 Project: we are changing our SAN from an...


SQL Server 2005 : Backups

System Database restores vs rebuild - Hello all, I need to better understand under what circumstances you would rebuild versus restore the system databases? In a meeting...


SQL Server 2005 : Business Intelligence

On Click "Calendar Control" Button, not showing Calendar Window In SSRS - Hi, I am using Calendar Control for couple of Date type Parameters. When viewing report at Report Manager, On Click "Calendar Control"...


SQL Server 2005 : Development

Extracting data from XML is slow and filling tempdb transaction log - I am trying to extract data from an XML column within a table on SQL Server 2005. The table as...


SQL Server 2005 : SQL Server 2005 General Discussion

Which tables required to make payroll in this case - I work in sql server 2005 and visual studio 2005 i want to make database for payroll only but i...


SQL Server 2005 : SQL Server 2005 Integration Services

can't able to get the data from the remote server - Hi, I can't able to get the data from remote server.I ma getting only headerrs not getting data.it 'll throwing below...

SSIS 2005 service not starting after KB2716429 - Hi all, We have been experiencing problems with SSIS service not starting with the usual useful error "The service did not...

Sharepoint List Source Error -A possible reason might be you are trying to retrieve too many items at a time (Batch size) - [b][/b]I am trying to get data from a Sharepoint List using the following CAML Query in SharePoint List Source <Query><Where><Contains><FieldRef Name='Function...

Invoke URL from SSIS? - As part of my data import, it has become a requirement to fire a URL for each "new" record, after...

FTP Task does not receive files - I have a very simple SSIS package with one task that receives a file from an FTP site and saves...


Reporting Services : Reporting Services

Report Server Front End - Hi Folks, I am working as a DBA and we have a project on BI for development of a cube and...

Report - SubReport - I have two reports that Point to the same Sub Report. On The Sub Report I have a text that says...

Best approach to lots of similar subreports - I have a hopefully simple question. I’m trying to learn SSRS a little better, and so I’m trying to abstract...


Reporting Services : Reporting Services 2005 Administration

Logging into SSRS with NT AUTHORITY\NETWORK SERVICE instead of Windows Authenticated User - We recently had to recreate our development server, however, we were able to recover the ReportServer and ReportServerTempDB databases. We...


Reporting Services : Reporting Services 2005 Development

Page numbers in SSRS while exporting to pdf file - Hi I am designing the report in SSRS. In footer I have set the page out of (no. of pages)....


Reporting Services : Reporting Services 2008 Development

Indicator for to remain in one cell for a group - In SSRS, I have a drill down report with three columns. One column says 'yes' or 'no.' The other column...


Programming : General

.NET SSIS Script Task issue - I am still a rookie when it comes to Visual Basic. I've been giving VB code to read a file...


Programming : Service Broker

Simulate message poisoning in Service Broker - Hello, I have set up Service Broker in a test database running on SQL Server 2008 R2. Within this service broker...


Data Warehousing : Integration Services

ADO.NET connection manager can't run Execute SQL Task - Hello, I am working on a SSIS package. I wish to use the Connection Manager (CM)'s Connection String for my DB...

how to add Aggregated Transform as a new column - Hi, I have a flat file with 2 colums: TradeID and Nominal. Now I would like to add third column showing...

Where do I find Microsoft.SqlServer.Management.IntegrationServices.dll? - I would like to explore deploying SSIS 2012 packages through a C# interface. Where can I find the Microsoft.SqlServer.Management.IntegrationServices.dll file which...

Mapped Network Share - Hello - I am trying to find out what is the best way to have my ssis package export data to...

Problem Debugging Script Task - Hi. We have a strange problem when trying to debug a script task in SSIS 2012. Here's the scenario - my...

SSIS 2012 - Clean-up Task - certificates / symmetric keys - We've had a problem with our (already optimised) daily clean-up task recently. While troubleshooting, we noticed that part of the...


Data Warehousing : Analysis Services

Report Builder 3.0 Subreports - Error: Subreport could not be shown - Hi all, So I continue to delve into the bowels of Report Builder 3.0. My last post was asking about how...


Database Design : Design Ideas and Questions

How i make ERD Diagram for payroll salary for employees - Hi guys i want to make database for payroll only but i don't know how to make structure for this suppose...


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


Career : Certification

Upgrade Exams - AKA Certification Tribulations I've previous 2008 certification but, before Christmas, I failed upgrade exam 70-457 (by ONE question. gah.) Next time...


Career : Events

SQL Saturday dress code recommendations - Hi I'm heading down to SQL Saturday 291 in CHI tomorrow, and am wondering a couple things: - What is the dress...

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