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

Telepresence

I remember seeing the telepresense robot on The Big Bang  Theory and thinking it was somewhat silly, and not a great substitute for a live person. The whole episode was a bit humorous and funny, with Sheldon attempting to prevent himself from befalling any harm by using the robot to substitute for him at work.

It's amazing how your view of the world can change in a few years. The past three years have had me traveling 15+ times a year to various events to deliver presentations on a variety of topics. However I'm cancelling all future talks in 2014, at least for live travel.

The VGo telepresence robot has been offered to Red Gate on a trial basis for us to test it in a number of ways. We are looking to use this robot to allow us to reach more users and deliver more talks as well as perform consulting for some of our customers. We have worked with VGo to not only allow a broadcast presence of myself or a developer from Red Gate, but we have built a turnkey demonstration system.

With a custom shipping container holding the VGo and a Gigbyte BRIX mounted on it, anyone can easily unpack the robot in minute, unfolding it in a room, plug it into power, a microphone, and a video projector. It will automatically power up and log onto the Verizon network, where I can connect to it from home and reconfigure it for local networking. I can not only control the robot and address an audience (as well as hear them), I can also control the various VMs on the BRIX and demonstrate any SQL Server setup that suits the talk.

As you might guess, this will allow me to broadcast to SQL Saturday events every week as well as attend many other conferences. If things work well, Red Gate is looking to deploy a few of these for not only presentations, but also for consulting in helping our customers use our tools to build robust software delivery piplines. We can ship one to a customer and then work with them in a remote situation.

I've very excited about the entire pilot, mostly because it's a joke on April 1. For now. Perhaps we'll give this a try at some point.

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

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com.

Everyday Jones

Follow Steve Jones on Twitter to find links and database related items and announcements.

ADVERTISEMENT
Worst Day as a DBA

NEW! The DBA Team in The Girl with the Backup Tattoo

Piña colada in the disk drives! How could any DBA do such a thing? And can the DBA Team undo the damage? Find out in Part 2 of their new series, 5 Worst Days in a DBA’s Life. Read the new article now.

SQL Source Control

24% of devs don’t use database source control – make sure you aren’t one of them

Version control is standard for application code, but databases haven’t caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out…

SQL Data Generator

Generate realistic test data, fast

“In less than the time it took me to get my coffee, I had a database with 2 million rows of data for each of 10 tables.” Stephanie Beach, QA Manager. Try SQL Data Generator now.

Featured Contents

 

SQL Server 2014 Has Been Released

Press Release from SQLServerCentral.com

Today is the first day of general availability for SQL Server 2014. More »


 

Limited Time Offer: Licensing by Scale for SQL Server

Steve Jones from SQLServerCentral.com

With the release of SQL Server 2014, the licensing options have changed slightly. Read on to discover how you might choose to change your licensing in the future. More »


 

Native C# in Stored Procedures

Steve Jones from SQLServerCentral.com

A new enhancement in SQL Server 2014 allows you to directly enter C# code in your stored procedures. More »


 

Solid State Tapes–Prelaunch News!

Andy Warren from SQLServerCentral.com

In the world of data it’s always been about speed. SSD’s have become very common on consumer machines and not unusual in corporate datacenters. More »


 

From the SQLServerCentral Blogs - SQL Server 2014 New Defaults

Grant Fritchey from SQLServerCentral.com

SQL Server 2014 is being released and a change in the defaults will ensure that more instances will run smoother. More »

Question of the Day

Today's Question (by Steve Jones):

What version of SQL Server is being released today?

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

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

Tribal SQL

SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!

Yesterday's Question of the Day

Yesterday's Question (by Anoo S Pillai):

A new database is created for entertaintment application. The create script follows:

CREATE DATABASE wonderland 
go 
USE wonderland 
go 
CREATE SCHEMA king_schema AUTHORIZATION dbo
go 
CREATE USER king_user FOR LOGIN king_login WITH DEFAULT_SCHEMA = king_schema
go
EXEC sp_addrolemember N'db_owner', N'king_user'
go

After creating the database, connected to the instance with king_login. Tried to create a table using the following script:

USE wonderland 
go 
CREATE TABLE wonders 
( 
  id INT 
, wonder VARCHAR(100)
)
 go

In which schema the table would be created ? 

Test environment : SQL 2008 R2, Collation - Latin1_General_CI_AI

Answer: Table will be created; the schema - it depends, it can be 'dbo' or 'king_schema'

Explanation:

The create table command is valid and hence table would be created.

By default, the table would be created in default schema. But there is a caveat - for members of sysadmin fixed server role the default schema would be dbo.

