Tags » SQL Server

top 15 sql server interview questions with answers

Q. What is sub query and its properties?
A. A sub-query is a query which can be nested inside a main query like Select, Update, Insert or Delete statements. 802 more words

Interview

Find Currently Executing Jobs Running Longer Than 30 Day Average

–By Lori Brown   @SQLSupahStah

I needed to update some of our long running job monitoring code to improve it from the version that we have right now. 476 more words

SQL Server

TSQL to find Databases, corresponding elastic pool names and DB edition - Azure

-- TSQL to find Databases, corresponding elastic pool names and DB edition

SELECT
       @@SERVERNAME as ,
       dso.elastic_pool_name,
       d.name as DatabaseName,
       dso.edition
FROM
       sys.databases d inner join sys.database_service_objectives dso on d.database_id = dso.database_id
WHERE d.Name <> 'master'
ORDER BY
       d.name, dso.elastic_pool_name
--
--
… 46 more words
SQL

A new kind of adventure - Podcast

Today me and my colleague Alexander (@arcticdba) created our first podcast. We do not, as of today, have a name for it – but we have two great personalities and some really interesting content. 49 more words

Okategoriserade

Trouble Shooting for Error 7311 and Error 7412

Problem

We have an ETL job which failed recently, an alert was sent to us:

SQL Server Job System: ‘XXX-XXXXX’ completed on \\SQL001

JOB RUN:            ‘XXX-XXXXX’ was run on 1/1/2017 at 0:00:00 PM… 228 more words

SQL Server

SQL Server Error - Incorrect time syntax in time string used with WAITFOR.

This is a simple one but it doesn’t stick until you write/read about it.  Note, I use WAITFOR DELAY to pause/sleep the session between batches or T-SQL commands. 122 more words

SQL Server

Why Use Red Gate’s SQL Multi Script?

Someone once told me at the shop that we have plenty of software utilities laying around that could be very useful that no one is utilizing. 946 more words

SQLServerPedia Syndication