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 Gadget Itch

Many of the people that work in technology are interested in gadgets and hardware as much as software. Not all of us, but many of us have had side projects where we've melded hardware and software together. For those of us that are older, and started working with computers decades ago, that might have been the only way that we could get a computer system to work.

I'm glad that I still find people interested in hardware. My son recently built his own gaming computer from parts, and I'm hoping to distract him from some games and get him to help me build some robots with a Raspberry Pi computer and BrickPi add-on board. However it's not just kids as I've seen a number of people at Red Gate working with hardware to build a variety of interesting projects.

This week I'm wondering if any of you are interested in creating your own devices. If you had the chance to build a device or gadget for work, what would it be? A panic button when there's a problem that you can press and instantly set of Star Trek "red alert" sirens? A status display based on your continuous integration builds? The question this week is:

What would you build if you had a parts list like this one?

Whether you've started actually assembling things or you're just dreaming of something, or perhaps even just seen something that's intrigued you, let us know. I actually think this might be a fun competition of some sort for an event, perhaps a hacking competition across a couple hours at a SQL Saturday or conference.

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 ( 1.8MB) 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
SQL Server Concurrency eBook

Understanding SQL Server Concurrency - FREE eBook

Read Kalen Delaney's free eBook "SQL Server Concurrency: Locking, Blocking and Row Versioning" to learn all about concurrent access, troubleshooting deadlocks, and more. Download the free eBook

SQL Source Control

Get your SQL Server database under version control now!

Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

SQL Prompt

5 Ways to Code Effortlessly

Discover the different ways you can make writing, exploring, and refactoring SQL code refreshingly effortless with SQL Prompt 6. Download a free trial.

Featured Contents

 

How to centralize your SQL Server Event Logs

Geoff Albin from SQLServerCentral.com

Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years. More »


 

Use Extended Events to Get More Information About failed SQL Server Login Attempts

Additional Articles from MSSQLTips.com

You may have cases where an ancient application is using an old login or the wrong password. SQL Server is great about auditing failed logins and recording that they happened; it is not so great, however, at providing enough information to locate them. Aaron Bertrand offers some help. More »


 

From the SQLServerCentral Blogs - Blogging-Write More

Andy Warren from SQLServerCentral Blogs

Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the... More »


 

From the SQLServerCentral Blogs - Collation: Confusion

Kenneth Fisher from SQLServerCentral Blogs

I started reading about collations after I had a recent run in with them. As I read I started to... More »

Question of the Day

Today's Question (by Steve Jones):

If you have the results of your query sent to a grid, how do you hide the results pane?

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: Management Studio (SSMS).

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

Professional SQL Server 2012 Internals and Troubleshooting

The 2012 release of SQL Server is the most significant one since 2005 and introduces an abundance of new features. This critical book provides in-depth coverage of best practices for troubleshooting performance problems based on a solid understanding of both SQL Server and Windows internals and shows experienced DBAs how to ensure reliable performance. The team of authors shows you how to master the use of specific troubleshooting tools and how to interpret their output so you can quickly identify and resolve any performance issue on any server running SQL Server. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

In a hash match join, which input is the one used to build the hash table?

Answer: The first input

Explanation:

In a hash match join, the first input is used to build the hash table and the second input is used to probe the hash table. Size does not matter for this operator.

Ref: Join Operations - Hash Match - http://www.sqlservercentral.com/articles/Execution+Plans/106888/


» Discuss this question and answer on the forums

Featured Script

Generated script to update statistics

Andrés Michaca from SQLServerCentral.com

Generated script to update statistics

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

SQL Server 2014 - What are the issues noticed while upgrading from SQL Server 2008 R2 to SQL Server 2014? What is the configuration...

Is a 2005 and 2014 side-by-side install a supported scenario? - http://msdn.microsoft.com/en-us/library/ms143393(v=sql.120).aspx (Supported Version and Edition Upgrades) seems to indicate that upgrade installs are okay but side-by-side installs are not: [quote]SQL Server...

Performance issues in FULL recovery model? - Hi Experts, Just wanted to know whether there would any kind of Performance issues if I change the recovery model from...


SQL Server 2014 : Development - SQL Server 2014

Hekaton - Origin - Hi all, Someone knows the origin of the name "hekaton" because in previous editions the name was based mountains. Thanks.

