Viewing 15 posts - 16 through 30 (of 57 total)
after reading the kimberly blog i'd like to add a pro for backups:
if your in full recovery mode you can make a backup of huge files a day before a...
April 13, 2010 at 7:57 am
river1 (3/3/2010)
It looks for database errors before write the backup to a file?
it looks for a certain type of error and not all potential database errors:
it perform calculations on the...
April 13, 2010 at 7:47 am
Matthew Clifford (9/30/2009)
March 15, 2010 at 7:49 am
Sorry, i'm having difficulty comprehending 21000 columns which are referring to other tables. I have no idea without on site info what do with that. I would try not to...
March 8, 2010 at 2:20 am
arslan_ch (3/4/2010)
weither we...
March 4, 2010 at 7:52 am
can you make another sql account and give that one sysadmin ? and check if the logon works on that one ?
March 4, 2010 at 3:30 am
in your situation i would also wonder if access is worth spending effort on if there is no money available.
perhaps an open door but if using access saves you...
March 3, 2010 at 8:25 am
you cannot make the conclusion "there is no encryption active" from the fact that you can connect with ssms to a sql server with "force encryption yes". as your client...
February 9, 2010 at 3:01 am
an article with more info:
Cluster That Index! Part Two
http://qa.sqlservercentral.com/articles/Indexing/clusterthatindexparttwo/1094/
February 9, 2010 at 1:40 am
river1 (2/8/2010)
A direct question is: will data not be seen if i use profiler? or a sniffer? after encrypting?
a sniffer will have a problem. a profiler wont. the encryption is...
February 8, 2010 at 6:50 am
based on your info lowell's tip is a good idea.
there are many ways to rome and this is one of 'm.
February 8, 2010 at 6:34 am
ssl is added as an layer and is independent of sql server or https. it's just used as a component. just like if you add ssl to ftp you get...
February 8, 2010 at 5:52 am
addition to the info:
- with a clustered index: correct for the data level of the pages.
however the intermediate lvl is controlled by pad index. if it's off it will be...
February 8, 2010 at 5:16 am
SeanBarberPro (2/5/2010)
If you cannot update resources and have 3 versions of a DB on one machine.
- what do you mean with update ? or was it upgrade ? do...
February 8, 2010 at 3:31 am
TheSQLGuru (2/1/2010)
David.Poole (2/1/2010)
Add memory to the physical box and set up virtual servers rather than separate instances.
Can you please explain how virtual servers will be more effective than separate instances...
February 3, 2010 at 7:04 am
Viewing 15 posts - 16 through 30 (of 57 total)