Viewing 15 posts - 46 through 60 (of 859 total)
ssms-man (12/4/2012)
SSMSBoost v2.7 was released yesterday. We have added "Find in Grid" functionality. Statement logging and Auto-sessions are still on the way. We need some more time to...
December 5, 2012 at 11:25 am
Out of curiosity can you post which solution you used once you get one in place?
December 5, 2012 at 8:08 am
Jeff Moden (12/4/2012)
capnhector (12/3/2012)
December 4, 2012 at 5:25 pm
sapen (12/4/2012)
capnhector (12/3/2012)
December 4, 2012 at 4:13 pm
Vedran Kesegic (12/4/2012)
These are really...
December 4, 2012 at 3:29 pm
to expand on what george posted you can create a procedure and schedule an agent job to run it. the procedure would also email the results (if any) using...
December 4, 2012 at 3:03 pm
uncle_boris (12/4/2012)
When passing in a NVarchar to...
December 4, 2012 at 11:11 am
memymasta (12/4/2012)
@celko - Very useful insight, i like it. One thing i don't understand is:
That is 'yyyy-mm-00' for a month within...
December 4, 2012 at 10:50 am
Vedran Kesegic (12/4/2012)
Try with CHECKPOINT command every several batches, because log cannot be truncated if checkpoint did not occur (also happens...
December 4, 2012 at 10:19 am
Vedran Kesegic (12/4/2012)
#tempSample is never cleared. So you throw out the same rows over and over in cross apply. Is that intentional?You also don't need uix_tmpSampleIndex index.
#tmpSample is truncated right...
December 4, 2012 at 6:29 am
I should have mentioned that the database is in simple recovery mode so the t log growth is simply from the amount of data in a single transition
December 4, 2012 at 5:11 am
GSquared (12/3/2012)
Main reason I use SkyDrive is because I've been using it (and hotmail) since before...
December 3, 2012 at 6:41 pm
for testing disk setups brent ozar has a good blog post on using sqlio. sqlio only tests writing a file to the disk and not generating queries though. ...
December 3, 2012 at 2:41 pm
Lynn Pettis (12/1/2012)
CELKO (12/1/2012)
to add comma as the thousand separator
NO! Display formatting is done in the presentation layers of any tiered architecture. The proprietary MONEY data type...
December 3, 2012 at 2:29 pm
Thanks for the information. i use drop box and they do have a nice web interface just like sky drive. The application lets me keep multiple computers in...
December 3, 2012 at 12:25 pm
Viewing 15 posts - 46 through 60 (of 859 total)