Viewing 5 posts - 1 through 5 (of 5 total)
Regarding scripts:
"Since scripts may contain clear text passwords required to connect to the database, these should be encrypted."
Do you mean encrypt the filesystem where the script resides on? IMO not...
March 7, 2013 at 5:04 am
Ok, so in other words you're saying a clustered index means that the physical data is stored in index order, so e.g. binary searches are possible.
A nonclustered index is closer...
December 24, 2012 at 2:54 am
Agreed with the previous posters.
It's not so hard to go through MSDN looking for how to use things, the reason why one should use things is much more important.
Real world...
June 4, 2012 at 3:34 am
Probably being a bit ignorant here but once you're writing T-SQL you're already specializing for MS SQL Server and Sybase ASE.
So not using vendor-specific stuff (e.g. clustered indexes) after that...
May 31, 2012 at 7:16 am
Aren't you missing a
USE [ErrorLogStorage]
GO
in the database creation script? When I ran it, it created the ErrLogData table in master...
Apart from that, a smart solution: why struggle with text...
February 14, 2011 at 2:59 am
Viewing 5 posts - 1 through 5 (of 5 total)