Viewing 15 posts - 706 through 720 (of 14,953 total)
subha.msc2007 (10/4/2012)
i don't think too much difficulty on this post .
simple logic here: while filling DBA position commonly we will get answer from candidate side only, if our criteria...
October 4, 2012 at 1:37 pm
A calendar table will solve this kind of thing neatly.
Define a base calendar, of all days for the next X years (and some prior years as well), then add a...
October 4, 2012 at 1:18 pm
Clever.
Not sure I'd want SQL running under permissions that can access other servers, but if you limit it to read-only, the security window on that is limited.
I've been using a...
October 4, 2012 at 1:09 pm
Unless there's something else blocking the update, it should run like that.
I just ran this test:
CREATE TABLE #T (
JobNum INT,
RefreshDate DATETIME,
RecID INT);
INSERT INTO #T (JobNum, RefreshDate, RecID)
VALUES (1,GETDATE(), 1),(2,GETDATE(),2);
UPDATE T
SET...
October 4, 2012 at 1:06 pm
Lee Crain (10/3/2012)
All good questions.
If I knew I was not qualified to perform the interview myself, I would start by writing as good a job description as I was...
October 4, 2012 at 6:26 am
No such thing as global variables in T-SQL. They used to call some of the system functions "global variables", but they never really were that, and Microsoft stopped calling...
October 3, 2012 at 2:25 pm
You can add a primary key this way:
alter table dbo.MyTable
add constraint PK_MyTable primary key (column list);
Name it whatever you like. I name PK constraints "PK_" and the table name.
Lack...
October 3, 2012 at 2:06 pm
Sean Lange (10/3/2012)
surma.sql (10/3/2012)
Sean Lange (10/3/2012)
select *, ROW_NUMBER() over (PARTITION BY cStudentId Order by dtEnrollmentDate) as RowNum
from #temp1
ok, i got it.
But in my requirement, I insert the output to another...
October 3, 2012 at 1:34 pm
Yeah, I didn't dig into details. Was just suggesting a starting point.
I might have an old copy of SQL 2005 Dev sitting around at home, now that I think...
October 3, 2012 at 1:30 pm
A WaitFor in such a process is commonly there to give the server a chance to finish other threads/processes in between loops.
However, on a process like this, if you do...
October 3, 2012 at 1:24 pm
I searched for "sql server 2005 developer edition" on Google, and clicked on the Shopping filter (on the left) and found a couple of places that look like they still...
October 3, 2012 at 12:41 pm
I've done that before.
Set up a copy of Express Edition SQL Server on a laptop, put it in the interview room, and let them go to town on it.
It's easy...
October 3, 2012 at 11:23 am
ScottPletcher (10/2/2012)
sql-lover (10/2/2012)
bteraberry (10/2/2012)
ScottPletcher (10/2/2012)
Maybe I'm missing something.Why not just ALTER the column to be a bigint instead of an int?
He said these are very big tables. Altering the...
October 3, 2012 at 9:42 am
Is the computer part of an AD network that might deny permissions, even if they're okay locally? I think that can be done.
October 3, 2012 at 9:16 am
Lee Crain (10/3/2012)
Grant Fritchey (8/27/2012)
October 3, 2012 at 9:15 am
Viewing 15 posts - 706 through 720 (of 14,953 total)