Viewing 15 posts - 14,611 through 14,625 (of 39,900 total)
Since inception, here are the posts
Year Mo Posts
20121249
201112806
201111906
201110862
20119974
20118909
20117837
20116894
20115763
20114812
20113888
20112740
20111798
201012824
201011972
2010101457
201091613
201081057
20107833
20106492
20105582
201041325
201031575
201021139
20101568
200912810
200911625
200910674
20099508
20098690
20097772
200961167
200951284
20094740
200931018
20092993
20091603
200812364
200811161
January 6, 2012 at 8:48 am
GilaMonster (1/6/2012)
I hate underscores. I hate all caps naming. I have a special hatred for what I have in a system at the moment:INSURANCECAMPAIGNREVIEW_STARTDATE
Don't hate, but I find it hard...
January 6, 2012 at 8:41 am
rothj (1/6/2012)
I got it right but I would have gotten it wrong had there been an option that it gets created automatically on sql install.
I should have had that as...
January 6, 2012 at 8:40 am
Jeff Moden (1/5/2012)
Steve... any chance of getting a "thread count" for 2011?
Posts by year? Sure, I'll query it.
January 6, 2012 at 8:38 am
yes, the wizard can do this
January 5, 2012 at 1:49 pm
Tara-1044200 (1/5/2012)
here is how i laied out.tempdev1D:\DATA\tempdb.mdfPRIMARY1073741824 KB1073741824 KB10%data only
templog2D:\LOG\templog.ldfNULL512 KBUnlimited10%log only
tempdb23F:\DATA\tempdb2.ndfPRIMARY3072 KBUnlimited1024 KBdata only
tempdb34E:\DATA\tempdb3.ndfPRIMARY3072 KBUnlimited1024 KBdata only
and the D drive also has 450gb od space for OS paging
Which one...
January 5, 2012 at 12:59 pm
Push seems to be the default. The optional settings under #6 show a pull sub.
sp_addsubscription has a default of push: http://msdn.microsoft.com/en-us/library/ms181702.aspx
January 5, 2012 at 12:52 pm
Stefan Krzywicki (1/5/2012)
jcrawf02 (1/5/2012)
January 5, 2012 at 12:51 pm
jcrawf02 (1/5/2012)
January 5, 2012 at 11:25 am
Jack Corbett (1/5/2012)
jcrawf02 (1/5/2012)
Still, never worth going without health insurance. Go big there.I processed claims for one day before I decided never to go without again.
I have it...
January 5, 2012 at 11:19 am
I would make sure you socialize this to clients and your help desk/support. If there is something using "sa" it will break after the update if you change the sa...
January 5, 2012 at 10:42 am
TOP 10 can grab one page (or a few) and return 10 rows. Any 10.
The order by means you must load the entire table to ensure you have the top...
January 5, 2012 at 10:39 am
A few free books we offer:
January 5, 2012 at 10:37 am
dick.baker (1/5/2012)
small beer, but
Tx, corrected the typo.
January 5, 2012 at 10:33 am
Viewing 15 posts - 14,611 through 14,625 (of 39,900 total)