4 years old thread

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...

index renuild / reorganize job or maintenance done with option (SORT_IN_TEMPDB = ON)

OR

ONLINE = ON

?

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...

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...

Thanks Jeff for keeping close eye on all the replies , it actually helps...

Jeff Moden (10/8/2013)

---

That's a HUGE problem with most employers and recruiters. They ask people to rate themselves. How can an honest person who rates themselves as a good...

Please share...

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 =...

select * from TABLE where countryid = @country

select * from TABLE where countryid = @country OR stateID = @stateid

select * from TABLE where countryid...

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...

while you insert value ( '16923951 0' ) into it.

it will throw error like "String , binary data would be...

When we restore a backup to new...

BUt why the same column should get added with EVERY SP call ?

There is some alert/job running on destination server (or may be at source database) which is throwing this alert.