Viewing 15 posts - 1,066 through 1,080 (of 19,560 total)
GilaMonster (7/30/2015)
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 30, 2015 at 8:40 am
Grant Fritchey (7/30/2015)
Brandie Tarvin (7/30/2015)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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:...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 30, 2015 at 8:33 am
Brandie Tarvin (7/30/2015)
Work...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 29, 2015 at 11:25 pm
Iwas Bornready (7/29/2015)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 29, 2015 at 3:57 pm
And in breaking news...
The thread is about to turn 50,000.
Let the countdown begin.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 29, 2015 at 1:17 pm
Viewing 15 posts - 1,066 through 1,080 (of 19,560 total)