Hi and welcome to SSC.

The reason you are having such a hard time with this is because you have broken the rule of normalization where we only store a...

worker bee (11/14/2012)

---

Okay, I have a CASE stmt that is in the SELECT clause. I basically want to get rid of the CASE stmt and place the information in the...

Here is one of the articles that explains the deeper issues with NOLOCK.

http://www.jasonstrate.com/2012/06/the-side-effect-of-nolock/%5B/url%5D

DenisT (11/12/2012)

---

Sean,

Yes, I am aware about the possibility of dirty reads while using the NOLOCK hint. I really don't care about them in this case. I needed avoid any...

And don't forget as previously mentioned that the image datatype is deprecated. Instead use varbinary(max). It will behave the same way but is the newer preferred datatype for this.

That was actually posted quite nicely in...

Luis Cazares (11/9/2012)

---

Sean Lange (11/9/2012)

---

Luis Cazares (11/9/2012)

---

I'm a little more considerate than Sean and will tell you where to start. All these articles are at your disposal just by pressing...

I think that what you posted at the bottom of your post looks like a C# function? I don't think that is what your professor is looking for. They wants...

Luis Cazares (11/9/2012)

---

I'm a little more considerate than Sean and will tell you where to start. All these articles are at your disposal just by pressing F1 in SSMS.

Stored Procedures:...

Nathan Chapman (11/9/2012)

---

Hi Sean,

From the first DataSet

For the 1st DataSet ..

/* == RESULTS ==

Record GroupName HISTORY_ORDER Consec

300037 GroupD 1 1

300037 GroupD 2 2 <--2nd Consecutive occurance of...

I would write that query a little differently. I would instead write it as

select t1.Col1

from Tbl1 t1

join Tbl2 t2 on t1.Col1 = t2.Col2

where t1.Col1 = '52'

That to me is...

You can check select * from sys.master_files. That will give you a list of files that ARE in use. Then you could get a list of files in the directory....

marthasmithuk (11/9/2012)

---

Create stored procedure for users registration. Procedure accepts two parameters: username and password and introduces these two values into table entitled Users. Table users has three columns: ID, username...

Constraint checking will be a performance hit on insert and update statements. This is fairly insignificant most of the time. However I would not recommend adding defaults to every column...

sqlfriends (11/9/2012)

---

We have some older databases that on a server. Then we detached them. And decide after a while we will remove them

But now I forgot which are the mdf,...