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 Geek Christmas Poll

There are just a couple weeks until the Christmas holiday this year, and there are no shortage of new gadgets being released and updated by all sorts of companies. Many of us in technology get intrigued and interested by the new ways in which the various electronics and technologies are implemented and integrated. Whether these items have practical uses or not is often secondary to the joy we get from seeing technology being used in innovative ways.

With Black Friday and Cyber Monday behind us, I'm wondering this week what things would excite you this year as gifts. There seem to be as many new products, enhanced products, and new ideas that are coming from established vendors as well as independent, crowded funded companies on sites like Kickstarter and Indiegogo. This Friday I'm asking:

What geek gifts or gadgets would you like this year?

It's the season to give and take pleasure in making others smile, but if you were to make a list for Santa, what would be at the top of your list?

I've gotten so many electronics over the years that I don't really feel a lot of excitement over many of them. I tend to use my cell phone and laptop most of the time, and rarely venture out to other devices. I backed a Kreyos watch project earlier this year and am looking forward to receiving that device in 2014. 

If there were one electronic item that I'm interested in, it's a FitBit Flex device. As I age, I'm paying more attention to my health and my level of activity, and I've seen a few friends learn more about how well they're taking care of their health using either a Fitbit, Jawbone, or Nike device. I'd like to give one a try and see if it improves my health.

Let me know this week what interests you. Maybe a Google Glass device? Some tablet? A smart watch? Anything else?

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 ( 19.9MB) feed

MP4 iPod Video ( 23.2MB) feed

MP3 Audio ( 4.7MB) feed

Feeds are available at iTunes and Mevio

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

ADVERTISEMENT
Tribal Awards

Tribal Awards 2013

Simple-Talk and SQLServerCentral are hosting awards to recognize excellence in the technical community. Nominations are now open for each of the 11 categories (nominations will close December 17). Check out the awards and nominate your favorites.

SQL DBA Bundle

The seven tools in the SQL DBA Bundle support your core SQL Server database administration tasks.

Make backups a breeze! Enjoy trouble-free troubleshooting! Make the most of monitoring! Download a free trial now.

SQL Compare

Need to compare and sync database schemas?

Let SQL Compare do the hard work. ”With the productivity I'll get out of this tool, it's like buying time.” Robert Sondles. Download a free trial.

Featured Contents

 

DAX Query - Part 2

Gary Strange from SQLServerCentral.com

A more detailed look at the DAX language and some of its more frequently used functions More »


 

Model Based Testing at Red Gate

Additional Articles from SimpleTalk

Phil Scrace, a test engineer at Red Gate, talks about adopting Model Based Testing (MBT), a technique that combines graph theory and code writing to help keep pace with frequently changing functionality. More »


 

SQL Saturday #274 - Slovenia

Press Release from SQL Saturday

SQL Saturday is coming to Slovenia on December 21, 2013. This is a free all-day training and networking event for SQL Server professionals. More »


 

From the SQLServerCentral Blogs - Testing labs

Bill (DBAOnTheGo) from SQLServerCentral Blogs

What sort of testing lab do you setup when you're testing things out? I hear see the world adventureworks almost... More »


 

From the SQLServerCentral Blogs - Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49

Tracy McKibben from SQLServerCentral Blogs

A couple of weeks ago I gave you some scripts to collect wait stats from your SQL Server instance over... More »

Question of the Day

Today's Question (by Steve Jones):

I have an AlwaysOn availability group for my Sales and Finance databases set up on the SQLProd01 instance. I decided that I also want to mirror the CRM database on the same instance to another server. Do I need to create another endpoint?

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

Microsoft® SQL Server® 2012 Step by Step

Teach yourself the programming fundamentals of SQL Server 2012—one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I create a Central Management Server on SQLSales1. I then create a group and add SQLSales2 and SQLSales3 to the group. I want to execute a query against all three instances and decide to run it using my group on the CMS. What happens?

Answer: The query will execute against SQLSales2 and SQLSales3 only

Explanation:

The drawback of a Central Management Server is that you cannot include the CMS in your queries. As a result, when I execute my query against the CMS group, it only executes against the SQLSales2 and SQLSales3 instances.