Changed behavior or am I missing something? - Hi all, when porting and testing code from 2008/2012 to 2014 I noticed that some queries where significantly slower. Digging into...

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

The new 3D Joins in SQL Server 2014 - Has anyone tried out the new 3D joins in 2014?

Database and its Objects Naming Standards - I am trying to establish the standards for naming convention in my new project. Can you please provide me the...


SQL Server 2012 : SQL 2012 - General

Kitchen Units Wickes - Kitchen Units Wickes. Thirty Ex Display Kitchens To Clear. http://www.exdisplaykitchens1.co.uk £ 595 Each with appliances. _________________________ [url=http://www.kitchenunits-kitchenunits.co.uk]Kitchen Units Wickes [/url]

Kitchen Designer London - Kitchen Designer London. Thirty Ex Display Kitchens To Clear. www.exdisplaykitchens1.co.uk £ 595 Each with appliances. _____________________ [url=http://www.kitchendesignlondon1.co.uk/]Kitchen Designer London[/url]

Kitchen Units Sizes - Kitchen Units Sizes. Thirty Ex Display Kitchens To Clear. www.exdisplaykitchens1.co.uk £ 595 Each with appliances. ___________________ [url=http://www.kitchenunits-kitchenunits.co.uk/]Kitchen Units Sizes[/url]

SSRS: how to put 10 rows on first page and rest (1000+) rows on the second page - Hi, Is there any way to control this scenario, I know trick to put 10 on each row ,but I need...

Question About SSIS 2012 Development in 32-bit Environment, & Upcoming Installation in 64-bit Environment - I'm working on a project writing a complex SSIS package for a client. The virtual machine I'm using for the...

Is there a fast way for SQL to do a Group By Count on items within a group? - select top 15 count(*) as cnt, state from table group by state order by cnt desc select top 15 count(*) as cnt,...

Moving Subreports - Hi I just moved a whole bunch of reports from sql 2000 server to a sql 2012 server. all reports now...

Unable to connect to analysis services - Hi All, Currently we are unable to connect to analysis services and getting the below error Element 'return' was not found.Line 5,position...

Symmetrically encrypt a single node in XML field - How do I reliably symmetrically encrypt a single node in an XML field in my SQL Server 2012 database? I...

Database Design - Need help in Choosing a primary key - Hi All, I am kind of confused. I need some help in choosing a primary key for the database which i...

SQL in a DMZ - What is everyones view on accessing SQL data which is stored on SQL instances in the DMZ via management tools...

Database monitoring - Currently there are various teams accessing the database. For costing reasons, we need to track usage. Is there an efficient way...

AlwaysOn and error 1265 - I am attempting to set up an always on cluster on VMware for testing. setting up everything through the Failover...


SQL Server 2012 : SQL Server 2012 - T-SQL

Some Data Coming as NULL in a VIew - I have the following view. The column prod_Master.M2_Pct is defined as float. Yet for some of the rows, the value in [% of...

Need help with query rewrite - Hi all, We have a very expensive query that I am tring to rewrite, but the rewritten query (even though...

Second Last work day of month - Hi, I would like to get the second last work day of the month. Can anyone help me with that.

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

where can I query the 'Enable Mail Profile' value from the Agent properties - Hi All, I'm looking to query (via SQL) the 'Enable Mail Profile' value from the Agent properties, but I've been unable...

Can I convert a string to a time field ? - Hi I have a field that is a string, but stores a time value as "09:45 AM" I need to...

Restore Script - hi All, I need some suggestions - I am supporting large number of Development and Test databases. Almost every day I get...

Extracting from one cell in excel. and from - I have a excel file. in one cell, column A row2, there is a text. "This is effective as of February...

Rename Server - I have server name called X and i want to convert this server using Virtual to virtual.However, I want to...

In-Line Function to split string - Good afternoon gents, I'm having a slight issue with a function i have created and the way it works. Some...

Changing server/db collation - Hi all, We have a Dev server whose Collation Sequence must match that of our (soon to be ex) production server....

Importing improperly formatted excel file - business people sent me an excel file. looks like the picture. this is not very well data friendly. there is no...

Dynamic and Static Ports - Good Morning! I have been trying to get our SQL servers organized at work and one thing I am doing...

How to use an optimization for all operations in sp_executesql? - Hi I have a C# solution with many parameterized sql queries. I would like to be able to add optimizations to these...

Need help with query. - The data contains medications given to patients. If a patient is given Vitamin K, DrugID='VITA100T2', then, the status can be...

Finding Position Plain text inside html markup using SQL - Consider following string I would like to thank whomever did the proofreading on Consider following html content Now i want to find...

query plan cache gets cleared every hour - I'm working for a client who creates a reporting database from a production system by shipping and restoring log files....

Why Use Error Handling? - I have always believed best practice when writing stored procedures or any SQL code is to include error handling. I...

Backup questions for 612GB database! - We have a database that is over 612Gb and growing. Our backup is being done on tape using Backup Exec...

Starting over after 4 year break - This is not a technical question but I need a career advice. I worked as a SQL server DBA for...

SSIS data conversion error - Iam using flat file source,data conversion and oledb destination for data transfer But Iam getting the error [BEM(ETA) [161]] Error: SSIS Error...

time-out in a Job using link server - i have this error in a job, this job is using linked server Message Executed as user: Domain\user. OLE DB provider "SQLNCLI10"...

Reset sp_prepexec - Can we reset sp_prepexec and sp_execute When i am running the sp_prepexec the id is generated say it is 22 then...

166 days to create index - I have a table containing 2,163,568,622 rows hosted on SQL server Standard 2008. Attempted to create a new index: -------------------------------------------------------------------------------------------------------------------------------------------------- Using TEMPDB = ON...

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

SSIS change destination to named instance - Hi We have several SSIS packages where destination is 'SQL Server Destination'. Now they are moved to another server with a...

SSMS Trama (yes, this is really bugging me) - In Tools -> Options -> General, I have "At Startup" set to Open Empty Environment. This works wonderfully with 2k5,...


SQL Server 2008 : T-SQL (SS2K8)

Remove a Simple Duplicate - Hello Everyone I found some duplicate data as I was going thru the logic of a data pump. The entire row...

SqlServer AVG Issue - Hi, I trying to do AVG function in SQL and seems it does wrong calculation. Data : -1, -1, 0 If we take...

forming a dynamic query - have a sp with 4 parameters the values of this parameters is obtained from application currently i have @transfrmdt date, @transtodt date, @cid integer, @Type...

Max with distinct two columns and corresponding third column - Hi, i need to write a query and can't get it to work no matter how it try. Here's what...

How many users are working till specify date? - Helllo, Can somebody help me? I have a table with 5000 rows history about working and retired time. It is the serveral...


SQL Server 2008 : Working with Oracle

SSMA to migrate data from oracle to sqlserver - We migrated data from oracle to sqlserver using SSMA but when we see data of sqlserver on .NET GUI, formatting...


SQL Server 2008 : SQL Server Newbies

Get 1st Word in the string - I am trying to to extract the 1st word from the string but end up with this error : Invalid length...


SQL Server 2008 : SQL Server 2008 Administration

Create DML trigger for single table for a Database in SQL 2008R2 - Create DML trigger for single table for a Database in SQL 2008R2 Hi, I have a requirement to Create DML trigger for...

Replication Issues - Hi all, any one has encountered this error in replication? I am setting up Transaction replication using backup and restore...

P2P Replication - HI... in real time scenarios can we use p2p replication? what is the purpose of p2p replication any body explain?

Restoring the latest database - We have the following databases on one of our SQL Serve instances. • ABC123 • ABC456 • ABC765 • ABC234 • ABC_SETTINGS • ABC The ABC[numbers] databases are different versions. The ABC database...

Periodically Reviewing SQL Server Permissions - Hello, I am very interested in knowing how experienced DBAs go about periodically reviewing who has access their SQL Servers and...

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

Msg 8501, Level 16, State 3, Line 1 MSDTC on server 'My-Server' is unavailable. - I tried following code in SQL2K8r2..... for getting login modes of Linked server's code is absolutely correct. But when I...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Truncate before table drop - Hi all, I have come across some code that does this: Truncate table Tablename Drop table Tablename I have never done a truncate before...


SQL Server 2005 : Administering

remove rows from staging table that are duplicated before insert the data into the database normal tables - Hi, I have this table: CREATE TABLE [dbo].[BULK_ACTIVIDADES]( [CODCTB] [bigint] NULL, [NIF_ANTIGO] [varchar](20) NOT NULL, [NIF] [varchar](20) NULL, [FILIAL_NUMBER] [varchar](20) NULL, [INDEX_POS] [int] NULL, [DESC_ACTIVIDADE] [varchar](100) NULL ) ON...


SQL Server 2005 : CLR Integration and Programming.

Specify SQL Type - Hello I have a CLR SQL Function with a signature that looks like this... public static long fnCreateKey(string value) { ... } The function is working...


SQL Server 2005 : SQL Server 2005 General Discussion

date format while inserting irrespective of regional settings - as per my understanding If I pass a date to sql server to insert it will parse the date on...


SQL Server 2005 : SQL Server 2005 Performance Tuning

How can I check the Long Running Query by using Stats.. - Hi All, Here am Using SQL 2008, How can i check the Long Running Query by using the following Query and how...


SQL Server 2005 : SQL Server 2005 Integration Services

is it possible to save data in excel by user id - is it possible to save data in excel by userID and also need to email the file too Here is the...


SQL Server 2005 : T-SQL (SS2K5)

Output random dates that falls on a weekday - I have a column called Transaction Date. I'd like to populate a new date that falls within 12 days from...

BCP to Text Files. Odd Character at File End - I'm trying to streamline a manual process here by using BCP to create some text files. I want the test...

Using T-SQL or SQL script can we create a data dictionary - Hello: Is it possible to create a data dictionary for all the tables in a SQL database using a SQL...


Reporting Services : Reporting Services

Field value as a parameter - I need to create a parameter using the value of an indicator: =CInt(IIF(Fields!Passed.Value, 1, iif(Fields!Passed.Value is nothing, -1, 0))) The values...

SubReports Issues in SSRS 2005 Reports Upgrade to 2012 - Hi there! We are planning to upgrade our SSRS 2005 reports to SSRS 2012. As I heard there will are some...

Parameter for one cell - I have created a drilldown report. Is there a way to create a parameter based on an indicator value for...


Reporting Services : Reporting Services 2008 Development

SSRS 2008R@_Reporting Services: Got an error message "Timeout expired" when doing "Request Fields" for a stored procedure. - Hello BI experts, I have successfully ran the sp on SSMS and got the results(about 30 thousands records) and it's fine....

How to split the data in ssrs - Hello, I have a textbox in the header where I am trying to split the field The column data in...

Format for year to display in grouping(SSRS) report - Hello, I have an SSRS report where I have a single dataset; I am using parameter as fiscal year. only one...

ssrs 2008 textbox expression value - In an SSRS 2008 existing report, I wouuld like a particular textbox to look like the following when there is...

Center a report in a Web Page - Hello all, I have noticed when I create a report and deploy it or preview it, everything is alligned to the...

How to show NO DATA FOUND message when there is no data in SSRS - Hello, My report is grouping with school wise;for each system I have different schools and each school has data;for some...


Data Warehousing : Integration Services

populating an Excel spreadsheet beneath header rows - Hello, trying to use SSIS to populate a spreadsheet is a labor for Hercules. Why Microsoft, with all its billions...

Examples of a Script Tasks using external dlls - I'm working with an ERP accounting package and exploring the possibility of using SSIS as the primary tool for data...

SSIS Package Execution - Hi All, I need help to execute a taxk. I have text file which has SQL Statements something like Select top 10 * from...


Data Warehousing : Strategies and Ideas

Design Steps for logical modeling of Dimensional DataMart - Hi begin to understand the process off building a Data warehouse off of an OLTP database. So thought I would put...


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

Every forum post has an ///Edit button - All the forum posts seem to have an Edit button on them, see screenshot attached as example. When clicking the button,...


SQLServerCentral.com : Articles Requested

Consolidated Dates Queries - I have seen a few questions about how to get the first, last days of the month, year, etc. Can...


SQL Server 7,2000 : Administration

move sql 2008 r2 to different server? - wonder if anybody has experience with a "slick" move of SQL server installation ( OLTP, SSAS, SSRS, SSIS, Replication subscriber ) to...


Career : Certification

Upgrade Exams - I already have the certifications MCSE Data Platform and BI under SQL Server 2012. Is there an upgrade to SQL...


Notification Services : Administration

Decrypt DTSRun package name - Hi all, Does anyone know how to decrypt the name of a dts package from within a sql job. As in...

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