Viewing 15 posts - 3,886 through 3,900 (of 9,722 total)
SQL challenges don't help you improve your query logic, they just encourage people to use what they know. If you're trying to sharpen your skills, read up on best practices...
October 22, 2012 at 4:04 am
Sean Lange (10/19/2012)
tantcu (10/19/2012)
I have limited knowledge about SQL. Could you guys more specific or give me like a sample to apply?
BOL is the best place for this kind of...
October 19, 2012 at 11:54 am
That's good to know. Thanks for reporting it.
October 19, 2012 at 11:51 am
SQLRNNR (10/19/2012)
Sean Lange (10/19/2012)
October 19, 2012 at 11:49 am
SQL Server Books Online should be your first resource in understanding how queries work.
SQL Queries for Mere Mortals can give you the basics in writing the SELECT statement (the heart...
October 19, 2012 at 10:53 am
I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?
October 19, 2012 at 10:41 am
Hee.
October 19, 2012 at 10:39 am
Pass in a delimited concateonated list as a string. Then you can either use a bit of dynamic SQL so you don't have to convert it or you can parse...
October 19, 2012 at 10:37 am
You're welcome. BTW, sysjobhistory's run_date and run_time records when the job started, so that might also help you hook it up to a schedule.
October 19, 2012 at 10:31 am
What have you already tried?
How do you plan on tracking passwords & logins?
This is really more of a programming question that a SQL Server question. Could you explain how you...
October 19, 2012 at 10:28 am
Did you try SysJobActivity?
October 19, 2012 at 10:25 am
As Grant Gus said earlier, you might have found the sweet-spot company where you can learn the trade and not actually get called a lot, despite being on 24/7 call....
October 18, 2012 at 10:32 am
A few years back, my team had the biggest problem with an auto policy that shut down our PCs in the middle of the night. It took us forever to...
October 18, 2012 at 9:41 am
Nevermind. I didn't read your last post correctly.
October 18, 2012 at 7:42 am
GilaMonster (10/18/2012)
Brandie Tarvin (10/18/2012)
Jeff Moden (10/17/2012)
October 18, 2012 at 7:37 am
Viewing 15 posts - 3,886 through 3,900 (of 9,722 total)