410 reputation
211
bio website ascendum.com
location Bangalore, India
age 50
visits member for 1 year, 8 months
seen Dec 27 '13 at 4:04
Been a DBA all my life. Love what I do. Eager to learn more.

May
6
comment How can I set myself as owner of a database ? just using sql
OK. Both answers posted below should work, since they have mentioned nothing about permissions, thought I would alert you. BTW, I did not down vote.
May
6
comment How can I set myself as owner of a database ? just using sql
If it is your client's database, I doubt if you will have the permissions to set yourself as the DBO. This action requires TAKE OWNERSHIP permission on the entity.
Feb
26
awarded  Popular Question
Nov
17
awarded  Yearling
Sep
2
answered How to find unused indexes?
May
22
awarded  Editor
May
22
revised Migration of create statement from SQL Server to MySQL
improved formatting
May
22
suggested suggested edit on Migration of create statement from SQL Server to MySQL
May
22
answered How to attach an .mdf file that was not properly detached?
May
21
awarded  Caucus
May
21
awarded  Constituent
May
20
answered Database running out of space
May
17
comment convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112)
SQL 2008 has new data types DATE and TIME. DATE stores only date and TIME stores only time :)
May
17
awarded  Commentator
May
17
comment convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112)
In your specific case, it really does not matter, but it is always a good practice to use varchar(n) Vs just varchar. Out of curiosity, why are you storing a date as varchar? Why not use the DATE datatype, which will make using date functions a lot easier? Not to mention that it will use only 3 bytes of space as compared to the 10 bytes a varchar(8) uses.
May
17
comment convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112)
What is the datatype and length of the column in the create table statement? Is it varchar(8)? varchar(50)?
May
17
answered convert(varchar, getdate(), 112) or convert(varchar(8), getdate(), 112)
May
16
comment How to restore SQL Server 2008 R2 backup to SQL Server 2008
Did you click on the "More reading" link in my answer?
May
16
comment How to restore SQL Server 2008 R2 backup to SQL Server 2008
@ITBeginner - does it work for you even when you try to restore to an earlier version?
May
16
answered How to restore SQL Server 2008 R2 backup to SQL Server 2008