Viewing 15 posts - 5,536 through 5,550 (of 9,715 total)
hor_netuk (7/21/2011)
I know times are hard, but a job alert email subscription delivered me the attached vacancy today. For the record, I won't be applying. 😛
That salary can't be...
July 21, 2011 at 4:40 am
Stefan Krzywicki (7/20/2011)
I think that's just Steve's warning to people presenting at PASS to take care of their voices. He's showing what happens when you get a little hoarse.
Oi! That...
July 20, 2011 at 12:36 pm
We do not have enough information to fully answer your questions. We would need create table statements, create index statements, and sample data insert statements in order to test ourselves....
July 20, 2011 at 12:34 pm
Without seeing your DDL, I can't be sure, but it sounds like your non-clustered index doesn't use tran1 in the first column.
I heard a lecture at a SQL Saturday that...
July 20, 2011 at 12:18 pm
Ninja's_RGR'us (7/20/2011)
Brandie Tarvin (7/20/2011)
July 20, 2011 at 11:32 am
AndrewSQLDBA (7/20/2011)
I forgot to mention this, but the column is a text data type, and replace is not working with Text data type.
Can you update it to VARCHAR(MAX) without breaking...
July 20, 2011 at 11:30 am
Why would a combination of REPLACE(), LIKE() and PATINDEX() not work here?
EDIT: Like in Lowell's example? It's set based, no looping. Looping bad if you don't need to do it.
July 20, 2011 at 11:24 am
Thanks, Gail. I appreciate you verifying that for me.
July 20, 2011 at 11:10 am
GilaMonster (7/20/2011)
Restore from backup. Log file missing, database not cleanly shut down.
So just restore over the exist rather than delete first?
July 20, 2011 at 11:08 am
My advice would be to use Dynamic SQL. Declare a variable, set the variable's value to the sql command above (with the date / time info concated into the string),...
July 20, 2011 at 11:07 am
On a semi-technical note, can I just say that I figured out how to do a JOIN to an UNPIVOT without using a derived table in the mix?
I'm so proud...
July 20, 2011 at 10:46 am
Speaking of DVDs, who gets the proceeds of the Summit DVDs? Do the presenters get any cut of that at all?
July 20, 2011 at 8:19 am
Ninja's_RGR'us (7/20/2011)
Jeff Moden (7/20/2011)
David Burrows (7/20/2011)
Thanks for being one of...
July 20, 2011 at 7:57 am
My vote is in. I hope you get it, Jeff. You're the only one of the lot that I know actually has a couple of "official" SQL phrases coined.
On a...
July 20, 2011 at 5:08 am
Viewing 15 posts - 5,536 through 5,550 (of 9,715 total)