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

Fun at Work

I am lucky in that I get to travel and speak at a number of events every year. As a result, I meet lots of people in a variety of situations. Many of these places have a social component and often result in pictures. I love that because pictures are memories for me, and I look back at them to reminisce about good times in life.  I greatly appreciate having Facebook remind me of images from the past, some of which I'll share back out as they're great memories for others in my family.

This has changed dramatically in the last decade, as everyone seems to have a camera on them at all times in their phone. That means many more memories I can capture. Some of these are silly, and I wrote a blog with some of the funny ones I've gotten over the years. In the past, I have relatively few pictures from work. Early in my career, film cameras were rare. We only carried them around for special events, which wasn't often at work. I do have actual physical pictures of a few work parties, but rarely of workspaces and situations. There are certainly some I wish I'd been able to capture and save.

For many of you, I'm sure that's different now. Some of you have grown up with cameras and spent most of your career with them. When I asked about desks, quite a few of you posted pictures, with some really interesting items. Those are likely going to be fun memories for you at some point in the future.

Today I'm wondering if you have some funny, silly, even head shake photos of yourself or work. Nothing that will get anyone in trouble or be offensive, but maybe you've run across a sign on a wall, some wild cabling, or even a snapshot of you and others celebrating some accomplishment. If you can share them. Check out the fun pics on my blog over the years that make me smile, and if any of you have old pictures of me, please post or send them along.

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 ( 3.1MB) 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.

ADVERTISEMENT
SITC

SQL in the City Summits - New York, London & Chicago

This October Redgate are inviting those interested in learning how their business can benefit from implementing Compliant Database DevOps to attend one of our SQL in the City Summits. If you manage SQL Server databases, or manage a team of people who do so,  Redgate’s SQL in the City Summit is the conference for you. Find out who’s presenting and register for a Summit near you today.
Register now

SQL Prompt

Become a more efficient SQL developer with SQL Prompt

Learn how to write SQL faster and more efficiently with these exclusive short videos from Data Platform MVPs and SQL Server experts. With SQL Prompt you can strip out the repetition of coding and write SQL 50% faster. Check out the tips

Featured Contents

 

Trust, or Verify – How FKs Can (or Cannot) Help Performance

Hugo Kornelis from SQLServerCentral.com

Learn how trusted foreign keys (FK) can help or hurt performance. More »


 

Setting Up SQL Server: People Still Need Help

Additional Articles from Brent Ozar Unlimited Blog

Erik points out a few things that SQL Server should offer to configure by default. More »


 

Gene Kim joins Redgate to discuss The 2018 Accelerate State of DevOps Report

SQL Server Central editor Steve Jones is joined by acclaimed author and researcher Gene Kim to discuss the latest in all things DevOps. More »


 

From the SQLServerCentral Blogs - Identifying records with special characters (Unicode)

er.mr.lehkara from SQLServerCentral Blogs

Occasionally Data analyst may fall in a situation, where they need to identify records holding special characters or only the... More »


 

From the SQLServerCentral Blogs - Warning: Expect Delays

Roland Alexander STL from SQLServerCentral Blogs

Imagine you are driving somewhere – to work, to the mall, wherever – and you encounter a massive traffic jam. Wall-to-wall, bumper-to-bumper,... More »

Question of the Day

Today's Question (by Steve Jones):

What does DBCC stand for?

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

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

Exam Ref 70-765 Provisioning SQL Databases

Prepare for Microsoft Exam 70-765–and help demonstrate your real-world mastery of provisioning SQL Server databases both on premise and in SQL Azure. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I decide to add a computed column to one of my tables. I use this code:

 ALTER TABLE dbo.OrderDetails ADD LineTotal AS qty * UnitPrice PERSISTED 

I want to index this column. What happens when I run this code?

 CREATE INDEX OrderDetailsIX_LineTotal ON dbo.OrderDetails (LineTotal)

Answer: The index is created

Explanation:

Indexes can be created on persisted computed columns.

Ref: CREATE INDEX - click here


» Discuss this question and answer on the forums

Featured Script