In this context it means -

If 'king_login' is a member of sysadmin fixed server role table would be created under schema dbo, other wise table would be created under schema king_schema.


» Discuss this question and answer on the forums

Featured Script

Script out passwords

Steve Jones from SQLServerCentral.com

Run it and see your passwords.

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

IDENTITY(1,1) doesn't work, from 17 jumped to 1001 - Hi, I have a table with PK column defined like IDENTITY(1,1), it has 16 entries, now after series of migration and...

Could having SSMS open for long periods of time, cause locking? - About an hour or so ago I had all of my users come to me, complaining that their application had...

SP - Hi, I have a sp. I alter stored procedure by adding some logic to that. How can I test that is...

What is a PREEMPTIVE_OS_ENCRYPTMESSAGE wait type? - I'm research an unusually high number of PREEMPTIVE_OS_ENCRYPTMESSAGE wait types on one of our SQL 2012 Standard Production Database installs....

columnstore index - add all columns? - When creating a column store index, are there any reasons not to include all columns, besides index size of course? i.e....

COMPARE TWO TABLES COPY MATCHING VALUS TO TABLE_C - i have 3 table table_A table_B table_C TABLE_A SNO NAME ID 1 RAJU [b] 070491[/b] 2 VAMSHI 089767 3 ARUNA 068908 TABLE_B SNO NAME ID 2 RAJU [b] 070491[/b] 4...

installing Sql 2012 Evaluation version on Windows 7 Pro - I have spent the past 3 days trying to get a clean version of SQL 2012 installed on my laptop. I...

Like operator - Query performance issue - Dear All Have a table with 15 million rows. And Almost 15 columns. I am using following query. which is very...

SQL 2012 AlwaysOn - Dear Gurus, I have a SQL Cluster with the followings. Windows Server 2008 R2 SQL Server 2012 Shared Storage(SAN) Now i have another requirement of...

SQL Server 2012 Express problem - help please! - So I'm trying to help one of my clients out. She's installed SQL Server 2012 Express as well as the...

DELETE FIRST 1000 ROWS - I HAVE TABLE LIKE BELOW 3000 ROWS NAME ADDRESS IDNO EMPCODE SVR HYD 123456 9876 SGH HSD 98765 987654 . . . . I WANT DELETE FIRST...

Tranaction Logs on a Test Box - Hello Everyone, and Happy Friday! I am doing some general housekeeping for a couple of our SQL boxes in the Development...

rewrite cursor to set based - Hi Is it possible to rewrite this function which is using cursor with set based operations ? any example how to do...


SQL Server 2012 : SQL Server 2012 - T-SQL

Query Governor 2012 - working when switched off ?!? - I am testing 11.0.3128 on a 12 core machine - this is a default SQL2012 installation on WindowsServer2008R2. I created 12 T-SQL...

