Viewing 15 posts - 1,066 through 1,080 (of 19,564 total)
GilaMonster (7/30/2015)
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
July 30, 2015 at 8:40 am
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
July 30, 2015 at 8:39 am
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 queries. They...
July 30, 2015 at 8:38 am
Brandie Tarvin (7/30/2015)
ALZDBA (7/30/2015)
Brandie Tarvin (7/30/2015)
...EDIT: Seriously, can anyone give me a real reason why WITH (NOLOCK) might be functionally necessary for production code?
To keep the answer brief and firm:...
July 30, 2015 at 8:33 am
Brandie Tarvin (7/30/2015)
Work...
July 30, 2015 at 8:31 am
It would be much faster to backup the ReportServer database and the encryption key and then to restore those on the new server. The encryption key is critical to recover...
July 29, 2015 at 11:27 pm
PJ_SQL (7/29/2015)
I have this script, it is taking long time to execute, what can I do to make it execute faster?
DECLARE @c varchar(10)
SET @c = '%A1%'
select *
from...
July 29, 2015 at 11:25 pm
Iwas Bornready (7/29/2015)
July 29, 2015 at 9:15 pm
jckfla (7/29/2015)
Certainly a person coming to work at a company that refuses to engage with others in any way outside of work can be a problem. We need to get...
July 29, 2015 at 9:05 pm
Mike Hays (7/29/2015)
I did leave a key element out of the question (as discussed in the last seven pages).
Just arrive back from vacation to see my inbox flood with...
July 29, 2015 at 7:33 pm
DonlSimpson (7/29/2015)
SQLRNNR (7/29/2015)
Ray K (7/29/2015)
whereisSQL? (7/29/2015)
Major LeagueJobu
Heart
Wilson
Phillips
July 29, 2015 at 7:32 pm
GilaMonster (7/29/2015)
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...
July 29, 2015 at 4:00 pm
Steve Jones - SSC Editor (7/29/2015)
I saw it was hundreds away. I thought I'd just try to get Jason going a bit.
I posted that and stepped away for work knowing...
July 29, 2015 at 3:58 pm
GilaMonster (7/29/2015)
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...
July 29, 2015 at 3:57 pm
And in breaking news...
The thread is about to turn 50,000.
Let the countdown begin.
July 29, 2015 at 1:17 pm
Viewing 15 posts - 1,066 through 1,080 (of 19,564 total)