Ref: SQL Server 2008's new Central  Management Server - http://www.brentozar.com/archive/2008/08/sql-server-2008s-new-central-management-server/


» Discuss this question and answer on the forums

Featured Script

Scripting SQL jobs using PowerShell

Premjit Das from SQLServerCentral.com

This powershell script can be used to generate scripts for sql jobs with different filenames.

I have customised this script in such a way that it will not script any "Replication" or "logshipping" category Jobs.

You can modify the script as per your requirement.

--------------------------------------------------------------------------------------------

--------------------------------------------------------------------------------------------

Step 1) Create a folder in your C drive as "test"

Step 2) Save the script with extension PS1. as "job_script"

Step 3) Pass the "instance name" as the parameter. This will create the scripts for the specified instance name.

Premjit Das

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

gallenmartin103 - [b][url=http://www.vintagefive.com/collections/chanel-earrings]Chanel earrings[/url][/b] Chanel earrings, Chanel necklaces, bracelets and brooches. We specialize in Authentic Vintage Chanel jewelry. Especially we have a lot...

Bangalore Packers Movers Can make Separation Quick - No matter if you're relocating by Bangalore for you to some place else or maybe transferring from the town derived...

Can not enter in sql server under sa - I had by default installed express msmss with windows mode. But now I need mixed mode of authentication. I have...

Limit DB access outside application - We have applications connected to SQL using windows authentication. While having connection with Application user can also access to Database...


SQL Server 2014 : Development - SQL Server 2014

How can I return a bitmap image from a custom assembly to an SSRS report? - I am using the QRCode4CS class ([url=http://qrcode4cs.codeplex.com/releases/view/74015]http://qrcode4cs.codeplex.com/releases/view/74015[/url]) to generate QR codes. I can use the following code to successfully return a...


SQL Server 2012 : SQL 2012 - General

SSIS Foreach File Enumerator Date Order - I'd like to ensure that my SSIS (2012) Foreach File Enumerator processes the files in order of creation date. Ideas?

Trouble with SSRS portion of the upgrade... - I am attempting to do an 'in place' upgrade of my SQL Server instance from 2005 to 2012 (enterprise). I...

AG + Failover Clustered Instance - Hi all We are looking at implementing AlwaysOn AG combined with a Failover Clustered Instance of SQL Server. This is the...

Remote access to SQL Server 2012 R2 - Hello, I'm having an issue accessing SQL Server 2012 Express remotely. I have the following setup: SQL Server 2012 Express on...

Microsoft Access to SQL Server - Hi all, I have created a report on Microsoft Access by connecting to SQL Server using SQL Server Native Client 11.0...

SSIS 2012 Rename File by appending Date - I have a foreach container that processes zero or more similarly-named csv files, then moves each file to an archive...

Union Join between 3 SQL Queries - I am looking to perform a UNION join between 3 select queries, this is what I think I need to...

Data Dictionary - Hi, I need to get the data dictionary for the database tables that are related to users and orders(Users table and...

SQL Job using SSIS package with parameters - Hi all I have read so many threads on this but still seek a definitive answer... I am trying to pass a...

Problem Saving SIS Import Package Using Import and Export Wizard - I often have to import data from a CSV file into SIS. I have been doing this manually, using the...


SQL Server 2012 : SQL Server 2012 - T-SQL

display columns with no data - Newbie..sorry, posted this somewhere else, but couldn't find it. Trying to get the PSI Outcome, Expected, and PSIIndex every month...

sql query to find the difference in values from previous month - I have my sql tables and query as shown below : [code="sql"]CREATE TABLE #ABC([Year] INT, [Month] INT, Stores INT); CREATE TABLE #DEF([Year]...

error with stored procedure - when i execute the SP with data parameters USE [ABC] GO DECLARE @return_value int EXEC @return_value = [dbo].[test] @QTRSTRTDATE = N'select CONVERT(datetime,DATEADD("M", DATEDIFF("M", 0, GETDATE()), 0),120)', @QTRENDDATE = N'select CONVERT(datetime,DATEADD("M",DATEDIFF("M",-1, GETDATE()),-1),120)' SELECT 'Return...

Set based super challenge - Please read the attached txt file. The challenge is to summarize the data per patient but only as / if the consultant...


SQL Server 2008 : SQL Server 2008 - General

A Database with no files... - So here's an odd one, just been looking at a SQL server, when looking at the database properties via SQL...

Median or Average function for char(10) = '0-5' - Hi, I have this setup and need to do calc on this columns, is there any anylitical function that I can...

SQL Running forever - Hi folks, Please I need to know what is wrong with this query. I have a scalar function as below: CREATE FUNCTION...

SSMS Strange Behavior - I am having an exceedingly strange issue with SSMS. When opening new sql files (from explorer or file->open) or query...

MS DTC and VSS Based Backups - Although I don’t think this is strictly a SQL Server issue, as SQL Server is the only user of MS...

How to check characters from string - Hi, i am using sql server 2008 R2, My requirement is as follows, I had a string ABCRD1234E I want to write query...

Nested Cursors - Hi there - I am trying to use a nested cursor to execute a script against all usernames across all database....

SQL 2008 R2 Upgrade and collation - Hi Team, I need to perform SQL 2008 R2 standard edition upgrade to Enterprise. I can do this by running upgrade wizard. My...

Error not resolved? SQL 2K8R2 - Hi, This Error not able resolve and every 2 min error apperaing in error log file. Database: MSSQL SERVER 2008 R2 64...

SQL DBA Doubts - Rajeshn29 - Hi Team, 1. How to apply service pack active - active cluster node. 2005 & 2008 I have 2 active – active nodes like (A,B)...

SQL Server 2008 R2 - Lock Excalation question - Hi All, I wonder if anyone has any experience in this area: I have a table which has about 4000 records in...

SQL Server 2008 R2 - Lock Excalation question - Sorry, please ignore this post. I accidentally pressed the ENTER key. Please see the next post above...

How to validate data as per user requirement - Hi, My requirement is to validate the data,as per users specification, In this,we have the set of data(details), number wise...

SQL Intellisense - Hi, We have given read-only access to user1 on one of the production database1 But today we found out from our third...

Replication - First I'll apologize for my lack of knowledge on the topic... I recently started with a new employer and I have...

What is the Difference ? - Hi, Recently I got to execute one query which comprise the CASE statement as below, though the condition within the...

Starting one named SQL Server service stops/crashes another - Hi all We currently have a machine running a named instance of SQL Server 2008 and need to create a new...

SQL syntax error - Hi All, Please I need help with this. I am having an error when I try to run a report that...

Select from table and alter result - How do I select from a SQL Table and change the result? For example.. declare FindFragment cursor for SELECT object_id, name FROM #IndexFrag...

Create link server for Microsoft Access2000 - Hello, Can some one help to create link server for Microsoft Access2000, here is what I did but it is not...


SQL Server 2008 : T-SQL (SS2K8)

How can I add encoding in output XML file like "<?xml version="1.0" encoding="ISO-8859-1"?>" - Hello all: Can someone tell me if I can add "<?xml version="1.0" encoding="ISO-8859-1"?>" in the first line of XML file? Currently...

Insert dates into table in the giving range. - Hi, I am having a table with SchoolDate column. In this column I need to enters all the dates in the...

Performance Opinion - Hi all, I have created a SP in which frequentylr transaction will occur.. Can you please look at it and tell me...

Must Declare the scaler variable @mesg_out - I am trying to execute the dynamic sql query and getting the following error: Must declare the scaler variable @mesg_out. I already...

SQL Thousand separator with round - Hi, Declare @i float = 1223.8899 I want this to be 1,224 Declare @i float = 1234.22 I want this to be 1,234


SQL Server 2008 : SQL Server Newbies

SSIS CSV file import with embedded quotes and multi line - I need help with importing a csv file into Sql Server 2008 using SSIS. I have successfully imported 10 of...

Event Log msgs - From the event log I found some informational messages, What does below messages means ? Is it something I took as...

Error on upgradation of SQL 2K8 over cluster - Hello All, We got the following error during the SQL Server 2008 standard edition service pack 2 upgrade on cluster environment: -------------------------------------------------------------------------------------------------------------------------- Problem:...


SQL Server 2008 : SQL Server 2008 High Availability

Log Shipping, daily backup's on primary - I have log shipping configured to send logs from primary to secondary every 20 mins, all day long. I also have...


SQL Server 2008 : SQL Server 2008 Administration

Simple databases / warm failover - I have two database servers on the domain. One for production databases and the other is for warm failover. And...

Page Splits /Sec - Hi all Regarding the Page Splits /Sec counter, this tracks the amount of page splits per second as well as the...

Patching - Hi Experts, We have windows patching on SQL Server and the process we follow here is check jobs,kill jobs if any...

CPU is higher than ever. - we recently moved from 4 to 8 cores on the SQL server 2008 db in a vm environment (at hosting.com)....

Owner of prepared statements - One of my production databases has in the exec plan cache a statement that needs to be modified so that...

Auditing to fetch the details of lastlogin date of user in SQL server - How to use auditing to get the lastlogin date of the user in SQL?? or is there any other way to...

Production databases, people involvement - I work in a small company with 90 people. I have been working as a database developer but recently started...

Backup With Checksum - In searching for information on checksum, I see statements like "When backing up a DB Checksums are checked for pages that...

transaction log eats up all the space and growing until sql is stopped - Hi , I've got a peculiar problem with my VCENTER's SQL 2008 database. My Database is running on SIMPLE recovery model. The...

Log not available error 9001 - Came in to work this morning to face a bunch of alerts for severity 21 errors. "DESCRIPTION: The log for database 'SpotlightManagementFramework'...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Monitoring Software - Hello Everybody, I am sure that was discussed earlier, so any links will be appreciated. We are in the process of getting...

Stored Procedure Running Slow via SSIS vs Management Studio - I've been having some pesky tuning problems with Stored Procedures running via DTEXEC and through BIDS. When I run the stored...


SQL Server 2005 : Administering

Mirror - 824 Corruption - Hi all We've had a database mirroring session stop due to an error 824, mirror is in restoring state, I am...

Delete a column XYZ from a table ABC which is a part of merge replication - Guys, I have a task to delete a column XYZ from a table ABC. It is not a having any...

File Size Questions - Hi, Two questions regarding the MDF file size. 1. Recently I encountered numerous autogrow failures. Autogrow was set to 100MB, however the...

BuiltinAdministrator in sql server 2005 - Hi Friends Please explain which logins are members of BuiltinAdministrator group in sql server.its from local server only or those...

Failing to get logged in sql server throught windows login - Hi friends At one of our client side we are not abled to get logged in sql server through windows...

MSDB sysjobstepslogs table is huge - My MSDB database in production has been growing about 100 meg per day for no apparent reason. I noticed the...

Bulk insert issue - Hi All, I am getting problem on bulk insert issue through SSIS package. when bulk of the record inserting in the particular...


SQL Server 2005 : Backups

Cannot open backup device '\\remotesqlserver\e$\Backup\databasename.bak'. Operating system error 53(The network path was not found.). - Hi, all of a sudden my backup job failed with the error. Cannot open backup device '\\remotesqlserver\e$\Backup\databasename.bak'. Operating system error 53(The...

The Effect of Reindexing on a backup file - Hello, I am trying to find out the impact of a database reindex on an SQL Server backup. The scenario is as...

what is Copy-Only Backup? - Hi, What is Copy-Only backup and how does it works? thanks Koteswarrao


SQL Server 2005 : SQL Server 2005 Performance Tuning

Memory Buffer says table occupies upto 6x more memory space than physical table size - I am trying to investigate SQL Memory usage and am running the query below However for one core table (item) which...


SQL Server 2005 : SQL Server 2005 Integration Services

Row_Number() in SSIS? - Hi Friends, I have a select statement having Row_number() over(partition by coulmn order by column) .... i see no option in any...


SQL Server 2005 : T-SQL (SS2K5)

split column into multiple records based on substring fixed lenght - I have seen posts to split column into multiple records based on delimited value. I need to split a vchar(4000) column...

how to calculate Average Time Duration - Hi, I am counting values from database like Total Calls Made:0:53:29 , Total Calls Received:0:11:25 , Total Call Duration:1:4:54 Total Calls Made:43 , Total Calls Received:5...


Reporting Services : Reporting Services

Bold rows in SSRS - Hello, I have a report that has a series of sub totals. Unfortunately, (due to the complexity of the spec) these...

SQL Server Reporting Services report inside a .aspx web page - Hi, I was wondering if the SQL Server 2012 reporting services allows you to put reports inside a .NET web application?...

Banded Column Colors - Hi I have a data set that shows employees, dates, and sales Employee........Date..............Sales Raul...............2013-12-01.....100 Raul...............2013-12-02.....150 Raul...............2013-12-07.....350 Jose...............2013-12-01.....150 Jose...............2013-12-05.....100 Jose...............2013-12-06.....50 Pedro.............2013-12-04.....100 Pedro.............2013-1

ssrs 2012 show hide parameter area - In an existing SSRS 2012 application, there is an up or down area that appears sometimes in the paramneter area...


Reporting Services : Reporting Services 2008 Development

Sorting in stack column - I am trying to sort the stack chart based on the individual volumes. I am displaying Desktop, Laptops ,Ipads per manager. X...

Limitations on Newspaper Column options - Is anyone else frustrated as I am with the way that newspaper-style columns work in SSRS? By assigning the columns...

Exporting SSRS reprot to Excel - Hi Team, I'm exporting a SSRS report to Excel. For some input parameters the number of rows generated by the SSRS...


Programming : XML

Passing bulk data through xml parameter or table parameter in stored procedure, which one is better - Hi, I am passing bulk data to stored procedure through xml string for insert/update operation. Can any one tell passing bulk data...


Programming : Powershell

move files from server to server - Hi, I need to move the files base on the query from sql database. The files name is on the table,...


Programming : TFS/Data Dude/DBPro

TFS Deployment Automation - Hi, I want to automate the FindLabel in TFS and copy all files to Local path. Is there any comd/powershell command...


Data Warehousing : Integration Services

Variable Expression - When i used the below Expression in SSIS package variable. [b]DATEADD("D",-(DAY(DATEADD("M",1,GETDATE()))),DATEADD("M",1,GETDATE()))[/b] result is [i]12/31/2013 4:23:13 PM[/i] i am looking for a result in...

bulk insert operation through SSIS package. - Hi All, I am getting problem on bulk insert issue through SSIS package. when bulk of the record inserting in the particular...

Scheduling package in sql server 2008 r2 express edition - Hi, I have created a package in ssis and i need to schedule it every week. How do i do that...


Data Warehousing : Analysis Services

Importing Data from cube - different in SSMS - Hi, I have this MDX statement that produces my sites the way I want to see them in SSMS. My problem is...

Calculated Measure - Hi I have a Cube with Store / Product / Date/Sales Type etc. I need to provide a measure within the cube that shows...

Calculated Measure LFL Grand Total - Hi I have a cube that has Products, Store,Date,Sales Type. I have two calculated measure Mature Sales This Year Sales Last Year The Mature...

Reporting Help (Excel, SSRS, MDX) - I have built my first cube and I believe it is setup properly but I am having hard time wrapping...

SSAS Training In London UK - Hi, Can anyone recommend a reputable training provider (ideally classroom / lab based), for Analysis Services 2008 or 2012? There are numerous...


Database Design : Design Ideas and Questions

Agile and Data Modeling - Agile is fast approaching our company, and although I can really see some of the benefits of it, I am...

EAV design or Normalized - Hi designing a financial budget database, expenditure items require the amount, frequency and comment, there can be over 100 expenditure...


Database Design : Relational Theory

Database without ANY primary keys - Hi all, I work with a database that has no primary keys defined on any tables. As a customer's consultant I...


SQLServerCentral.com : Anything that is NOT about SQL!

Fantasy football 2013 - I renewed the league, you should be getting an email soon. At the moment, there are no open spots, but...

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


SQL Server 7,2000 : Administration

SQL 2000 - How long has a job (all steps inclusive) been running? - So I've scoured the web and it seems everything I find will alert really well on just one job step...


SQL Server 7,2000 : T-SQL

Getting SID from Active Directory - SID transformation problems - Hi all, here is the issue: we had an old xp that gets SID from AD, using a domain user name (i.e....


Microsoft Access : Microsoft Access

Tab control inside a Tab Control - I want to put a tab control inside another Tab Control. I have 10 tabs on the parent tab control....

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 ©2013 Red Gate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com