Viewing 15 posts - 526 through 540 (of 2,008 total)
GilaMonster (12/29/2011)
Dev (12/29/2011)
Place rand() * 100 function in your WHERE clause.Example:
WHERE some_int_column= rand() * 100 -- or cast it as INT
That's not more or less random than ordering...
December 29, 2011 at 10:28 am
xRafo (12/29/2011)
Hi,thanks!
but the outcome of the query needs to be a character..
You can SELECT a character column of your choice in query. I asked it to place it in...
December 29, 2011 at 10:06 am
SQLRNNR (12/29/2011)
GilaMonster (12/29/2011)
Grant Fritchey (12/29/2011)
GilaMonster (12/29/2011)
Grant Fritchey (12/27/2011)
December 29, 2011 at 10:05 am
david.kratz (12/29/2011)
Instead of saying date <= last-second-of-previous-month
I say
date < trunc(sysdate,'MM').
Of course this is out of the question if using Between.
In that case the afore-mentioned...
December 29, 2011 at 10:00 am
xRafo (12/29/2011)
Hi,I just need 1 row,
but with that query i executed 2 times and give me 2 same..
i need not repeat the result..
Place rand() * 100 function in your WHERE...
December 29, 2011 at 9:50 am
Dev (12/29/2011)
Stefan Krzywicki (12/29/2011)
GSquared (12/29/2011)
Dev (12/29/2011)
December 29, 2011 at 9:21 am
Stefan Krzywicki (12/29/2011)
GSquared (12/29/2011)
Dev (12/29/2011)
December 29, 2011 at 9:05 am
I thought some "Magic" (recovery trick) will happen & that DB will be saved. It’s a nice learning opportunity that I missed. However the lessons learnt today (reminder actually), keep...
December 29, 2011 at 8:52 am
ALZDBA (12/29/2011)
toddasd (12/28/2011)
Dev (12/28/2011)
...Why copy pasta msdn and link to it?
To make the suggestion brief and provide the a ref in case someone wants more info. #GoodJob...
December 29, 2011 at 8:33 am
Per BOL:
When a query is first compiled, if the optimizer needs a particular statistics object, and that statistics object exists, the statistics object is updated if it is out of...
December 29, 2011 at 8:13 am
ndessaint (12/29/2011)
Hello,Thanks for your answer. I had not thought this.
The solution is :
EXEC msdb.dbo.sp_purge_jobhistory @oldest_date=GETDATE()-14
EXEC msdb.dbo.sp_set_sqlagent_properties @jobhistory_max_rows=-1,
@jobhistory_max_rows_per_job=-1
Thanks
Nicolas
As I have already said, I was not sure. It’s your...
December 29, 2011 at 7:55 am
PaulB-TheOneAndOnly (12/29/2011)
Dev (12/29/2011)It looks like ...
...but you don't know, huh? why don't just answer what op asked for instead of going border line off topic for no...
December 29, 2011 at 7:45 am
PaulB-TheOneAndOnly (12/29/2011)
Dev (12/29/2011)
Adding another thought. Is there any reason for doing it in database side? It should be done on Front End (application).
Why? What's wrong with backend...
December 29, 2011 at 7:20 am
Adding another thought. Is there any reason for doing it in database side? It should be done on Front End (application).
December 29, 2011 at 7:13 am
GSquared (12/28/2011)
...Here's some data on nested sets: http://en.wikipedia.org/wiki/Nested_set_model
Nested Set Model is introduced By Joe Celko??? :w00t: It’s news to me.
Sorry for being blunt, I don’t like him for his insulting...
December 29, 2011 at 7:08 am
Viewing 15 posts - 526 through 540 (of 2,008 total)