Viewing 15 posts - 46 through 60 (of 18,925 total)
Ehh, why not sum(case) ???
January 20, 2012 at 10:27 am
GilaMonster (1/20/2012)
Ninja's_RGR'us (1/20/2012)
I live far enough. Not worth to waste 4 days on this, but you on the other hand live much closer to her ;-).
Much closer? Maybe for...
January 20, 2012 at 6:29 am
Grant Fritchey (1/20/2012)
Ninja's_RGR'us (1/20/2012)
Grant Fritchey (1/20/2012)
Ninja's_RGR'us (1/20/2012)
Isn't it better to use 1222 rather than 1204??
Oh god. I can't believe I typed that. Yes, 1222 is better. I edited the post....
January 20, 2012 at 6:16 am
Grant Fritchey (1/20/2012)
Ninja's_RGR'us (1/20/2012)
Isn't it better to use 1222 rather than 1204??Oh god. I can't believe I typed that. Yes, 1222 is better. I edited the post. Yikes.
I was about...
January 20, 2012 at 6:07 am
I also run checkdb before taking the next full backup.
One more way to save your arse is to NOT delete the backups completely. I have a copy...
January 18, 2012 at 2:21 pm
Sounds about right, couldn't think of anything other possible outcome since the overwrite has to start right near the begining.
That's the exact reason why I datetimestamp my files and delete...
January 17, 2012 at 5:57 pm
SSRS is annoying with that.
Use this code to do the division (rename as you wish, this is not Ms Access after all! ;-)).
PUBLIC FUNCTION NDZ(Numerator, Denominator, DZResult)
IF Denominator = 0...
January 17, 2012 at 10:04 am
My guess if that you're done for it. Let me know once you've tested.
January 17, 2012 at 8:58 am
Yes it's flawed. NEVER delete a backup unless you ar 200% certain you have a way to recover according to your RTO & RPO.
I have the luxury to be...
January 17, 2012 at 7:22 am
SQLKnowItAll (1/16/2012)
is my solution correct ("db_denydatareader" to MASTER)
No, it is not correct.
Care to actually explain your answer?!?!
January 16, 2012 at 10:44 am
sjsubscribe (1/16/2012)
why does the date at the bottom of these articles show a future date? For example, 2012/3/26 for this article. Or is that not a date.
Because it'll be published...
January 16, 2012 at 10:18 am
Nothing wrong with nvarchar(max). You just have to learn when and where it's appropriate to use. 😉
January 14, 2012 at 7:08 am
I would use nvarchar(max) in this case for the simple reason that a single region might have a massive list of ids and that the ids will be longer than...
January 14, 2012 at 5:25 am
Rambler (1/13/2012)
January 13, 2012 at 6:50 pm
Viewing 15 posts - 46 through 60 (of 18,925 total)