Viewing 15 posts - 676 through 690 (of 961 total)
DRI rocks 🙂 , I am too paranoid to blindly trust that every developer accessing databases will always keep in mind basic DB principals esp cause if anything goes wrong...
July 17, 2011 at 1:33 pm
Encryption of data is purely the organizations purview, if a company feels the data residing on laptops and tapes need to be encrypted then they should implement it without having...
July 17, 2011 at 1:04 pm
whats the error you receive when trying to connect ?
Try logging on directly on the server . check sql browser service and TCP/IP and named pipes under network configuration...
July 16, 2011 at 5:57 am
Subrata Bauri (7/15/2011)
GilaMonster (7/15/2011)
July 16, 2011 at 5:27 am
Subrata Bauri (7/15/2011)
Jayanth_Kurup (7/15/2011)
July 16, 2011 at 5:23 am
GilaMonster (7/15/2011)
Jayanth_Kurup (7/15/2011)
However the first can be achieved simply by adding a identity column while the second is driven by the kind of data being inserted into the table.
Identities alone...
July 16, 2011 at 5:19 am
Correct. I proposed identity column as primary key only to uniquely identify each row in the table.
So the identity column itself will never have duplicates.
July 15, 2011 at 5:48 am
Run checkpoint and then try doing a shrink file
July 15, 2011 at 5:38 am
Enforcing primary key on a table is purely a design decision , while sql doesn't force it; it allows suitable substitutes in columns such as identity columns , timestamps etc...
July 15, 2011 at 5:25 am
Exam 70-450: PRO: Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008
Exam 70-432: TS: Microsoft SQL Server 2008, Installation and Maintenance
the above two exams need...
July 14, 2011 at 4:28 am
This should help
http://sqlserverperformance.idera.com/uncategorized/consider-collations-carefully/
However I have yet to come across any issues due to the difference
July 14, 2011 at 4:20 am
or do like my office does , we have very uncomfortable seats , so its not possible to sit in front of a monitor long enough to do any damage...
July 14, 2011 at 3:53 am
TRUNCATE ONLy is no longer supported in sql 2008 btw
July 14, 2011 at 3:45 am
Set ONLINE = ON in the above script , the rebuild index is acquiring locka dn making the table unavailable hence the error
July 14, 2011 at 3:37 am
you need to create a master key for TDE to work
The below article gives a understanding of how TDE works
July 14, 2011 at 3:35 am
Viewing 15 posts - 676 through 690 (of 961 total)