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

Oddball Interview Questions

Today we have a guest editorial from Andy Warren as Steve is traveling.

Recently I was reading an article on Glassdoornbsp;titled Top 25 Oddball Interview Questions. Just from the title you can probably guess, but a small sample of the questions includes:

  • If you were a box of cereal, what would you be and why?
  • How many snow shovels sold in the US last year?

I look at the questions and I wonder, do these really help determine aptitude and fit? I believe a great hire means matching on skills and how they fit into the culture and understanding what they want to accomplish. Aside from some small talk to check people skills, every question I ask takes my time and their time, so I only ask questions that help me assess quickly. Do these questions do that? It doesn’t seem that way (and so maybe they wouldn’t hire me!).

Note: If you have a couple minutes, read the answers posted by various readers to the list above. Some of them are reallllly funny.

Interviews are hard. Hard for the interviewer and hard for the interviewee. It’s a test (and a first date). Imagine you’re sitting there trying so hard to listen and give answers that are correct and that you believe in, then you get one of these - what do you do? I imagine the tendency is to fight through, try to give some answer while you’re trying to decipher the hidden meaning. Do they want funny? Serious? Some knowledge you don’t have? Is it just a stressor or is it an cultural test?

Thinking back, I’ve never been asked anything like these in an interview. That makes me wonder if they aren’t just about marketing, a way to build mystique and signal the kind of culture they have (or think they have), though it could just as easily be that I interviewed at plain vanilla companies!

So I’m curious. Have you had to answer oddball interview questions and if so, how did it turn out? If you haven’t ever had this come up, what’s your thought - would you try to answer or would you walk away or something else? Let’s chat in the forums.

Andy Warren from SQLServerCentral.com

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

ADVERTISEMENT
SQL DBA Bundle

Free eBook - Performance Tuning with DMVs

This free eBook provides you with the core techniques and scripts to monitor your query execution, index usage, session and transaction activity, disk IO, and more. Download the free eBook

SQL Source Control

Get your SQL Server database under version control now!

Version control is standard for applications, but databases haven’t caught up. So how can you bring database development up to speed? Why should you start? Find out…

SQL Compare

Compare and Sync database schemas

Whether creating new databases or updating older ones, SQL Compare means no object gets left behind. It’s the gold standard, and you can try it free.

Featured Contents

 

Five Rules For Successful Conversations With Developers

Joshua Feierman from SQLServerCentral.com

In this piece, Josh follows up on his earlier article about smoothing DBA/Developer interactions, this time from the side of the developers. More »


 

SQL Server Database Connectivity Testing Using PowerShell

Additional Articles from MSSQLTips.com

There are several networking issues that can prevent the user from reaching or connecting to the SQL Server database. Learn how to test your SQL Server connectivity with PowerShell. More »


 

From the SQLServerCentral Blogs - T-SQL Tuesday #051: Place Your Bets

Jason Brimhall from SQLServerCentral Blogs

Place Your Bets All bets on the table please.  This is the last call for bets, no new bets will be... More »


 

From the SQLServerCentral Blogs - SQL Deep Dives at Intersection in April

Steve Jones from SQLServerCentral Blogs

SQL Intersection is coming to Orlando in April, along with the rest of the Dev Intersection events the week of... More »

Question of the Day

Today's Question (by Steven Neumersky):

A week of Analysis Services

Which statements are correct for an SSAS Model using In-Memory Mode?

  1. MDX Queries can reference DAX Calculaions.
  2. DAX Queries can reference MDX calculations/measures.

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

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

SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steven Neumersky):

A week of Analysis Services

What operations can run in a parallel (multi-threaded) manner in an SSAS 2012 Tabular Solution? 

Answer: Vertipaq storage engine operations like Group By, Filter, Aggregation

Explanation:

Source:  Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services.  Sections 3 and 4.

http://msdn.microsoft.com/en-us/library/dn393915.aspx

Scans of the Analysis Services Storage Engine Cache occur in parallel at one thread per column per segment (unit of SSAS storage). These CAN include SUMS, GROUP BYS, AGGREGATES, and FILTERING depending on the location of these operations in the DAX Query. Operations such as ranking or sorting are NOT supported by the Vertipaq storage engine; therefore operations must be PUSHED to the single threaded formula engine.

