I would do it something like this:

Declare @Component smallint = -1

...

Faye Fouladi (12/24/2012)

---

How do I correct the following statement:

Declare @Component smallint = -1

...

Actually, just found one reference here: http://www.sqlservercentral.com/articles/RAID/88945/.

I may be wrong, so if I am please tell me so. Aren't logical reads reads from data cached in memory? Would these be good reads as SQL...

Disclaimer: I don't agree with what you are doing....

Are you storing the passwords encrypted, hased, hased with salt, or plain text? How is the password being passed to the login procedure as well?

Anyone with links to RAID 10 vs RAID 5, please post them here.

ScottPletcher (12/24/2012)

---

You also need to verify that the log LUNs are RAID10 and the data LUNs are RAID5 (typically that is the best performance).

If you're going to put both tempdb...

Are you talking about looking up a custom (application based) username/password or looking up a SQL Server or Windows password based on a username?

SQLDCH (12/24/2012)

---

LOL you wrote your own recap, I love it.

Congrats Lynn, repeat champion is an awesome feat.

Thanks to all who participated. Hopefully next year I won't be starting a...

SQLDCH (12/24/2012)

---

LOL you wrote your own recap, I love it.

Congrats Lynn, repeat champion is an awesome feat.

Thanks to all who participated. Hopefully next year I won't be starting a...

Ray K (12/24/2012)

---

Aaaaaaand . . . for the second straight year, I clinch a playoff bye, and proceed to go 0-2 in the postseason. Go me! 😛

Congrats, Lynn,...

TravisDBA (12/21/2012)

---

On the MCM, you are forgetting about one big thing. The cost:

•Nonrefundable program application fee: $125

•Program fee: $18,500 (three-week program in Redmond, WA)

•Non-lab exam retakes: $250 (Exam 88-970)

•Lab exam...

And then you get this:

Shadab Shah (12/23/2012)

---

I create a table as CREATE TABLE DEMO (A INT)

Then i deleted it as follow

DELETE DEMO

I tried to again recreate the table using the...

Shadab Shah (12/23/2012)

---

I create a table as CREATE TABLE DEMO (A INT)

Then i deleted it as follow

DELETE DEMO

I tried to again recreate the table using the same above statement, But...