Stefan Krzywicki (10/22/2012)

---

...Apple is easy. I tried to make one I could eat this past weekend. I have diabetes, so I had to change it a little. I made a...

If you could combine the jobs into one, TRUNCATE actually uses less restrictive locks than DELETE does. It also only logs pages instead of individual rows, which enables it to...

ChrisM@home (10/22/2012)

---

L' Eomot Inversé (10/22/2012)

---

Stefan Krzywicki (10/22/2012)

---

Brandie Tarvin (10/22/2012)

---

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're...

[font="Comic Sans MS"]The PI! It needs more slices![/font]

You know what I hate about pie charts?

You can never tell what filling they're using. And it's awfully hard to stick a...

baabhu (10/20/2012)

---

This is an OLTP system with tokens needs to...

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...

Sean Lange (10/19/2012)

---

BOL is the best place for this kind of...

That's good to know. Thanks for reporting it.

SQLRNNR (10/19/2012)

---

Sean Lange (10/19/2012)

---

Is it just me or is the entire SSC site slow today? For me I can barely navigate anywhere. Each click is taking a couple minutes. No...

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...

I have an odd question. Why do you need to delete 10000 records from your database every 4 minutes?

Hee.

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...

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.

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...