Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate SQL Source Control
The Voice of the DBA
 

The DBA's Twelve Days of Christmas

On the first day of Christmas my new DBA sent to me

A table with a primary key

On the second day of Christmas my new DBA sent to me

Two Foriegn Keys, and

A table with a primary key

On the third day of Christmas my new DBA sent to me

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the fourth day of Christmas my new DBA sent to me

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the fifth day of Christmas my new DBA sent to me

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the sixth day of Christmas my new DBA sent to me

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the seventh day of Christmas my new DBA sent to me

Seven maintenance jobs

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the eighth day of Christmas my new DBA sent to me

Eight tables to remove

Seven maintenance jobs

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the ninth day of Christmas my new DBA sent to me

Nine unit tests

Eight tables to remove

Seven maintenance jobs

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the 10th day of Christmas my new DBA sent to me

Ten database containers

Nine unit tests

Eight tables to remove

Seven maintenance jobs

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the 11th day of Christmas my new DBA sent to me

Eleven Extended Events

Ten database containers

Nine unit tests

Eight tables to remove

Seven maintenance jobs

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

On the 12th day of Christmas my new DBA sent to me

Twelve tickets already closed

Eleven Extended Events

Ten database containers

Nine unit tests

Eight tables to remove

Seven maintenance jobs

Six unnested views

Five execution plans

Four database roles

Three stored procs

Two Foriegn Keys, and

A table with a primary key

Steve Jones - SSC Editor

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

Redgate SQL Source Control
 
  Featured Contents

Curious Case of SUM Function

utsav from SQLServerCentral.com

How a simple SUM statement could change an output.

Overview of Azure SQL Database Networking

Additional Articles from Database Journal

Learn about the range of connectivity options available for Azure SQL Database deployments.

From the SQL Server Central Blogs - T-SQL Tuesday #121: Gifts received for this year

Koen Verbeeck from Koen Verbeeck

It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year. So what do I have to be...

From the SQL Server Central Blogs - A Quick Look at Travel

Steve Jones - SSC Editor from The Voice of the DBA

I was experimenting with visualizations the other day, and started playing with SandDance, a tool from Microsoft that you can use in Power BI or Azure Data Studio. I’ll...

 

  Question of the Day

Today's question (by Steve Jones - SSC Editor):

 

Knocking off early

It's the day before Christmas, and everyone in the Redgate office in the UK is knocking off at noon. I want to know when I can stop working in the US, since everyone else in the UK will go home. I have this code set up:
DECLARE @t DATETIMEOFFSET = '2019-12-24 12:00+00:00'
What should I add to my SELECT below to determine the time in Colorado (7 hours behind) that I can safely stop working?
SELECT

Think you know the answer? Click here, and find out if you are right.

 

 

  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

Finding SQL Logins

There is a DMV in the master database, called sys.sql_logins. This inherits data from another DMV. Which one?

Answer: sys.server_principals

