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.
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.
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).
Hierarchical order by TSQL
- Dear Sir
create table Hierarchy
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...
Odd (n)VarChar Behavior
- Run the following:
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));
RaisError(@v,10,1) with NoWait;
Exec sp_executesql @v;
- 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
I have this query;
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
last 6 months data
Below is my table structure,
Table Name : MemberVisit
select * from(
select 1 as Id,'2014-01-13' as Visiteddate,20 as PutchaseAmount
select 1 as...
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
rank country city
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.