yrushka

Bucharest, Romania

irina2dose.wordpress.com

Age: 31

Work as SQL DBA for 5 years and search to improve my skills everyday. I am also interested in SQL programming and developing personal scripts for administration purpose.

Jul
21
awarded Citizen Patrol
Jul
18
comment Rapidly increasing TempDB write latency
Any system that causes a PLE less than 300 for me it would say there is a memory pressure. On nowadays systems, PLE can be as high as 12000 but the question came from someone that didn't give specific hardware configuration. Instead of giving no answer, I would rather give some guidance.
Jul
18
comment Preventing SQL Injection
of course it will be used, the idea was to prevent the sql injection of malicious queries inputed for @tVariable, but I got confused, because the second query as I wrote it can still be missused. In order to not be able to execute scripts like select * from sysusers; drop table SOMETABLE AN ORDER BY or GROUP BY or WHERE clauses should be added.
Jul
18
revised Preventing SQL Injection
added 15 characters in body
Jul
16
awarded Yearling
Jul
16
awarded Autobiographer
Jul
16
answered Rapidly increasing TempDB write latency
Jul
16
comment Preventing SQL Injection
thanks I updated correctly.
Jul
16
revised Preventing SQL Injection
deleted 91 characters in body
Jul
16
awarded Critic
Jul
16
answered Security implications of restoring a backup from an unknown source?
Jul
16
answered Preventing SQL Injection
Jul
2
awarded Curious
Jan
26
awarded Yearling
Nov
10
awarded Yearling
Nov
10
awarded Yearling
Jun
4
awarded Yearling
Apr
6
awarded Notable Question
Nov
10
awarded Popular Question
Jul
28
comment Why use both TRUNCATE and DROP?
As Bohemian said, the practice is strictly to improve performance of the drop operation.
1 2 3 4 5