Viewing 15 posts - 5,146 through 5,160 (of 49,571 total)
Brandie Tarvin (7/30/2015)
GilaMonster (7/30/2015)
Luis Cazares (7/30/2015)
NOLOCK hints can be useful to get estimates of certain data.
Yup. In fact I told some people recently to put nolock onto a bunch of...
July 30, 2015 at 8:07 am
Brian Barkauskas (7/30/2015)
For this example, why even use LIKE?
Because LIKE with a trailing wildcard allows for index seeks if there is an appropriate index, whereas LEFT does not.
July 30, 2015 at 7:51 am
Luis Cazares (7/30/2015)
NOLOCK hints can be useful to get estimates of certain data.
Yup. In fact I told some people recently to put nolock onto a bunch of queries. They were...
July 30, 2015 at 7:28 am
I've already told you what I suggest.
Write the query in the simplest way possible. If testing shows that there are performance/locking problems, then consider alternate forms and test them.
As for...
July 30, 2015 at 6:43 am
Neither.
UPDATE [dbo].[TL_CST_Locker_Issuance] SET
[isActive] = 0
WHERE
LockerAppFormId = @LockerAppFormId and LockerNumber=@LockerNumber and isActive=1;
Writing the query in a more...
July 30, 2015 at 5:40 am
Brandie Tarvin (7/30/2015)
EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
Incompetent developers.
Prior to SQL 2005 there might have been. Since...
July 30, 2015 at 5:14 am
Runs the recovery process, same as when you restore a database, there's extra time after the data copying portion completes.
July 30, 2015 at 3:05 am
Alvin Ramard (7/29/2015)
GilaMonster (7/29/2015)
Alvin Ramard (7/29/2015)
GilaMonster (7/29/2015)
They send my student card by courier. They send request for guest count for grad via SMS and email.
They send...
July 29, 2015 at 2:40 pm
Alvin Ramard (7/29/2015)
GilaMonster (7/29/2015)
They send my student card by courier. They send request for guest count for grad via SMS and email.
They send the document telling...
July 29, 2015 at 2:03 pm
SQLRNNR (7/29/2015)
And in breaking news...The thread is about to turn 50,000.
Let the countdown begin.
Am I missing something? Page header says 49730 posts.
I know we like countdowns, but counting down 270...
July 29, 2015 at 1:56 pm
I just love university logic.
They send my student card by courier. They send request for guest count for grad via SMS and email.
They send the document telling me my final...
July 29, 2015 at 1:51 pm
abhishek_300 (7/28/2015)
Thanks Gila monster for your comments .However for interviews people do not ask simple question on SQL hence you are seeing unrealistic example.
I can ask some very non-simple questions...
July 29, 2015 at 9:21 am
Increase cost threshold
Identify the queries which are doing parallel scans and tune them.
July 29, 2015 at 4:25 am
Temp tables are local to the session which created them. SQL automatically adds numbers to the name of a temp table to ensure that it is unique, even if several...
July 29, 2015 at 3:53 am
Viewing 15 posts - 5,146 through 5,160 (of 49,571 total)