Viewing 15 posts - 18,631 through 18,645 (of 49,552 total)
visjaaah (5/6/2012)
as far as i can see, unique only applies to nullable columns.
Not at all. A unique constraint can be applied to any column, regardless whether it's nullable or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 10:51 am
Dave Brooking (5/6/2012)
I think I was talking about obfuscation rather than encryption.
I certainly wasn't suggesting obfuscating passwords, that's worthless. I'm recommending the use of cryptographic hashes. http://en.wikipedia.org/wiki/Cryptographic_hash_function
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 10:45 am
Dave Brooking (5/6/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 10:06 am
See my first reply...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 9:30 am
Sapen (5/6/2012)
What was happening was some of the backup files were being moved to an external hard drive around the same time and this has caused high IO.
File copies require...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 9:16 am
You absolutely MUST run CheckDB on all databases on a regular basis. If you don't, how will you know if the database gets corrupt?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 9:13 am
vahid.arr (4/24/2012)
i have userid pk and i want also make username and password field uniqe.how can i do that?
Requiring passwords be unique is a mistake. It means that a person...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 9:13 am
S_Kumar_S (4/24/2012)
It's advisable to have passwords encrypted rather than storing them as it is...
Passwords shouldn't be encrypted, because there is no need to ever decrypt them. They should be stored...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 9:10 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1295646-1550-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 6, 2012 at 3:46 am
vinu512 (5/5/2012)
What you are implying when you say C, C++ code that is a CLR Function
Well, not quite. C++ is used for extended procedures (for anyone that brave). CLR procedures/functions/etc...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2012 at 5:15 am
User defined functions are written in T-SQL, definitely not in C or C++.
In Books Online (or the MSDN documentation), look up CREATE FUNCTION.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 5, 2012 at 3:24 am
dkschill (5/4/2012)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2012 at 3:38 pm
Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/
Probably what happened is that the SSIS package filled the log, failed and rolled back, then something partially cleared the log (or grew it), so by...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2012 at 5:48 am
Don't use syscolumns, it's been deprecated for 7 or so years now, it's only in the product for backward compat with SQL 2000 and there are much better schema views.
Use...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2012 at 4:06 am
sumit.tembhare (5/4/2012)
:w00t:Use Sp_Who2 and kill that processes which is using MSDB database.
SQL processes using the MSDB database would not give the error "The process cannot access the file because...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
May 4, 2012 at 3:55 am
Viewing 15 posts - 18,631 through 18,645 (of 49,552 total)