Viewing 15 posts - 2,041 through 2,055 (of 2,339 total)
Jeff Moden (5/22/2015)As for "standard technical questions", they are a must. The difference is that you don't just sit there and listen to the applicant...
This is exactly the...
May 22, 2015 at 11:34 am
How about:
SELECT X.Warehouse,
CASE WHEN Total_Quantity > 10 THEN CONVERT(varchar(100), Total_Quantity) ELSE 'There are less than 10 items in this warehouse' END
FROM
(SELECT Warehouse, SUM(Quantity) Total_Quantity
FROM #Product
GROUP BY...
May 21, 2015 at 1:41 pm
A few more thoughts...
Is there any mechanism for a "parent" and "child" type questions?
Example 1, if you answer NO to question 5, you get taken to question 10. If...
May 21, 2015 at 12:56 pm
You can probably find a local company that will do all of the admin work for you and pay you as a W-2 employee.
They are going to want a percentage...
May 21, 2015 at 10:50 am
1. Throw the trigger away.
2. In the trigger, you do this code:
set @P_NEW_ID = NEXT VALUE FOR dbo.SEQ_MASTER
Do this in the insert procedure!
You have the sequence, do...
May 21, 2015 at 8:04 am
To pile on to Erland's suggestion, run a script that disables all logins except your own.
May 18, 2015 at 5:29 pm
Try this script.
May 18, 2015 at 1:46 pm
Instead of doing a backup, detach, copy and re-attach.
This should be faster, plus, as soon as you detach the database will become unavailable.
Use caution, however, there may be some transactions...
May 18, 2015 at 8:48 am
Eric M Russell (5/18/2015)
Sean Lange (5/18/2015)
Michael L John (5/18/2015)
Jeff Moden (5/18/2015)
andrew gothard (5/18/2015)
Jeff Moden (5/14/2015)
Me, the interviewer: As the Lead Developer on this project, we're...
May 18, 2015 at 8:38 am
One of the shortcomings of using the maintenance plan wizard is that it blindly re indexes everything, regardless if the index is fragmented or not.
Subsequently, maintenance takes longer, deadlocks...
May 18, 2015 at 8:17 am
Jeff Moden (5/18/2015)
andrew gothard (5/18/2015)
Jeff Moden (5/14/2015)
Me, the interviewer: As the Lead Developer on this project, we're very interested in someone that understands and can...
May 18, 2015 at 8:05 am
I would recommend a calendar table.
http://www.sqlservercentral.com/articles/Test-Driven+Development/71075/
May 18, 2015 at 7:59 am
Interviewer: If your database was a country, what country would it be?
My answer: North Korea, because it will be run by a dictator!
May 15, 2015 at 1:52 pm
Float is the problem. Compounded by dividing by an integer.
Is this money? Use decimal(21,5).
Floats are called inexact numerics for this reason. You may never get...
May 15, 2015 at 1:22 pm
+ 100.
I did not have enough caffeine today! As soon as I saw your post I hit myself on the head!
May 15, 2015 at 8:35 am
Viewing 15 posts - 2,041 through 2,055 (of 2,339 total)