Viewing 15 posts - 28,306 through 28,320 (of 39,961 total)
At this job the title doesn't much matter. However when you look for the next job, the title will matter.
Really you've got a couple titles. I'd talk about this...
June 20, 2008 at 8:52 am
Great comments and while I was thinking of technical skills, I'm glad you ran with the communication and problem solving items. Those are really important and if you were hiring...
June 20, 2008 at 8:21 am
Change all your tables in the FROM clause to
FROM tablea inner join tableb
on tablea.x = tableb.x
The mixed join types might cause issues (ANSI and non-ANSI)
June 19, 2008 at 2:22 pm
you can do this with charindex or patindex. Search for the "." and then use substring to pull things out.
June 19, 2008 at 2:20 pm
There are about 150 SQL Server MVPs, about 1500 or so across all products. The number depends on funding and each MVP is evaluated against others in the quarter they...
June 19, 2008 at 2:17 pm
There are about 150 SQL Server MVPs, about 1500 or so across all products. The number depends on funding and each MVP is evaluated against others in the quarter they...
June 19, 2008 at 2:17 pm
Not sure, but please let us know if that fixes things.
June 19, 2008 at 11:55 am
Congrats as well and glad it worked out!
June 19, 2008 at 11:54 am
Better yet, give this to the accountants. Let them track purchases, you send them an update of when you have a new server and how it's configured.
June 19, 2008 at 11:34 am
you need to see how IIS is connecting to SQL Server. It can pass through credentials, it can ask for Windows credentials, or it can allow anonymous users and use...
June 19, 2008 at 11:34 am
do you mean you want to schedule this? You can right click in EM and script things out.
If you want this on a schedule, you'll need some DMO automation.
June 19, 2008 at 11:32 am
Is this Windows 2000? I've had issues there with Perfmon. Not sure if it still does it in W2K3 or W2k8.
June 19, 2008 at 11:30 am
Very strange. Is it always the same tables that are affected? Could there be an owner issue?
Is the data just gone, meaning it looks like the commands were never executed.
June 19, 2008 at 11:30 am
Can you show an attempt. We are seeing more and more test or interview questions and we don't want to give you the answer, we want to help you learn.
show...
June 19, 2008 at 11:27 am
Viewing 15 posts - 28,306 through 28,320 (of 39,961 total)