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

Sensor Data

Most of us don't deal with sensors in our jobs. Or do we? So many devices are in use these days, with a wide variety of inputs that many of us might not realize that applications might be capturing some of this data, which is more akin to sensor data than manually entered data. I would suspect that the meta data might vastly exceed the amount of data entered in text boxes in many of our databases in the future. It might be location, time, action, event, or some other data that we store, manage, and link to data that users choose to submit.

The Black Hat conference took place recently and one of the sessions talks about the proliferation of cheap sensors that could be used to potentially track individuals without their knowledge. That's an interesting use of hacking skills, cheap technology, visualizations, and of course, lots of data. While there are plenty of scary privacy implications here, especially for criminal activity, I could see other uses as well.

Imagine that you work in a retail environment? You might want to know how people move around your store, potentially in order to redesign your store. What about industrial centers? Additional data about parts flowing has resulted in more efficient workflow, but with even more sensors and data, you might find new ways to improve productivity. UPS and FedEx have used technology to vastly increase their efficiency; how many other companies could take advantage of sensor data and find new ways to run their businesses.

I expect to see more and more data being collected in all sorts of organizations (commercial, government, and others) as more sensors and other hardware become inexpensive. Just as the decline in the cost of computers has enabled almost every organization to take advantage of their capabilities, I expect the new types of sensor data will allow data professionals new opportunities. All the additional data gives us the chance to perform all types of analysis, data mining, and more. It's a good time to be working in the data field, with new opportunities appearing every day.

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

MP4 iPod Video ( 19.5MB) feed

MP3 Audio ( 4.0MB) feed

Feeds are available at iTunes and Mevio

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


ADVERTISEMENT

New! Easy retention policies for offsite backups

Quickly and easily delete old offsite backups with new features in SQL Backup Pro. Get your first 5GB of storage free. Find out more.

ADVERTISEMENT
25 Secrets for Faster ASP.NET Applications

Free eBook: 25 Secrets for Faster ASP.NET Applications

Want to speed up your web application? Our new eBook has 25 tips for getting maximum performance from ASP.NET - download it free.

SQL Developer Bundle

12 must-have SQL Server tools

The award-winning SQL Developer Bundle contains 12 tools for faster, simpler SQL Server development. Download a free trial.

Featured Contents

 

Variable Default Values to a Stored Procedure (SQL Spackle)

Dwain Camps from SQLServerCentral.com

A way to assign variable and overrideable defaults to input parameters to an SP or FUNCTION using a configurations table. More »


 

SQL Server Reporting Services Tips and Tricks to Improve the End User Experience

Additional Articles from MSSQLTips.com

In this article we'll take a look at the following Tips and Tricks for SSRS: Display Total Number of Pages while Navigating, Display Everything in a Single Page, Display Report Parameter Selection, Display No Rows Error Message, Page Settings for Optimal Printing. More »


 

New SQL Monitor Custom Metric: Large Transaction Log Files

Additional Articles from Red-Gate

If the transaction log autogrows rapidly, it can suggest that log backups are not being carried out frequently enough, or another resource may be preventing the log from truncating. This metric measures the number of transaction log files that are greater than 10 GB. The associated alert is raised when the number of files exceeds a specified threshold. More »


 

From the SQLServerCentral Blogs - Backup Your Certificate for TDE

Steve Jones from SQLServerCentral.com

If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database... More »


 

From the SQLServerCentral Blogs - Duplicate Statistics

matt.bowler from SQLServerCentral.com

The Setup: Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there... More »

Question of the Day

Today's Question (by Dwain Camps):

What is the difference between the following 2 queries:

-- 1
SELECT ROW_NUMBER() OVER (ORDER BY NEWID())
 FROM sys.all_columns

-- 2
SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NEWID()))
 FROM sys.all_columns

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: T-SQL.

We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the Contribution Center.

ADVERTISEMENT

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

It's Labor Day in the US. Today's question is "how many points are the fun, holiday questions worth?"

Answer: 7

Explanation: I can't help you if you miss this question.

» Discuss this question and answer on the forums

Featured Script

Script out/store all indexes on a server

MyDoggieJessie from SQLServerCentral.com

This nifty little script has bailed me out on a couple of occasions. It's really quite simple and I will definitely admit it probably could be "fixed" up a whole lot, but it does work as-is (but you will need to change the send mail section at the end).

At our company we tend to work a lot with Transaction Replication and often when we've had to take new snapshots of our tables, we lose all of the non clustered indexes that were specifically used for reporting on the tables that were previously replicated. I wrote these scripts (partial snippets taken from various sites across the net) to assist in recreating those indexes, either from issues with replication, accidental deletion/change, or just to feel safe knowing I had their definitions stored somehwere!  

The last script will basically loop through the entire server/database your specify and create the indexes for you, sending you an email for each failed index that fails to get created.