Dates in different languages - Hello guys, I am sorry if this question is trivial Is there a way to make a single insert (in a...

Help With WHERE Statement - Okay friends, I'm having a hard time with this query. I have two tables, Inspections and InspectionsContacts. This is a...

RecursiveHierarchyCTE - Click on the attachment, save as text file (default option). Then open it and choose File, Save As, Save as...

How to get the date? - Hi Friends, I want to write a query to generate a report. I have a date column which will be holding...


SQL Server 2008 : SQL Server 2008 - General

Long-running query with no impact on the server - I have a view which is a union of three select statements. It ran ok before but now it ran...

Interesting SQL challenge - compare differences in cells and rows - I have a table... below is a limited version of what it looks like... ID, Received, TrailerID, Tyre1, Tyre2, Tyre3, Tyre4,...

SQL beginner - books and material - Hi Folks, I'm new to this forums. I currently work in System/Network support role and find it to be stressful. I...

Return days of Nth Week Of Current Year In Shamsi Format - Hello All Pro , I Want A SqlServer Function That Return Days(Dates) Of Nth Week Of Current Year In Shamsi(Jalali) Format... Plz...

Select statement and variables - Hi, I have a query which returns the correct data when I specify the variable @InYearMonths as any number between 1...

Incremental load from a linked server. - Hi, I need to do incremental loading from a source (a linked server in my db) to a destination which...

How to structure data for Backlog Reportoing in SSAS - Hi I am really struggling with a scenario.. I have a fact table that represent help desk calls. All my records...

SP with table valued parameters - Hi, I have a parent stored procedure which is calling the child stored procedure. The procedures are using table valued parameters....

Copy DB from Prod to QA - I need to copy the Production Database to QA and it's running 24/7. Before I do this, I just need...

mobile app to check jobs on sql agent - We have sql server 2008 R2 std edition and SQL server 2012 std edition on different environments. Is there a...

Escaping a close bracket ')' in an EXEC string. - Hi guys, Im having a problem with the EXEC function in an update program. When running a script I get the...

Shrinking databases, internals, trick and tips - Yeah, yeah, yeah, I know....never shrink your databases (unless you really have a good reason!). Well, we have good reason....

Can you determine an estimated execute time of an SQL statement - OK, I gotten a call in which I need to run 6 update statement on a staging environment,but before running...

Columns_updated() in a trigger started giving incorrect column after a column has been removed form the table. - Hi All, I am using SQL Server 2008 for my project. in one of my table I have written an update...

SQl Server doe not use the INCLUDE columns of an index - Good day, We defined an index with INCLUDE columns as suggested by the Execution Plan . However I found that the INCLUDE...

How to get this output? - How to get this output please help me.....[img]https://lh6.googleusercontent.com/-9289xp7gEpo/UzkRdlicORI/AAAAAAAAADo/Dz7eT32myAw/w266-h452-no/Qq.png[/img]

Memory Issue with Named Instance - Hi All! We have an issue that when we were allocating set amounts of memory to a group of named...

SQL 2008 - Find LOB objects - How to find the tables in a database which is having LOB columns. There are so many available in web,...

Sub Query and Left Joins to isolate data for Merge and Insert - Hello Data Wizards, I am looking to simplify some a script with joins. I do understand the logic of a join...

GUID Pirmary key - Hi, Can we have a GUID Column to primary key with nonclusterindex? Is nonclusterindex is needed while we run the GUID column...

Replication failing with Merge process could not enumerate - Hi All, Out of the blue my SQL server started going slow sporadically and every so often throws up some errors. SQL...


SQL Server 2008 : T-SQL (SS2K8)

sp_send_dbmail has formatting off on datetime when directing output to csv file - I am running this sql which creates a csv file and sends the output via email. One of the columns...

Spatial, lines crossing - Hi ... this is what I want to do to thousands of lines in one table .... find all lines with CROSSING...

Need help with runaway query using multiple APPLY joins - I’ve never written a query with multiple APPLY joins before and I’m running into some troubles with my first one....


SQL Server 2008 : SQL Server Newbies

Sorting based on last 12 months. - Hello, I have the two fields below and I would like to always sort by looking at the last twelve months....

Multiple SQL Server version instances on same machine, caveats?? - Hi guys, A little background blathering: I understand that different versions (an even different sp's) may be installed on the same...


SQL Server 2008 : SQL Server 2008 Administration

Replication Not Alerting (2008r2) - Hi, This weekend one of our publications expired and needed to be reinitialized. We found this out when it started causing...

TEMPDB issue - Hello, We have Sql 2008 and currently we having issue that TEMPDB is FULL, I have restarted the server but it's...

Data Deletion!! - Hi Experts, Every midnight 1 row is getting deleted from a particular table. Is there anyway to trace how it happens? I...

PAE for HyperV server? - Hi, Virtual OS: windows server 2008 enterprise 32 bit. Virtual memory: 16 GB For the 32 bit HV system, does applicable for PAE...

Evenly splitting large DB files - I am trying to split up a large database file into several smaller database files at work. So far I've...

Execute Permission Problem on Stored Procedure - Hi, I suspect I've missed something obvious, but I can't see it myself. I'm getting the message "The EXECUTE permission...


SQL Server 2005 : Administering

SP4 Installation on a 2 node Active/Passive Cluster - All, Please clarify the steps for service pack installation on a 2 node Active/Passive cluster. Current environment: SQL : 2005 Enterprise SP2 Windows: 2008 Which...

Raise error and Begin try - If my stored procedure throws exception, I need to catch the error. I used Begin try and logged the error.But...

Tempdb and version store clarification needed. - I am finding that a user running a daily search ([font="Times New Roman"]SELECT T1.* FROM TABLE T1 WHERE T1.acct = 5...

SQL Server Agent : Job Failure - Hello, I wish to put the result of a query in Excel then send it to a number of persons at...

User database moved to "System Databases" container - I need help. One of my user database is somehow moved to "System Databases" container in SQL Server Management Studio(I don't...

Provisioning SQL disk on a Compellent SAN - Does anyone have experience with optimizing storage for a VM (vSphere) hosting SQL Server 2005/2008, using a Compellent SAN for...

Exception happened when running extended stored procedure 'xp_enumerrorlogs' in the library 'xpstar90.dll'. SQL Server is terminating process 77. Exception type: Win32 exception; Exception code: 0xc0000005 - ..at 11 am today all maintenance plans started failing on one node. SQL 2005 SP3 CU2 64 Bit. The error message...


SQL Server 2005 : Backups

Backup failure - Need your help to resolve below error. Error:- Unable to start execution of step 1 (reason: The SSIS subsystem failed to...


SQL Server 2005 : Business Intelligence

Dynamic Dimension Security in Analysis Services based on User and Datasource Dimension - Hello I have an Question to Dynamic Dimension Security in AS. I have a following Problem. I want to Secure...

MSBI - Hello everyone, I am currently working with an organisation on reporting profile as business support coordinator. I have done MCA...


SQL Server 2005 : Development

Multiple select threads at same time. - Hi all, I am facing an issue in selecting a record from db.2 threads are getting executed with same query.The query...

Converting sequential time records into IN and OUT times - Hi, We have a Time & Attendance application that stores the time punched by each employee in a sequential format. There is...


SQL Server 2005 : SQL Server 2005 Integration Services

Can Package Be Run From Client Machine? Will Connect To Separate SQL Server Machine. - In a few months I will be installing a SQL Server package at a client's office. I've been doing SQL...

DTEXEC returning Exit Code 5 - I have a simple SSIS package that retrieves data from a formatted Excel spreadsheet. The Stored Procedure has the appropriate...

SSIS 2005: How to Dynamically Rename First Worksheet in Various Excel Files - Here's my situation... I'm working on a project for a client (I'm a newbie SSIS user, but have about 20 yrs....

SSIS Package not failing? - Hello - My SQL Server Agent shows successful completion of SSIS job but messages in Log File view shows that there...


SQL Server 2005 : T-SQL (SS2K5)

Update Where - Hi All, I have two tables users and usersproperties, users has all the users basic details and user properties hold there...


SQL Server 2005 : SQL Server Newbies

SEARCHABLE PDF'S - Hi Guys, I have a sql server 2005 table that stores a list of small pdf articles, there are over 1900...


Reporting Services : Reporting Services

ssrs 2012 - send email failure - Hi, I have scheduled a report but this is the error it shows: Failure sending mail: Failure sending mail. Do you know where...

Apparent Contradiction in SSRS Authentication - Hi, I think I've found an apparent contradiction in the SSRS authentication document for SQL Server 2012. Can anybody tell me...

SSRS - show reports like slideshow - Hi, I have a requirement to show reports (two reports)one after the other like a slide show. The first one already...

Data Driven Subscriptions without SQL Enterprise - Introduction Do you have SQL Reports that need to go to different people but each person's report has different parameters? Don't...


Reporting Services : Reporting Services 2008 Development

SSRS MAP Reports - HI, can any budy me give me link to download europe shape files for ssrs reports, its urgent, pls give...


Data Warehousing : Integration Services

Design Pattern: Create CSV list from N individual data flow rows - Hi guys, I am trying to generate a performance optimised package to get a limited set of records from a remote...

SSIS 2012 Environment Variables and Source Control - Hi - I would be interested to know whether any people have worked out how to get their SSISDB environment variables...

Store a Value in a Variable - I have one value in SSIS Aggregate transformation (Avg. value). Let the value be 5.50 . I want to store this...


Data Warehousing : Analysis Services

SSAS Deployment Utility - Has anyone had any success using the SSAS Deployment Utility for SQL Server 2012 (Microsoft.AnalysisServices.Deployment.exe)? It should be possible to...


Database Design : Design Ideas and Questions

Partitioned Table Mystery - I inherited a database that houses years of imports for one of our daily feeds. As it grew over time,...


SQLServerCentral.com : Anything that is NOT about SQL!

Talking baseball - Okay, a topic that has NOTHING to do with SQL . . . Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...

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


SQL Server 7,2000 : Administration

VB6 application connection timeout errors on Sql Server 2000 - As a recent addition to the IT staff at the organization I currently work at, and as far as I've...

Lost tables - DBCC checkdb, allow_data_loss - Hi, I have a cliente that has a database. The database got suspect after he restarted the Server. I doesn't have backups. ....... I...

when to use dbcc shrinkdatabase - Hi, When we need to use dbcc shrinkdatabase once i delete some bulk records or on timely bases? I am having a...


Career : Employers and Employees

DBAs happiest people at work - [Url] http://mobile.news.com.au/finance/work/careerbliss-survey-ranks-database-administrator-as-happiest-job-in-america/story-fnkgbb3b-1226868951892 [/url] is it really true??

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