NotManyPoints (2/3/2009)

---

Jonathan Kehayias (2/3/2009)

---

There are plenty of decent DBA/Developers out there that don't know about SQL Injection. Just look at the number of major sites that have been hit...

Grant Fritchey (2/3/2009)

---

This is going to cause the query to run slow since it has to run this query for every row of data in the FROM clause. Best to...

Entil'zha Veni. In Valen's Name!

Christopher Stobbs (2/3/2009)

---

wow I got so confused on a thread earlier today when someone was posting a thanks to Gail, and I was thinking to myself, well I don't see...

Please post table definitions, index definitions and the execution plan (saved as a .sqlplan file zipped and attached)

Jonathan Kehayias (2/3/2009)

---

Another thing to note is that what might seem 100 level to you may not be for someone else. I got flamed a few months back for...

elitejyo (2/3/2009)

---

IIf there are any active traces created using SQL Profiler they are listed as

id status path...

It was for a bit of fun this past weekend. You may have noticed...

idrees.butt (2/3/2009)

---

and the thing is that when I read common mistakes...I cant appreciate them since I dont know whats the correct way of doing that thing...what to do in this...

Not necessarily. There's a person on another SQL forum...

I doubt it.

You can't?

create table TestingVariables (id int, strng varchar(10))

insert into TestingVariables (id, strng) values (1,'a')

insert into...

It creates a two column table on the primary filegroup. It won't create a primary key because there's...

The path will be NULL because, according to SQL, it's not writing the trace to a file, it's streaming...

There's a backup history table somewhere in msdb. Backupset I think