The first script creates a table to store the indexes.

The second script creates the SQL Agent Job.  You can eitherpaste the main segment of code directly into the job step where it says "INSERT CODE FROM ABOVE INTO THIS JOB STEP", or create a stored-procedure, and use that instead.

Deploy the job/procedure to any server you wish to keep back up your index definitions, setting an appropriate schedule for it to run.

Use the final portion of code to loop through the table created in step 1, to automagically create the indexes on the target server.

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 2012 : SQL 2012 - General

AAG Backup - Hi all I have 2 doubts on this can anyone please clarify: On primary for system database backup I have...

label policy-row level security - Hi all, anyone have any idea what is label policy? whether it will affect performance of application? thanks sathiyan

Creating scalar functions in tsql - Hi all, Firstly many apologies if this is in the wrong place. I'm basicly trying to create a scalar function that...

How to login using sqlcmd - Hi, my rdbms version :2012 sqlexpress I created the login using the below commands: [code="sql"] SETUSER GO USE master GO IF EXISTS( SELECT * FROM sysdatabases WHERE name='permissionsDB' ) DROP...

Is there a sql server equivalent of whoami? - Hi, my rdbms version is 2012 sqlexpress. is there a way to find out what login am I currently login using a...

RBS (Remote BLOB Storage) - Hi all, I'm looking into creating a new database for a fairly large application, which includes a feature for creating and...

SQL Server 2012 developer tools - Hi all, I have a quick question for you. What software would i download to get a database developer access to...

Upgrade SQL Server 2012 from 2008 R2 - I have a new Server with Windows Server 2012 installed. I'm going to install SQL Server 2012 Enterprise Edition. I have some...


SQL Server 2012 : SQL Server 2012 - T-SQL

