Viewing 15 posts - 151 through 165 (of 2,462 total)
4 years old thread
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 8:12 am
Any plan to release the mobile APP for this ?
I constantly use this site on my mobile but its very heavy and often end with no...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 6:44 am
index renuild / reorganize job or maintenance done with option (SORT_IN_TEMPDB = ON)
OR
ONLINE = ON
?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 6:30 am
SPs/Queries also behave bad when Spooling or work table comes in picture for heavy data temporary storage during intermediate stages. so to avoid this you can use temp table...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 6:25 am
The question asked to OP by interviewer was probably like
"flip the values from A to B and B to A "
was actually answered by...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 5:00 am
Jeff Moden (10/8/2013)
Gosh, I wouldn't rely on that nuance especially for the sake of clarity.
Thanks Jeff for keeping close eye on all the replies , it actually helps...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 9, 2013 at 2:09 am
Jeff Moden (10/8/2013)
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 8:36 am
Jeff Moden (10/8/2013)
I have been known to stop an interview after just one super simple question and trust me on this... the question is just absolutely stupid simple.
Please share...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 8:30 am
ChrisM@Work (10/8/2013)
SELECT * FROM TABLE WHERE countryid = @country
SELECT * FROM TABLE WHERE countryid = @country AND stateID = @stateid
SELECT * FROM TABLE WHERE countryid = @country AND stateID =...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 8:19 am
select * from TABLE where countryid = @country
select * from TABLE where countryid = @country OR stateID = @stateid
select * from TABLE where countryid...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 4:19 am
READ AND TEST it CAREFULLY :exclamation:
IF EXISTS (SELECT [name] FROM dbo.sysobjects WHERE [name] = 'usp_Admin_Delete_Files_By_Date' AND TYPE = 'P')
DROP PROCEDURE dbo.usp_Admin_Delete_Files_By_Date
GO
CREATE PROCEDURE dbo.usp_Admin_Delete_Files_By_Date (@SourceDir varchar(1024), @SourceFile varchar(512), @DaysToKeep int)
-- EXEC...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 4:11 am
jasona.work (10/7/2013)
Somehow a value of '16923951 0' got entered...
while you insert value ( '16923951 0' ) into it.
it will throw error like "String , binary data would be...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 4:06 am
PearlJammer1 (10/7/2013)
I wish to use a method that transfers the users password and BUT ALSO keeps their current database mappings and permissions.
When we restore a backup to new...
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 2:12 am
karunakar2351 (10/7/2013)
ALTER TABLE t ADD x char(1)
BUt why the same column should get added with EVERY SP call ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 8, 2013 at 2:08 am
There is some alert/job running on destination server (or may be at source database) which is throwing this alert.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 7, 2013 at 8:19 am
Viewing 15 posts - 151 through 165 (of 2,462 total)