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

Featured Script

Database Snapshot Create/Drop/Restore SQL Script.

The Voice of the DBA

Byte Me: Diagnosis Data

Bob Lang from SQLServerCentral.com

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

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

New SQL Monitor Reporting Module

SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial

Featured Contents

Stairway to Columnstore Indexes Level 13: Improvements in SQL Server 2016

Hugo Kornelis from SQLServerCentral.com

This stairway series was started in 2015. As such, the focus was on SQL Server 2012 and SQL Server 2014 only. When SQL Server 2016 was released, with lots of improvements in the columnstore technology, I decided to finish the planned levels with the original focus on SQL Server 2012 and 2014, and add one extra level with a brief overview of the improvements available in SQL Server 2016. More »

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Additional Articles from Redgate

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions. More »

Comparing SSIS Catalog Contents Using DBFit Framework

Additional Articles from SimpleTalk

When you are doing the rapid deployment of an updated SSIS project, there are a number of things you have to check to make sure that the deployment will be successful. These will include such settings as the values in environment variables, Package parameters and project parameters. The DbFit test framework turns out to be ideal for the purpose of doing final checks as part of a deployment process, as Nat Sundar demonstrates. More »

From the SQLServerCentral Blogs - Disabling the identity cache in SQL Server 2017

Andrew Pruski from SQLServerCentral Blogs

One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable... More »

Question of the Day

Today's Question (by Steve Jones):

What happens if I create a vector in R with disparate values, such as this:

x <- c(42, "Towel", TRUE)

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.

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

Securing SQL Server: DBAs Defending the Database

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Stanley Kapfunde):

For integers that are between 0 and 255, it is recommended to use which data type?

Answer: tinyint

Explanation:

Correct Answer is: tinyint

It is recommended to use tinyint instead of smallint,
int, or bigint if you want to store whole positive integers between 0 and 255. Thisis because tinyint is a fixed 1-byte field, whereas smallint is 2 bytes, int is 4 bytes,and bigint is a fixed 8-byte field.(Basit)

Ref: tinyint - click here

SQL Server 2014 Development Essentials by Basit A. Masood-Al-Farooq page 21.

» Discuss this question and answer on the forums

Featured Script

Database Snapshot Create/Drop/Restore SQL Script.

SQL Master from SQLServerCentral.com

Database Snapshot Creat/Drop/Restore SQL Script for Single or multiple data files of databases. The four steps are described in the script, but here are the summaries:

This SQL script to create database snapshot for ALL databases having a single data file except system DBs. It generates the SQL Query as OUTPUT.
This SQL script to create database snapshot for ALL databases having a multiple data file except system DBs. It generates the SQL Query as OUTPUT.
DROP the created database snapshots (Pl. make changes in sql query acc. to your requirements.)
Restore data from snapshot script (Pl. make changes in sql query acc. to your requirements.)

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 - Development and T-SQL

And/OR logic in SQL - Guys, Maybe most of your guys it is Simple question and it is simple question but I am a little...

Why do some DBAs avoid DATETIME2? - I've been considering using DATETIME2(3) over DATETIME for new work due to the 1-byte saving of equivalent values (DATETIME2(3) vs...

SQL Server 2014 : Administration - SQL Server 2014

Wrong Alert? - Hello I have created a job which send me an alert when D drive(dedicated drive for tempdb) free space is less than 2048...

trans log file growth - I'm using Microsoft SQL Server 2014 (SP2) (KB3171021) - 12.0.5000.0 (X64) Jun 17 2016 19:14:09 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based...

SQL 2012 to 2014 upgrade - We have SQL Server 2012 Standard edition server and planned to upgrade to SQL Server 2014. This is the data...

Index fragmentation - I have a table with two indexes. It has showing 60% fragmented. So tried rebuild the indexes. Still indexes are showing...

SQL server 2014 is very slow - Based on this report(performance monitor) can any one tell why the Sql server is running slow. many application have slow...

SQL Server 2014 : Development - SQL Server 2014

Query displaying redundant data for a menu item, menu has choices, but displays menu item multiple times with different choices - Ugh, I know that topic was ugly...Ill try to explain this as best I can...I am writing a report for...

SQL Server 2012 : SQL Server 2012 - T-SQL

Using DB email sending emails to 30000 users - Hi All, I have one table where there is a column that have email id's for more than 30000 users , using...

Find user connections to SQL server tables - I want to check, how many users are connected to any particular SQL Table and cube (SSAS). This will be...

SQL Server 2008 : SQL Server 2008 - General

Update Statistics - Hi All , I would like to know how often we need to update statistics for all databases ? I need to create...

Converting User SID Binary to String TSQL - Hello All, Basically I'm trying to use TSQL to convert user SIDS from Binary to String and visa versa but I'm...

SQL Server 2008 : T-SQL (SS2K8)

Need help to perform Weighted avg calculation to update back to table - Hi all, Actually i am working in banking domain. Our company has decided to change the data provider, so all the...

Split column value to rows. - Hi All, I was looking for code to split column value into separate rows.. Any help on this.. like for the example below...

SQL Server 2008 : SQL Server Newbies

Comparing Tables with Not Exist and Multiple Conditions - Hi, I'm trying to compare two tables, find results from T2 not in T1 with conditions. Below is what I have: --create table-- create...

Reporting Services : Reporting Services 2008 Development

ssrs 2008 final report totals - In an existing ssrs 2008 report, I want to add final report totals. I want the total line to be...

Data Warehousing : Integration Services

How to Add Data Conversion task dynamically - I am creating metadata driven SSIS package OLEDB Source to Excel Destination where Data conversion task required and need to...

Data Warehousing : Analysis Services

Question about Mesure groups/partitions - Hello, I passed my exam 70-467 and I had this question, please do you know the reply ? Thanks. You are designing...

SQLServerCentral.com : Articles Requested

Update on differences in table types (temp/var/user) - I'd like a short piece that explains the differences between temp tables, table variables, regular tables, user defined table types. When...

Open SSIS packages in BIDS - SHort simple article that shows how to open a package from any store (SQL Server, File system, etc.) in BIDS

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.