Formula engine operations, although very rich in functionality, only occur single threaded. However, it IS possible for the STORAGE ENGINE to perform a "callback" operation to the formula engine, and these "callbacks" can occur in parallel.

Unlike the multidimensional model, partitions of the same table do not process in parallel in the tabular model. Partitions exist for administrative simplification. Parallel processing, however, CAN be executed at the TABLE level (multiple tables processing in parallel).


» Discuss this question and answer on the forums

Featured Script

SQL Server Index Defragmentation (Updated)

Gregory Ferdinandsen from SQLServerCentral.com

Defrags all indexes in select databases in 2005, 2008, and 2012.

Code is *thoroughly* documented throughout the stored procedure.

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 2014 : Development - SQL Server 2014

Hierarchical order by TSQL - Dear Sir create table Hierarchy ( ParentID int, ChildID int ) go insert into Hierarchy values (101,1),(1,6),(101,2),(2,4),(2,5),(5,6),(5,7),(101,3),(3,5) Please refer the Hierarchical order Diagram in order to understand how...

UNABLE TO RETRIEVE data while using between operator - Hi Experts, I came across a weird issue this morning while using Between operator am unable to retrieve data that starts with...

Subtotal when vendorcode changed. - Hi Experts, i need to write a stored procedure for a table with below columns for instance the table had 5 columns...


SQL Server 2012 : SQL 2012 - General

Result set from prior date - I'm trying to run counts for dates prior to today's date. I want to run a count from a table...

sql server profiler not running when clicking from tools in sql server management studio in sql server 2012 - Hi. I had sql server management studio for sql server 2012 installed on my pc when I started at this...

SQL Jobs - Hi, I have a job having two steps. I want run step1 every 30mins.Second step need to be run once...

Find additional connection parameters with DMV - Hi, is it possible to get additional connection parameters of connectionstrings like MultiSubnetFailover = true for open connections with Dynamic Management Views? Or...

Master Data Services - Cascading Business Rule on constrained attributes - Hi, I am hoping that someone can shed some light on an issue I am having with Business Rules I have 2...

Sql Server data replication - Hi, I have transactional replication setup from server A to Server B. I need to refresh the data on server B...

