bobznkazoo (9/22/2011)

---

I am troubleshooting a daily process that bulk loads a New Product table, and then these new products are inserted into the regular Product Table. These two tables...

I am not familiar with anything in sql server. Most of the...

bmnelson (9/22/2011)

---

I am trying to create an indexed view that has spatial functions (STIntersects), but I get the error:

Msg 1982, Level 16, State 1, Line 2

Cannot create index on view...

abdul.irfan2 (9/22/2011)

---

Hello all, i am new to sql server dba and have been a oracle guy. Is there a view that i can query to get how many...

LAW1143 (9/22/2011)

---

Ive got a particularly large table that is purged at 65 days of retention. the purge is keeping up with new volume, and the row count is relatively...

Amy.G (9/22/2011)

---

Hello all. I have a problem. A downloaded table includes a "T" character at the end of a string to mark where changes were made. I do not need...

ringovski (9/21/2011)

---

Hi,

I am trying to add two columns from table SHIFT. Column DURATION(INT) to COLUMN STARTTIME(datetime) and then put the result in a variable.

1. Convert DURATION to hours;

SELECT CONVERT(varchar, DATEADD(SS,Duration,...

This is just a shot in the dark, but if you are able to exlude the retired transactions it should take care of the problem. It seems like you...

You need to use an in keyword instead of =

Your sub query is return more then one row, but your where clause before the sub query has an =.

If you...

My degree is in Physics, but when I graduated all the jobs were in programming. Most of the CS majors I knew if they stayed in computers they did...

I think DBA boot camp would be beneficial, but who has 6 to 8 weeks. Only really large companies that already have a bunch of DBA's could afford this....

Did anyone notice the question of the day has a misspelling? It says service boker, instead of service broker.

Anyway, Thanks Steve for all you do to make Sql Server...

Funny, you had me going there. I even remembered this morning it was April 1.

If you are looking for a laugh I would suggest RED. My wife and I watched it and laughed a lot. It is just over the top. ...

So I am curious, who won? I didn't think I had much of a chance to win, but I threw my response with my reasons in the hat. ...