SQL Server Shortcut to take Table Backup

sathish NS from SQLServerCentral.com

SQL Short keyboard option helps to take table backup by pressing the shortcut keys.

1. Create the procedure "sp_tablebackup" as system stored procedure on master database.

2. Create shortcut key on keyboard shortcut options(Tools>Options>Keyboard>place the created system stored procedure "sp_tablebackup" on any of the short cut key)and press ok.

3. For example if the system stored procedure is added on shortcut key "CTRL+3",we can take the table backup by selecting any tables and by pressing "CTRL+3" option.

4. This option takes table backup with the name "Tablename_currentdate", and this backup table will be stored on the same database(if required we can save it on other locations too).

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 2017 : SQL Server 2017 - Administration

Question about handling commit_table waits - Dear SQL Server professionals,  Thank you for looking into my question.   I have a 3 node cluster (with no shared storage !!) with...

List of all instance names in my server - In my computer I have installed 3  SQL Server instances (different editions). While connected to one of them and running [code...

File sizes in system tables - I am querying select * from sys.master_files in order to know the file sizes of my database files. I wonder what...


SQL Server 2017 : SQL Server 2017 - Development

Convert Varchar field - I have a Varchar field with units in inches :( that i need to convert to an integer (Unfortunately the " and...

ADDING FIELDS WITH A SELECT STATEMENT - Can someone kindly help me with the query below: SELECT 1 AS ID, '1    Field, COALESCE(SUM(Field1)/1000,'0.0')  AS Field FROM Table WHERE Condition='Money' and SecondCondition...


SQL Server 2016 : SQL Server 2016 - Administration

Large MSDB database - Good Morning, I have a SQL 2016 box that has a large MSDB database, the log file it self it 6gb....

Always on Install - Hi  I am following these notes for always on install and have some basic queries: http://www.sqlservercentral.com/blogs/ganapathis-mssqllover/2017/02/20/alwayson-availability-groups-step-by-step-setup/ For step 9 Click the Add… button

Sanity check - Even if you had a tried and proven method of managing file growth, would you still think it ok to...

RedGate's SQL Doc and Extended Properties - I'm working on documenting our SQL data warehouse and am looking at getting RedGate's SQL Doc.  I wanted to get...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

OPTION (USE HINT ( 'FORCE_LEGACY_CARDINALITY_ESTIMATION' ))? - I need to review this simple query written by someone else a while ago, i have to review it for...

Returning same line number for each line on Subquery with XML Query - Hello community, I built this stored procedure to create an XML file with a specific structure and using Row_Number () to distinguish...

Bullk insert in sql server.. - Hi all , I have text file with second row is blank,data start with 3rd row .due to one server to ...

Multiple Joins - Hi guys, just a general question. I'm writing a query in order to create quite a large report. I have multiple...


SQL Server 2014 : Administration - SQL Server 2014

Mirroring - Working on setting up SQL Server mirroring. Following are the steps I am thinking to do.. Take Full Backup and Transaction...

Embedded Product key - Hi  Experts, We downloaded the image below from  VLSC and install it on the server.We paid,and the product key is embedded. Do SQL...


SQL Server 2014 : Development - SQL Server 2014

Enforce Unique Constraint Across Two Tables - I have an interesting problem.  An application allows users to "Tag" events with a label.  Each user can put a...


SQL Server 2012 : SQL 2012 - General

Huge number of tables - Hi all, I've inherited a situation where we have a business critical system with gigantic number of tables, 240,000 - yes, nearly...


Data Warehousing : Integration Services

Is it possible to retrieve name(s) of SSIS package(s) that have an Exec SQL task that executes a specific SP? - Is it possible to find out names of SSIS packages scheduled via Agent that that execute a specific stored procedure...

File Delete Not Working Once Deployed - The following script embedded in a package works in the IDE but when deployed and run from an Agent Job...

Insert new records from one database to another using SSIS - I have a table with Table 1 ( taskid bigint , name varchar(200),  tasktype varchar(500)) , what I trying to achieve is every...

This email has been sent to newsletter@newslettercollector.com. 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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com