Viewing 15 posts - 3,301 through 3,315 (of 5,841 total)
Indianrock (6/21/2011)
June 22, 2011 at 9:35 am
Anyone else find it ironic that a company is moving from a FREE SQL Server product to an Oracle product? :w00t:
June 22, 2011 at 9:30 am
get a copy of the awesome free tool SQLJOBVIS. Shows agent history as a gantt chart. Great for finding overlaps!
June 22, 2011 at 9:27 am
I agree with Gail. If you really want us to help you understand what you observed you need to give us details about before and after versions of the...
June 21, 2011 at 5:48 am
Forced parameterization is a sledge hammer and you best test it THOROUGHLY on all parts of the application.
By far the best way to go, that should also be relatively easy...
June 21, 2011 at 5:44 am
You should absolutely positively NOT use the CTE for this scenario unless you are guaranteed to have VERY few rows split out AND you do not have any signficant data...
June 21, 2011 at 5:40 am
vmssanthosh (6/16/2011)
hiWho is lady gaga?
This is an American cultural reference to a sometimes strange pop singer. Search the web for any number of VERY interesting pictures of outfits she...
June 17, 2011 at 6:54 am
Sachin4all (6/13/2011)
insert into #t (...)
SELECT ..
FROM #hs t
INNER JOIN table1 on
If @@ERROR <> 0
Begin
Rollback Transaction Tran7
INSERT INTO LogTable Values (7,@@ROWCOUNT,'F',@Startdate,getdate())
End
Else
Begin
Commit transaction Tran7
INSERT...
June 17, 2011 at 6:48 am
Dan.Humphries (6/16/2011)
June 17, 2011 at 6:45 am
GilaMonster (6/16/2011)
I haven't, I'm busy with deadlock graphs and a performance intervention for a paying client. Maybe someone else has some time (deadlock problems aren't quick)
Nope, they sure aren't. ...
June 17, 2011 at 6:37 am
NOTE: I just came across columnar auditing at a client a few weeks ago. I found through testing that these triggers slowed down the DML by TWO ORDERS OF...
June 16, 2011 at 7:29 am
G-d it pains me to say this but I actually agree with Joe Celko. This is an absolutely, ridiculously bad idea!!!
With code generation tools you can have...
June 16, 2011 at 7:27 am
1) please tell the vendor that TheSQLGuru said they have their heads up their collective @sses. Also tell them that they need to get me or some other qualified...
June 16, 2011 at 7:17 am
Everyone PLEASE understand that database mirroring is an ADVANCED topic and you REALLY need to study up and practice with it in a test environment before pursuing it. Even...
June 16, 2011 at 7:09 am
Can you please share with us what those "more useful options" might be please?
June 16, 2011 at 7:06 am
Viewing 15 posts - 3,301 through 3,315 (of 5,841 total)