Setting up Service Broker to track user logins - I am looking for a Service Broker solution that can track who is logging into all my servers (66 last...

Scripting objects into TFS automatically - I'm looking for a way to automatically script database objects into TFS nightly. I've looked at ApexSQL Diff, Red-Gate, Randolph,...

How do I find out server name and instance name? Thanks - A very silly question: :blush: I just upgraded from SQL 2008 R2 to SQL 2012 and also installed Data Tools. I tried...

OS Disk Capacity Information - Hi I'm looking for the most straight forward way of populating a table that will record OS Disk space used for...

smo scripter changing the ordinal position of columns - I am using powershell and the smo.scripter object to create scripts to create tables. About 10% of the tables that...


SQL Server 2012 : SQL Server 2012 - T-SQL

Window function on different date ranges - Hi, I have a question regarding windowing functions. I have a sales order table with the columns "orderid", "customerid", "order_date" and...

Odd (n)VarChar Behavior - Run the following: [code] Declare @v nVarChar(4000); -- Test 1 Set @v='Select * from sys.indexes where type=0'; Select @v,Len(@v),DataLength(@v),Cast(@v as VarBinary(128)); Print @v; RaisError(@v,10,1) with NoWait; Exec(@v); Exec sp_executesql @v; --...

Exclude NULL values from select statement - Hi, Can anyone help me with this problem? I wrote a select statement, I only want to see orders with max...


SQL Server 2008 : SQL Server 2008 - General

Hi, I need to insert a XML file into table. - Hi, I need to insert a XML file into table using SQL server 2008. The issue is that when i try...

Query Help : pull Store Procedure name from Command - Hello I need help to develop logic, to pull Store Procedure name from command. see below is the table for that [code="sql"] CREATE TABLE...

I need to deduplicate a 800 million row table (100 million rows have duplicates) - What best way would you suggest that I use /T-SQL to DEDUPLICATE this 800 million-row table? (it has almost 100...

Conceptual Question Replicating Data from standalone SQL Server to AWS Cloud - This at the moment is a conceptual question as we are just looking at options. So the problem we want...

Number of times a function is accessed. - This is to learn how data is processed. I do realise that this may change over versions or even that the...

How to restrict memory in SQL Server 2008 R2 64 Bit Standard Edition - Hi, In one of my production database server total physical memory is 32GB and i restrict upto 28GB (Under server property)...

How to make a function a system function. - How do I make a function a system function, for example the function: DelimitedSplit8K How do I put this function into the...

For XML in row column format as PIVOT - Hi, Thanks for reading. I need to export data via SQL to XML. But I need the XML format in Row/column and...

convert - I am trying to set a variable so it displays the date 6 months ago unseperated so yyyymmdd I read that...

LCK_M_IX on tempdb? - Hi guys, This morning a guy was executing a stored procedure which loads data into a temp table then manipulates it...

Creating table from a Query results - Hi I have this query; select c.name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID where t.name= 'Hosea_tblDATA_NOTES'and c.is_identity = 0 order by...

How many partitions & files are supported in 2008R2 - Simple question. The partitioning scheme with indices calls for about 1100 file groups per year (one file per file group),...

table with a column be primary key and foreign key at same time - hi everybody I have two table that have many to many relationship so i add table between them.and this table column...

bcp import error numeric value out of range - Hello, I have table with columns of type int. I export this table by using bcp: bcp dbo.int_table out file.dat -q...

Help with date in sQL - I have date field named "[Latest Filled Date]" - format smalltimedate. I'm trying to do-If the "[Latest Filled Date]" equals the...

Does LiteSpeed works good for SQL 2012 - Can you advice whether to go for Litespeed. I've >1TB databases setup on SQL 2012.

Getting extended properties from every database - Hello I'm trying to get all extended properties for each database in my server. In the test machine with ten databases the...

Nested stored procedures and EXECUTE statements (Dynamic SQL) - Hi all, I have a wierd one. I can't provide specific code due to proprietary concerns, but let me see if...

last 6 months data - Hi, Below is my table structure, Table Name : MemberVisit Columns: Id,Visiteddate,PutchaseAmount sample data: [code="sql"] select * from( select 1 as Id,'2014-01-13' as Visiteddate,20 as PutchaseAmount union all select 1 as...

memory issue: manual memory settings - we have a server which has SQL 2008 R2 on it. Its in a cluster and we have set it up...


SQL Server 2008 : T-SQL (SS2K8)

Multiples address lines on a single row. Pivot? - I have scoured high & low for this solution, so in desperation I am posting here. I have a table show multiple...

How to write a Query to get related result - I need help to write a query like below oupt put. create table #table (id int, cid int , startdate datetime) insert #table select...

t-sql where statement - In t-sql 2008 r2, I am trying to determine how to setup the sql to accomplish the following goal: select table1.customer_id,type,start_date,end_date,Program_id from...

Brand new error - Invalid object name in T-SQL insert statement - I've been using SQL Server 2008 R2 for my web development for years and it's been working perfectly. But something...

Sysjobhistory - Step Fails but Job (Step 0) reports as successful - Hi, we have numerous scripts in place to track job failures etc. But I've noticed a few times that our...

Populate Dynamic Table Name in T-SQL Cursor - Can someone tell me how to dynamically populate my [table name] in these nested cursors to reflect the current month?...

AVOID JOINING ON TO THE SAME TABLE MULTIPLE TIMES? - Hi there, I need to join onto a table (Class_TB) twice because one of the conditions (Airline_FD) could be NULL, so...

Need help on SQL script - Hello, I am learning SQL and wondering if someone can help me with script below – not sure if I am...


SQL Server 2008 : SQL Server Newbies

Selecting rows in a table.. not so simple! - Table 1: A B C 1 1 4.7 2 1 4.7 3 1 4.7 Table 2: A D E 1 1a 1.2 1 1b 1.8 2 2a 2.1 2 2b...

Database mail alert fails for group account - This is a new SQL Server 2008 R2 standard edition 64 bit environment. I've been down this path before. I'm...

Returning multiple records when only one is specified - Hi, can someone please explain something to me. SET @NAMEID = '14359' IF @ADR2 IS NULL AND @ADR3 IS NULL SELECT ADR1, POSTAL_CODE, (STATE_NAME)...

Query with most expensive CPU usage - I find out a few top cpu consuming queries, what should I do with them? Thanks.

Extracting several rows of information - Hi Guys I am very new to SQL and I am busy using microsoft access to learn the syntax. I am trying...

Two results - I am looking to see the count of IDS, for both the sub categories separately . But don't know how to...

SSRS report objects aligning - Hi I have a SSRS reporting requirement where a table is required to be shown on report header part for displaying...


SQL Server 2008 : SQL Server 2008 High Availability

Restart mirroring for a log shipping environment after DR test - Hi all: I have a 3 server setup at this time. Goal is to do a DR test and bring the...

SQL SERVER 2008 R2 transaction log shipping - I have setup transaction log shipping in dev and QA successfully. But, on Prod log shipping everything working fine, the backup...

SP upgrade for SQL 2005 active/passive cluster - Can you share your experience for SP upgrade for SQL 2005 active/passive cluster. I have read that for sql 2005 you...

Undistributed Transactions in replication - Hi, I recently had a problem with replication where there were large numbers of Undistributed transactions/commands building up. In Replication monitor, I...


SQL Server 2008 : SQL Server 2008 Administration

"Remote Login Timeout" and "Remote Query Timeout" configuration options - I am trying to understand what these settings mean but BOL is not making it clear enough for me. I want...

created Subscription not lsited under local Subscription menu - Hello , Here i am trying to setup a Transactional Replication in my local environment . proposed structure is Server 1 - >...

Mirroring database can take Tlog backup? - Hi, Database has been configured in Mirroring for high availabilty, Can we take Tlog backup on regluar intervel of time in...

System.__ComObject while conveting - we are sending query results to the email using ssis task dynamically .we are executing query in all databases and...

SQL Server Auditing problem - Hi, I have created some auditing on SQL Server 2008 R2. It checks for select statements which are executed against a particular...

Sql server logs - Hi every one, I want to remove or clear log file viewer from sql server logs in sql server 2012 kindly...

How to rollback a service pack in sql 2005 and sql 2008 ? - Hi All, Can anyone share information about rollbacking a service pack? What are pre-cautionary steps i can take in SQL 2005 ? and...


SQL Server 2008 : SQL Server 2008 Performance Tuning

High CPU with many DB connections Prod almost down - Hi All, We are facing 95- 96 % CPU hike on our pord server. SQL Server 2008 R2 SP1 with 8 CPU...

Usage of Temprory Table in Stored Procedure - Dear All, For my project salary calculation writtened in Stored Proceure based.There is nearly 50 stored Procedure to Calculate different...


SQL Server 2005 : Administering

Service Pack question - Hi I just have a question regarding service packs and security patches. We have an old legacy box on 2005...

Blocked Processes - Hi, Am Getting alert message from third party monitoring tool saying that blocked process reaches 99% on the ms sql server...


SQL Server 2005 : Business Intelligence

What transformations will I need? - Hi all, we are rewriting a large number of DTS packages, I have done a quick sample audit of the...


SQL Server 2005 : SQL Server 2005 General Discussion

Try Catch with Bulk Insert - Hi All, I am having some trouble getting the following code to work, in 2005. I am trying to load a...


SQL Server 2005 : SQL Server 2005 Integration Services

SSIS Lookup - Return Unique Matches Only - I am validating a large database of addresses. I've already deployed a number of ways to validate city, state and...

How can I capture SSIS events in my package at one place - Hi All, I have a package built in SQL Server 2008. In that package I am capturing the following events (and...

How comma separated values are divided into rows? - Hi Experts, I have the input: rank country city 1 india hyderabad, bangalore, delhi, shimla 2 usa newjersey, newyork, washington, texas 3 uk london, greenland, denmark, italy, spain expected output: rank country city 1...


SQL Server 2005 : T-SQL (SS2K5)

Number of Records Affected - I would like to know how to run an update or delete query and have a chance to commit or...

Index with a column varchar(50) - Is recommended that créate an index with a column that is varchar?

Nan,#Error,Infinity Values displaying in ssrs reports - When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I wanted to avoid this and display...

List DB users - I was looking for a method of querying my SQL Server 2000/2005/2008 databases to gather a list of Databases users...

Get Unique Transaction ID For The Current Transaction - Hi all :) When multiple tables are updated in a single transaction, is there any way to tie those changes together...


Reporting Services : Reporting Services

rdlc pagesize problems - I have designed a local ssrs report with the following sizes which I'm trying to display from a C# application: The...

Reporting Database and OLAP combined? - I am planning a couple of projects and wondered if I could combine efforts. We have two specific goals: 1. Reduce load...

SSDT Very Slow In SSRS/SSIS When Previewing - We seem to having an issue with SSDT very slow in previewing reports. We have narrowed down any possible CPU...

Data Driven Subscriptions without SQL Enterprise - Introduction Do you have SQL Reports that need to go to different people but each person's report has different parameters? Don't...


Reporting Services : Reporting Services 2008 Development

need help with complex SSRS report request: - Hi, first time posting here and I have a report requirement that I cannot seem to find any solution for....

SSRS IIF expression based on condition - I have a table in SSRS where I filter the table with type id 34,35,36 -and I will get sum...

Nan,#Error,Infinity Values displaying in ssrs reports - When I use calculation in generating reports, I get Nan,#Error,Infinity values in preview , I wanted to avoid this and display...

Multiple values in Actions - Can I pass multiple values to a subreport. I need to find the total value which is based on three values...

SSRS 2008 reporting issue - Hello, I'm new to this SSRS development and facing a bug improvement issue. I have one report where data gets...

SSRS 2008 conditional formatting with multiple conditions - Hi, I have a requirement to conditionally format cell (not row) backgroup colors using SSRS expressions (not custom code) based on...


Programming : XML

Problem with creating XML file by nesting functions - Hi all, I have a problem for which I can't find a solution, so any help would be greatly appreciated....


Data Warehousing : Integration Services

Developers and SSIS Packages settings in Visual Studio - We are using SQL Server 2012 EE SP1 and Visual Studio 2010 Shell. We are just getting into creating SSIS...

SSIS - Copying files from Dropbox - Hi guys 1- I'd like to perform a ForEachLoop in order to get a list of files from Dropbox and subsequently copy/move...

Deploy package to multiple servers - Hi, we currently have several servers running SSIS packages building tables for a data warehouse. These packages were created once and...

Error with SSIS and Excel - I am trying to use the Excel Connection Manager in SSIS 2008 R2. I have set Run64BitRuntime = false. I have...


Data Warehousing : Strategies and Ideas

Hires by month issue - our company is in the clothing hire business. Ive just started with them and they have no reporting to speak...


Data Warehousing : Analysis Services

SSAS Multiple Cascading Many to Many Join Issue - Hi All, I have a tricky issue that I can't seem to resolve regarding many to many joins in a SSAS...

SSAS Multidimensional Model Book - Hi, Can anybody recommend me a good SSAS Multidimensional model book? Preferably 2012 but 2008 is OK as well. I know...


SQLServerCentral.com : Anything that is NOT about SQL!

Today's Random Word! - HI When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...

Are the posted questions getting worse? - Is it me, or are the posted questions getting worse these days? I just read a post by someone apparently in...


SQL Server 7,2000 : T-SQL

CASE Statement multiple aurgument - Hello, I searched online and this forum and I am not convinced that I find the solution. I am trying to write...


Career : Employers and Employees

I'm .NET Developer with 3 years of experience. Looking to change career to DBA. Advise please. - Hi All, I've been working as .NET Developer ever since I grad from college 3 years ago, I've been staying in...

Advice Please - To Specialize or not to Specialize That is the Question - Hi All, I'm hoping for a little advice from people who are more experienced than myself (plenty on here :-)). I...

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