SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

Delightful Database Diversion

Fair warning, this one is a bit harder than the last few!

Answer key will be posted in the comments in a day or two.

Across

5. Run this before upgrading to SQL 2017

8. Copy of the database but not backwards.

11. Instead of INSERT

13. Rerun a trace against multiple locations

15. Uses hypothetical indexes

16. Evaporate data into the blue

17. Default default schema

19. UNMASK

20. Not normal

22. Update here, insert there

24. Free Enterprise SQL

26. Picture of the database.

Down

1. This data needs a bath.

2. It's not a fact

3. Window into the server

4. Ignores logon triggers

6. Used to edit SSIS

7. Delete a database

9. After ALTER

10. We are never going to get out of this one on our own.

12. Replication limbo

14. OLAP DB

18. Comma

21. Watch out for Bobby!

22. Go deeper into a report

23. Consistency Checker

25. Information

Kenneth Fisher from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

ADVERTISEMENT
Redgate Hub

The best career move you can make

On the new Redgate Hub, we’ve gathered together a wealth of information to help you solve problems, share ideas and discover the latest insights. Whatever you need to know about to advance your career, the answer is probably right here. Move to the Redgate Hub

SQL Clone

SQL Clone: Now supporting databases up to 64TB

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free

Featured Contents

 

Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

Gregory Larsen from SQLServerCentral.com

When you build applications that store data in SQL Server you will most likely have to store dates and times, and you’ll call functions to do date manipulations. It is important to understand the different date and time data types, and when to use one data type over another. In this level I will be exploring the different date and time data types and discussing when each type is appropriate. More »


 

Free eBook: SQL Server Internals: In-Memory OLTP

Press Release from Redgate

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton. More »


 

How to use a Project in SQL Server Management Studio

Additional Articles from MSSQLTips.com

Matteo Lorini shows how to setup a project in SSMS to organize files. More »


 

From the SQLServerCentral Blogs - TSQL2sDay – Get-PostRoundup

Rob Sewell from SQLServerCentral Blogs

First an apology, this round up is late! The reason for that is an error in the PowerShell testing module Pester... More »


 

From the SQLServerCentral Blogs - Hmmm… What’s This?

SQLEspresso from SQLServerCentral Blogs

OK So, I am doing some digging and peaking around again in SQL Server and came across a database option... More »

Question of the Day

Today's Question (by Steve Jones):

I have a CSV with a number of rows and columns that looks like this:

I want to read this into a dataframe in R. What command should I use? Assume the filename is c:\nfl\2016qbstats.csv.

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: R Language.

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

The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced.  Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I've got a table of integers only and I want to put one trillion rows in the table for some testing. However, I'm worried about space. Which table should I create to use the minimal space?

Answer: CREATE TABLE dbo.LotsofIntegers (ID BIGINT, INDEX LotsofIntCDX CLUSTERED COLUMNSTORE) ;

Explanation:

One trillion integers won't fit in an INT column so a BIGINT type is needed. However, with rowstore data, this will be around 10TB. With a clustered columnstore, this will be under a GB.

Ref: The Trillion Row Table - click here


» Discuss this question and answer on the forums

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

SQL 2016 link server - Our environment requires that I create a link server from SQL to Oracle. The current production system functions as expected....

Scripting out schema permissions - Hi all Help please!   Why does it seem so complicated to script out schema permissions in SQL? I've got various scripts...

Error moving log.ldf - Hi all, Tried moving log.ldf to another drive but hit error. Script and error as below... ALTER DATABASE dbName set offline ALTER DATABASE...


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

SSIS: Case clause with sintax error - Dear all, I am creating a derivated column task. It has a case in the expression but I always get the...

Get the year and Qtr - Ia am trying to get the year and Qtr from my date column which has values like- YYYY-MM (2017-02). I...

Substring - I get a files with a dates e.g Generate20170922, These files are stored like this in the db. I want...

Query running slow across linked server - Hi all Firstly, apologies for the lengthy post, but I'm trying to get everything in I thought would be useful. I've got...

Challenge: Insert a specific number of rows based on an integer column in one query! - I am creating promo codes. They are issued simply by inserting a record for the customer into the PromoCode table....

.bat file fails in SSIS - I have created a Execute Process task that runs a .bat file. This bat file creates a very small .txt...

One of my Passed Exam of MCSA shows in MCSE, Why? - Hello, I passed MCSA today. When I see the requirement for MCSE, among the list, it shows an exam (70-762) to get...


SQL Server 2014 : Development - SQL Server 2014

TSQL Query help plz.. - Hi All, Need tsql help please. Below is the sample schema/tables and description is written at the end(my requirement). use master go...


SQL Server 2012 : SQL 2012 - General

Entire Database Encryption - Dear Experts, My requirement is to encrypt entire database. Even DBA does not view data from the database(Not talking about column...


SQL Server 2012 : SQL Server 2012 - T-SQL

Creating a table from existing table. - I have a table which is 175GB in size. I am working on getting only the data from August and...

Updating 1 record in Table A with multiple records in Table B - Hello.  SQL Server 2012, novice level programmer.  I am trying to UPDATE a master table with records from a daily...

Database trigger to send email after column in table is updated. - Hello all, Thank you for any help given in advance, it is much appreciated. Scenario - What I require is a database trigger...


SQL Server 2008 : SQL Server 2008 - General

Recover data from encrypted log file - I have a 2008 R2 database encrypted using TDE that crashed. The MDF was lost, but the LDF survived. I was...

Column Length - Dear All, Question regarding the length of a column . As its understandable it has to be in accordance with the data...

Occasional mysterious time outs on SQL Server db table - Hi there, We have users in the field who use a mobile web GIS application (using Java) which use forms to edit/update spatial...


SQL Server 2008 : SQL Server 2008 Administration

Faster way to release the Unused Space back to Disk - Hi, I have few databases that have 8 data files allocated with 300 GB each and used only 110 - 120...


Data Warehousing : Integration Services

SSIS package shows successful but not working - I have an SSIS package that was executing successfully for some time but last week started erroring.  The error on...

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