Viewing 15 posts - 5,461 through 5,475 (of 8,416 total)
GilaMonster (3/12/2010)
Gianluca Sartori (3/12/2010)
That would be funny! I was officially nominated DBA two weeks ago, it's a bit early to enter a competition and pretend that I'm "exceptional"! 😛
Considering some...
March 12, 2010 at 9:19 am
Eralper (3/12/2010)
I'm sorry you thought that to be spam. I posted my experience with that tool only. That is not a spam.
It looked like spam to me - and...
March 12, 2010 at 9:17 am
Update your CV?
:laugh:
March 12, 2010 at 9:12 am
Where's Bob?! :w00t:
March 12, 2010 at 9:12 am
jcrawf02 (3/12/2010)
...but, how do you know when to send them gift baskets? 😛
They all get NULLs on their birthdays 😛
March 12, 2010 at 9:11 am
Good man. It's pretty much the definitive work. Don't worry if you don't get all the detail first time around, it's as much a reference as it is...
March 12, 2010 at 9:10 am
No worries - it's a problem I have faced before, though I must say my natural inclination would be to use a queue table and a job to process stuff...
March 12, 2010 at 9:09 am
Grant Fritchey (3/12/2010)
And when you make the query into a procedure as Paul says, make the parameters NOT NULL and the users will have to supply them.
Good point Grant -...
March 12, 2010 at 9:06 am
eseosaoregie (3/11/2010)
Mon Jan 05 13:54:54 2009
I need to format it...
March 12, 2010 at 6:09 am
Bhuvnesh,
This is my favourite official paper on statistics:
Statistics Used By the Query Optimizer
Paul
March 12, 2010 at 6:01 am
Eralper (3/12/2010)
...SPAM...Eralper
Please do not post advertisements.
March 12, 2010 at 5:55 am
Abhijit More (3/12/2010)
We are not using stored procedures. Dn't ask me y:w00t:
To make your life harder? To bloat the procedure cache?
March 12, 2010 at 5:28 am
Abhijit More (3/12/2010)
[font="Courier New"]In above example expected output is KeyID 2, 5 as it has the same set of RefID
Why 2 & 5? Are you missing a table or...
March 12, 2010 at 5:26 am
Convert it to a stored procedure and pass the required parameters through it.
March 12, 2010 at 4:50 am
1. Instead of / After TRIGGER.
2. Ensure all modifications go through a stored procedure, and enforce it there.
March 12, 2010 at 4:47 am
Viewing 15 posts - 5,461 through 5,475 (of 8,416 total)