it's a bug? - Hello guys, I've this command: Select db_name(DB_ID()) as DBName,SS.name as SchemaName,SO.name as TableName, SI.name as Indexname,index_type_desc as IndexType ,avg_fragmentation_in_percent as FragmentationPercentage, (case...

Need Help on query - [code="plain"] create table sample ( a date,b date, c date ,d date ) insert into sample values (null,GETDATE(),GETDATE(),GETDATE()) insert into sample values (null,GETDATE(),GETDATE(),null) insert into...

Scalar function help-New to tsql - Hi all, Firstly many apologies if this is in the wrong place. I'm basicly trying to create a scalar function that...

Pagination options SQL 2012 vs 2008 (Performance perspective) - I need to understand which one is better with respect to performance : 1. SQL 2012 has introducted FETCH OFFSET ... SELECT...

Pagination options SQL 2012 vs 2008 (Performance perspective) - Comparison with respect to performance - pagination options: 1. SQL 2012 has introducted FETCH OFFSET ... 2. SQL 2008 has an option of...


SQL Server 2008 : SQL Server 2008 - General

Please help with a Trigger - Hi There, I have just joined this great forum. I have a question regarding Triggers pls I have a table dbo.Levels and I...

Updating using # table - Please help me to update the columns using a temp table by using inner join for a set of tables...

Match Varbinary(max) with another Varbinary(max) - i have a table with one binary column. that contains 0x00010100000101010101......00 column datalength is 35040, i am prepare this data...

uri format error in ssis 2008 R2 script task - Hi, I need to get the latest file from sharepoint. To get the file names in array, I am using the...

sql 2012 dumps - Can any one send the sql 2012 dumps for getting the certified ?

fill the missing/incorrect values for the gender column - Hi I have a gender column like this: Gender -------- F AAA M null F M null Can some give me an idea how can I create and implement a strategy...

export to csv - Hi Professionals I have a script thats exports to a csv file [code] exec exporttocsv 'select top 5 * from newtable', 'test.csv' [/code] the problem I...

Not able to select match and non match by left join - I would like to check category by lob that exists or not on the basis of @Match Parameter. I can do...

How to get how many memory is used for each T-SQL ? - Dear All, Please kindly help below, Many thanks! 1. how do you know that how many memory is used for each...

List objects to move - In one database(Order), all my objects (in this db, some objects are not my app) for a app have to...

Backup job fails but maintenance plan succeeds - The backups are in the desired destination, they restore just fine, and the maintenance plan log reports no errors. The agent...


SQL Server 2008 : T-SQL (SS2K8)

IF Statement based on Multiple SELECT Statements - Hi Basically, I'm attempting to write a statement based on multiple conditions. So, there will be 2 SELECT statements, IF the...

Use SUM() with GROUP BY? - Is it possible to use SUM() in a SELECT query that uses a series of CASE statements to group data...

Finding row number which caused the error in Table value parameter insertion - Hi I am trying to write a Bulk import procedure, i am using table value parameter to insert thousands of rows...

Proplem Put Filter ("And" or "Or") in Query - Table With two Feild Name,Tools Example Table : 1-Mike Walker 2-Mike Cane 3-Steve Walker 4-Mitchell Cane I want someone who uses both(Walker and Cane ) to...

Executed as user: MVS\sqlserver. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. [SQLSTATE 42000] (Error 468). The step failed. - Hi Guys, I need help in sorting out this job its begin failing for a week now. The code is as follows: --==================================Get...

Split Data - Hi All, I have written 3 queries and put them in 3 cte statements each is a different report. 1. FCR...

Query - I need a T sql query which should read and load text files data from the directory one file after...

sql query - Hello friends, Please help me in writing a query!! Question: Write a query based off of the following data stored in the AccountingEntry...

sql query - Hello friends, Please help me in finding the correct query!! Question: You need to find duplicate account’s in an Account table. The Account...

sp_getrecords to get all records from a table - Hi, I have tried and created one sp which will get the table name as input and will return all...


SQL Server 2008 : SQL Server Newbies

dynamic sql query?/ - where we use dynamic sql queries?? in my office we don't use dynamic sql queries but I am want to know...

I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I am getting desired result as I have tested this on small set of data ,but while running on large set of records it taking huge of amount of time, might be due to multiple nested while looping . Co - Hi Guys, I have written a Stored Procedure having 3 nested while loops in it .This is Working fine and I...

Help - I am DBA with two year of experience on SQL server 2008 R2, i have some questions that should i stick...

5nf - can anybody explain me about 5 normal form ? I have searched the internet but I am not convinced! please help Thanks and...


SQL Server 2008 : Security (SS2K8)

Tracking User access to a database on SQL 2008R2 Standard - Hi I am new to SQL 2008R2 Standard edition and I have been requested to track users/l ogins trying to access...


SQL Server 2008 : SQL Server 2008 Administration

sql server using more memory issue - sql server is 2008 r2 on 64 bit systems and os is windows 2008. Hi friends at one of our client...

high cpu and parallelism - Hi Everyone, I was just doing a read-up upon high-cpu and CXPACKET wait/parallelism. One thing, which is over my reach is below...

unable to connect to server - Hi all. here we are trying to connect to server which is not accessible and it through the below error. Error:The operating...

The package execution returned DTSER_FAILURE (1) - Hi I am having a problem when running a maintenance plan(full database backup) in my environment as i get the...

Emailing from SQL 2008 using 'EX:\O' type addresses - I'm trying to do the simple task of sending emails to end-users when their case is closed on the database. Normally...


SQL Server 2008 : SQL Server 2008 Performance Tuning

Question related to missing index DMV's ? - This formula is given by microsoft to find out the index performance impact "user_seeks * avg_total_user_cost * ( avg_user_impact * 0.01 )". But what is...

intermittment slow data modification on sql 2008 r2 - Hi Folks, I am working with sql server 2008 r2 standard (build 10.50.4000) Occasionally (not all the time) we get slow data...


SQL Server 2005 : SQL Server 2005 Compact Edition

Duplicate Rows in certain time - Hello, i had this problem allready in a normal SQL Server Version and solve it with CTEs or Cursors. Now I have...


SQL Server 2005 : SQL Server 2005 General Discussion

Which page record,extents are currently used as mixed.. - Hi All, I would like to know here about pages ... as Which pages record, which extents are currently used as mixed...


SQL Server 2005 : T-SQL (SS2K5)

Division by zero on a SQL Instance while a different Instance run correctly - Hi I run the same query against two DB, one is the publisher and other is the subscriber. The two DB should...


Reporting Services : Reporting Services

Using SharePoint 2010 Lists in SSRS 2012 Filters / Parameter Questions - Hi all, We are trying to do a report off multiple SP Lists in a single report. im having trouble finding...

How to get the Report URL in SSRS - Hi Folks, Could you please let me know how to get the Report URL(i,e the URL gets generated after the report...

Regenerate SSRS Subscription Agent jobs - Hi gurus. We have a method in place for disaster recovering SSRS (from a production primary to log shipping secondary). The...

Migrating SQL 2000 Reporting Services to 2008 SSRS - I have several dozen reports that need to be migrated from SQL 2000 Reporting Services to SQL 2008 SSRS. the...


Data Warehousing : Integration Services

Warnings loading SSIS Configuration File - Hello Everybody: While working in BIDS, I get the following warnings as soon as I open a package: Warning loading DataWarehouse.dtsx: The...

package opens up as xml file - Hi I am quite new to SSIS and I am having the following problem. I want to open the ssis package locally...

SSIS data connection to Oracle database issue - Hi All, I have looked at thhis issue for couple of days and endless googling did not come out with the...


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

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

Microsoft Certified Master - There's been a lot of debate recently about whether certifications are worth doing and whether they provide you or your...

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