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.

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.
Jul
28
answered How to use variables inside a select (SQL Server)?
Jul
28
awarded Autobiographer
Jun
14
answered SQL Server - RangeX-X and RangeI-N locks
May
10
revised Rebuilding the transaction log
deleted 37 characters in body
May
10
revised Rebuilding the transaction log
added 4 characters in body
May
3
answered Creating centralized DBA database
May
3
answered What is the best way to monitor long running queries in SQL Server?
Apr
28
asked SQL Server - RangeX-X and RangeI-N locks
Apr
27
comment SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed
Yes normally you should be able to see all active/nonactive through sp_who or querying the sysprocesses table from master db. By hidden i meant a process that reconnects from an application service. Cheers.
Apr
27
answered SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed
Apr
14
answered Dropping a constraint (index) on a column
Apr
14
answered SQL server suspect database?
Apr
12
revised SQL Server 2005 Huge DB issue
deleted 3295 characters in body
1 2 3 4 5