March 25, 2016 at 4:40 am
All,
I've been having some login trouble on our new SQL 2012 servers. Old logins that I'm trying to delete from databases are not deleting and I don't know why. My last post on this thread has not been answered in almost two weeks, so I'm hoping someone here can take a gander.
Please and thank you.
March 25, 2016 at 5:30 am
Yikes! Are you a Verizon customer? You may have had your data hacked.
March 25, 2016 at 10:31 am
Anyone want to take a stab at this. Essentially the OP needs a csv splitter that handles text qualifiers; Eirikur Eiriksson's RFC-4180 compliant splitter from this article: This article[/url] would be perfect but it would need to work in SQL Server 2008.
-- Itzik Ben-Gan 2001
March 29, 2016 at 11:26 am
Ugh, so not looking forward to tomorrow...
Get to spend most of the day in a "new employee orientation" thing (which runs into Thursday for Pete's sake!) despite having worked here now for just over 3 years.
But, the boss says go, so I say "sure thing!"
Of course, if he sent me out looking for brake light fluid, I'd run down to the little shop and grab a Mountain Dew...
:hehe:
March 29, 2016 at 11:33 am
jasona.work (3/29/2016)
Of course, if he sent me out looking for brake light fluid, I'd run down to the little shop and grab a Mountain Dew...:hehe:
And now we know why you need the orientation. I bet you get lost in the breakroom on the way to meetings too. @=)
March 29, 2016 at 11:53 am
Brandie Tarvin (3/29/2016)
jasona.work (3/29/2016)
Of course, if he sent me out looking for brake light fluid, I'd run down to the little shop and grab a Mountain Dew...:hehe:
And now we know why you need the orientation. I bet you get lost in the breakroom on the way to meetings too. @=)
Time for us to sign the Code of Ethics Acknowledgement. One line "To the best of my knowledge, my associates and I have complied..."
Do I really want to sign this?
As to training. IT has to take the same training as the collectors. Why do I need to know how to talk with people about collections. My response is "Here, let me transfer you to the operator." Also works when they call for support 😛
March 29, 2016 at 2:04 pm
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 29, 2016 at 2:13 pm
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.
If they answer the first question on page 2 correctly, do you get to skip to page 4? The page where you start asking about page internals?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
March 29, 2016 at 2:25 pm
SQLRNNR (3/29/2016)
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.If they answer the first question on page 2 correctly, do you get to skip to page 4? The page where you start asking about page internals?
That would be somewhat close to a "choose your own adventure" style test, which would be interesting ;-).
Do you ever have the candidate write code, such as a Stored Procedure, on a white board during the interview? The last place I worked at typically had people do simple queries to prove that they could do LEFT JOIN and HAVING type stuff. But I changed it to having people write a full stored procedure. It was a great way to see how someone would actually code. And if they started out simple, it was a good lead-in to asking about transactions, TRY / CATCH, etc. It was interesting to see people do well on the technical questions but not have much ability to be truly useful. We avoided some close-calls by doing this.
SQL# — https://SQLsharp.com/ ( SQLCLR library ofover 340 Functions and Procedures)
Sql Quantum Lift — https://SqlQuantumLift.com/ ( company )
Sql Quantum Leap — https://SqlQuantumLeap.com/ ( blog )
Info sites — Collations • Module Signing • SQLCLR
March 29, 2016 at 2:25 pm
SQLRNNR (3/29/2016)
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.If they answer the first question on page 2 correctly, do you get to skip to page 4? The page where you start asking about page internals?
LOL. This is for a developer position but around here we all do our own sql as we don't have a DBA. Page 2 is where the actual developer questions start. I ended 2 interviews after asking the simple "explain one way you can get the current system time with t-sql". In both cases these people claimed 5-10 years of experience "with complex procedures and triggers". Surely somewhere in those complex queries was something difficult like the current time. I would probably even be ok with something like "I don't know so I pass it in as a parameter". I would probably suggest that isn't the best way but it would have adequately answered the question. These interviews are not for a senior position or anything. We just need somebody that come on board for a 6 month contract to help us with some development to help finish up a project.
We have a stringent list of requirements:
•Have a pulse.
•Be reasonably competent as a developer.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 29, 2016 at 2:35 pm
Sean Lange (3/29/2016)
SQLRNNR (3/29/2016)
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.If they answer the first question on page 2 correctly, do you get to skip to page 4? The page where you start asking about page internals?
LOL. This is for a developer position but around here we all do our own sql as we don't have a DBA. Page 2 is where the actual developer questions start. I ended 2 interviews after asking the simple "explain one way you can get the current system time with t-sql". In both cases these people claimed 5-10 years of experience "with complex procedures and triggers". Surely somewhere in those complex queries was something difficult like the current time. I would probably even be ok with something like "I don't know so I pass it in as a parameter". I would probably suggest that isn't the best way but it would have adequately answered the question. These interviews are not for a senior position or anything. We just need somebody that come on board for a 6 month contract to help us with some development to help finish up a project.
We have a stringent list of requirements:
•Have a pulse.
•Be reasonably competent as a developer.
Sean...are you able to post the "job advert"?
in my experience (UK) the job adverts requires skills across multiple platforms (SQL DBS / TSQL / SSIS / SSAS...and then dot Net / java...yadda yadda)
would be interesting to understand what "you asked for" to relate to the applicants that interviwed
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
March 29, 2016 at 2:39 pm
J Livingston SQL (3/29/2016)
Sean Lange (3/29/2016)
SQLRNNR (3/29/2016)
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.If they answer the first question on page 2 correctly, do you get to skip to page 4? The page where you start asking about page internals?
LOL. This is for a developer position but around here we all do our own sql as we don't have a DBA. Page 2 is where the actual developer questions start. I ended 2 interviews after asking the simple "explain one way you can get the current system time with t-sql". In both cases these people claimed 5-10 years of experience "with complex procedures and triggers". Surely somewhere in those complex queries was something difficult like the current time. I would probably even be ok with something like "I don't know so I pass it in as a parameter". I would probably suggest that isn't the best way but it would have adequately answered the question. These interviews are not for a senior position or anything. We just need somebody that come on board for a 6 month contract to help us with some development to help finish up a project.
We have a stringent list of requirements:
•Have a pulse.
•Be reasonably competent as a developer.
Sean...are you able to post the "job advert"?
in my experience (UK) the job adverts requires skills across multiple platforms (SQL DBS / TSQL / SSIS / SSAS...and then dot Net / java...yadda yadda)
would be interesting to understand what "you asked for" to relate to the applicants that interviwed
That is a great question. I will see if I can find it anywhere.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 29, 2016 at 2:46 pm
Solomon Rutzky (3/29/2016)
SQLRNNR (3/29/2016)
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate(). The response was much as I would expect. An immediate answer that sounded timid and somewhat questioning. They obviously knew getdate() since it rolled off their tongue before even thinking about it and then you could see the look concern as it came out wondering if it really such a stupidly easy question. Especially with the look in their eyes of "seriously these are the kinds of questions you ask?". The upside was I was allowed immediately to switch to page 2 of my questions. Phew!!! There is only 1 more interview this week. At this point there is a clear leader in my mind.If they answer the first question on page 2 correctly, do you get to skip to page 4? The page where you start asking about page internals?
That would be somewhat close to a "choose your own adventure" style test, which would be interesting ;-).
Do you ever have the candidate write code, such as a Stored Procedure, on a white board during the interview? The last place I worked at typically had people do simple queries to prove that they could do LEFT JOIN and HAVING type stuff. But I changed it to having people write a full stored procedure. It was a great way to see how someone would actually code. And if they started out simple, it was a good lead-in to asking about transactions, TRY / CATCH, etc. It was interesting to see people do well on the technical questions but not have much ability to be truly useful. We avoided some close-calls by doing this.
Since this is really a c# position with some requirements for sql we don't have them write any t-sql. We do however have them write a little bit of c#. There is also a test where I hand them a pretty simple program and ask them what is the output. I let them decide if they want to write it down, talk it through or whatever. It is interesting to see people work through the problem.
I realize this example is pretty contrived but it shouldn't be too challenging for anybody with even a few years of development under their belt.
What is the output from the code below?
using System;
namespace ConsoleApplication1
{
class Program
{
static void Main(string[] args)
{
Console.WriteLine(TestOutput("Hello World!"));
Console.ReadKey(true);
}
private static string TestOutput(string DisplayVal)
{
try
{
throw new Exception("Error Message.");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return DisplayVal;
}
finally
{
Console.WriteLine("Inside Finally.");
}
}
}
}
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
March 29, 2016 at 2:57 pm
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate().
Would you have skipped to page 3 if they had mentioned CURRENT_TIMESTAMP instead of getdate()?
March 29, 2016 at 3:01 pm
Hugo Kornelis (3/29/2016)
Sean Lange (3/29/2016)
Finally!!! Somebody who claims experience with sql server that knows getdate().Would you have skipped to page 3 if they had mentioned CURRENT_TIMESTAMP instead of getdate()?
LOL. The question literally said "name one way to get the current system time". I might have been surprised with CURRENT_TIMESTAMP but page 3??? That page is reserved exclusively for interviewees that can name the 54th parameter to DBCC TIMEWARP.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 53,251 through 53,265 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply