869 reputation
411
bio website yrushka.com
location Bucharest, Romania
age 31
visits member for 3 years, 3 months
seen Nov 5 '13 at 9:13

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
Feb
21
awarded  Popular Question
Jan
26
awarded  Yearling
Aug
8
awarded  Popular Question
Apr
6
awarded  Notable Question
Jan
26
awarded  Yearling
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)?
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