Viewing 15 posts - 241 through 255 (of 728 total)
L' Eomot Inversé (9/18/2013)
sqlnaive (9/18/2013)
Koen Verbeeck (9/13/2013)
Very nice question to close off the week.And kudos for mentioning the default language, so there's less whining in the discussion 😀
+1 for the...
September 18, 2013 at 9:14 am
Koen Verbeeck (9/13/2013)
Very nice question to close off the week.And kudos for mentioning the default language, so there's less whining in the discussion 😀
+1 for the author. Even ensured that...
September 18, 2013 at 4:13 am
Koen Verbeeck (9/15/2013)
There's no reference, and the explanation itself is incorrect.
There's no variable that is "reset".
The DECLARE is not ignored, it...
September 16, 2013 at 12:55 am
Not worked on SQL 2012 yet. So this question made me dig for the informaiton and I'm glad to get it correct and earn some knowledge as well. 🙂
September 11, 2013 at 1:35 am
Steve Jones - SSC Editor (9/6/2013)
batgirl (9/6/2013)
In my opinion, either process can be used to move or copy a database and neither has anything to do with whether the primary...
September 6, 2013 at 8:55 am
GilaMonster (9/6/2013)
If I'm moving databases from one instance to another, I'll use backup/restore. It definitely is a way to move databases.
That is obviously one's choice. In my opinion, moving a...
September 6, 2013 at 5:05 am
GilaMonster (9/5/2013)
Attach is not the only way to move a database physically and restore doesn't modify databases (doesn't create them technically, the database was created previously if a backup exists)
Yes...
September 6, 2013 at 4:07 am
Try this:
set @val=(select cast(@a as float)*100 / cast(@b as float) as [cpu])
Sundar, It's giving result correctly to me.
September 6, 2013 at 3:07 am
GilaMonster (9/5/2013)
sqlnaive (9/5/2013)
"Attach is used to move a database physically and restore is used to create/modify database as per requirement based on backups"If you like. It's not true though.
Which part...
September 5, 2013 at 8:51 am
So we can say
"Attach is used to move a database physically and restore is used to create/modify database as per requirement based on backups"
September 5, 2013 at 7:15 am
Though it's little out of context as against the topic but over the time I've observed few things about the technical interviews:
a. I knew almost 80% of the technical questions...
September 5, 2013 at 7:04 am
Viewing 15 posts - 241 through 255 (of 728 total)