Explanation: The sys.sql_logins DMV inherits from sys.server_principals, and it says so in the MS Docs. Ref:

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 2017 - Administration
Composite non-clustered index: will it still work if I use only one index col) ? - If I have an index  called idxT1_C1C2C3  on table T1 that is non-clustered non-unique non covering,  has 3 colums C1, C2, C3 in same order, and I run a query SELECT    FROM T1 WHERE C1 = 'value' can such query be expected at all to still use the idxT1_C1C2C3  index? Or […]
SQL Server 2016 - Administration
Why columnstore indexes are not very popular? - I noticed that many SQL Server shops do not even consider or discuss introducing columnstore indexes or in-memory columnstore indexes. While trying to solve performance issues with many queries in many other painful ways, this option is not even on the plate of DBAs and Developers and product owners agenda in many today's IT shops […]
SQL Server Agent replacement - Friends, I have a server, inherited, SQL Server with more than 150 jobs using ETLs, direct invokations for SPs, etc. This server, only job  is executing those jobs, because there are no user databases associated. I am just thinking, if could be a better way to program those tasks or my only option is to […]
SQL Server Pivot Table on two columns renaming one column - I've the following source table: --------------------------------------------------------------- | Id | GroupName | RuleName | RuleText | RuleValue | +-------------------------------------------------------------+ | 1 | Group1 | Exclude1 | Excluded (Reason1) | 1 | +-------------------------------------------------------------+ | 1 | Group1 | Exclude2 | Excluded (Reason2) | 1 | +-------------------------------------------------------------+ | 1 | Group1 | Exclude3 | Excluded (Reason3) | 1 […]
SSRS Email Log review - Hi gang, I need some guidance: I have a SQL server 2016 standard instance set up with SSRS on a remote server environment (running NetForum) I have been tasked with helping the report team allow scheduled reports to get sent via email. Seems simple, right? We are using Office 365. I set up an email […]
can I use Stretch database to migrate the database to azure. - HI Guys,   can I use Stretch database to migrate the database to azure.? how ?
Performance difference - I have a user sql from 3rd party started running terrible on prod server.  has 128 gig ram, 4 procs plenty of disk space.  It basically runs forever and buries tempdb (yes it is a cte and it is ugly).  take a backup of prod drop on uat server, 2 procs 16 gig of ram, […]
List of INDEX with create and DROP script should not include any constrains P/F - Hello Sir.. Please help me the script.. From entire database i want List of INDEX with CREATE and DROP INDEX script, But in this should not include any constrains like primary keys and Foreign keys. Please help any one have the script like this? Thank you..
SQL Server 2016 - Development and T-SQL
Pivot Query - /* I'm trying to write a query that uses a list of dates as a header and lists, lets say, employees and if they were in training on that day. I've made a start, but I can't get a pivot working Note: This, by necessity, is a made up scenario similar to what I'm trying […]
SQL 2012 - General
Uninstall SQL without uninstalling SSRS - We have a non-prod server that (long ago) we installed SQL Server on and we were only supposed to install the SSRS components. Long story short, corporate wants us to remove components we are not using due to security concerns. Nevermind that we've disabled the services, there are concerns. I'm not sure there's a good […]
SQL Server 2008 - General
weird sql problem. - Hi all, I´m not sure what I´m doing bad with this query: Situation: I need to select all the purchase order lines(poitem_all) that not exists in the table of requisition lines (preqlines). select po_num from poitem_all results with all the  purchase orders (po_num) for the table poitem_all. Ok. Then for select only that not exists […]
T-SQL (SS2K8)
plantation shutter exterior or interior grade - Here is a recent inquiry we received about an oval window, and our response with the customer: Customer Request– Hi there. I have an oval bathroom window for which I’m looking for Plantation shutters the hieght is 30? and the width is 40-1/2? I’m not sure if I prefer the fan -like, or horizontal louvre […]
is there any better way to export SQL server data into csv file? - I have  questions of exporting SQL server data, the details as below, thanks! how to use BCP export data from SQL server (table or view or stored procedures) into a csv file (supposing the file path is d:\temp) ? is there any better way to fast export SQL server data into csv file ?
Reporting Services
SSRS log error - We have a SQL server reporting server installed both database engine and SSRS service 2017 on it. The database only hosts the reporting database. I found a lot of repeating errors in the file: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles: 2019-12-10 15:00:04.0060|WARN|5|Exception deleting expired log fileSystem.IO.IOException: The process cannot access the file 'D:\Program Files\Microsoft SQL […]
ssrs 2012 column headers repeat on each page while the user is running the rpt - My issue I want to have column headers repeat on each page while the user is running (accessing) the ssrs report. I just started to work with ssrs 2012 reports. Recently I have workd with ssrs 2010 and ssrs 2008 reports. In the past when working with ssrs 2010 reports, I would select the 'advanced […]
 

 

RSS FeedTwitter

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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -