Viewing 15 posts - 5,926 through 5,940 (of 19,560 total)
Gianluca Sartori (7/19/2012)
Out of curiosity, does...
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 19, 2012 at 3:16 pm
anthony.green (7/19/2012)
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 19, 2012 at 11:46 am
Have you checked the server logs?
Have you verified that somebody/something is not stopping and restarting SQL Server?
Same sort of question for the Agent, have you confirmed that somebody/something is not...
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 18, 2012 at 11:38 pm
How does the hardware (memory, cpu, 64bit v 32bit, hard disk speed and type), compare between the two?
Have you examined the execution plan from both machines and checked for differences?
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 18, 2012 at 11:36 pm
Solomon Rutzky (7/17/2012)
Steve Jones (7/17/2012)
CONVERT still has crazy numeric codes for conversion. Wouldn’t it make more sense to do this:
DECLARE @dt datetime
SELECT @dt = GETDATE()
SELECT CONVERT( datetime, @dt, 'dd.mm.yy')
Hey Steve....
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 18, 2012 at 11:33 pm
Jan Van der Eecken (7/18/2012)
SQLRNNR (7/18/2012)
Jan Van der Eecken (7/18/2012)
Steve Jones - SSC Editor (7/18/2012)
GilaMonster (7/18/2012)
The first one as well as the second please? It has some deep stuff in,...
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 18, 2012 at 5:09 pm
Jan Van der Eecken (7/18/2012)
Steve Jones - SSC Editor (7/18/2012)
GilaMonster (7/18/2012)
The first one as well as the second please? It has some deep stuff in, I promise,
Already added that one...
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 18, 2012 at 5:00 pm
Here is an article with details for that.
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 18, 2012 at 1:37 pm
GilaMonster (7/18/2012)
Steve Jones - SSC Editor (7/18/2012)
WayneS (7/18/2012)
Gianluca Sartori (7/18/2012)
SQLRNNR (7/17/2012)
http://www.apress.com/9781430247708
Here's another one coming out in August (by...
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 18, 2012 at 1:11 pm
chronometer
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 18, 2012 at 12:37 pm
Lynn Pettis (7/18/2012)
SQLRNNR (7/18/2012)
lokeshvij (7/18/2012)
CTE being ANSI compliant, why does it let us delete data from CTE? I am...
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 18, 2012 at 12:22 pm
Lynn Pettis (7/18/2012)
Danzz (7/18/2012)
Can I get T-sql statement.
Based on what? We don't have anything useful from you to provide you with any code that would be useful to you....
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 18, 2012 at 12:15 pm
Sean Lange (7/18/2012)
Danzz (7/18/2012)
Can I get T-sql statement.Actually if you read the article it is really quite simple.
Thank you.:-D
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 18, 2012 at 12:14 pm
lokeshvij (7/18/2012)
CTE being ANSI compliant, why does it let us delete data from CTE? I am sure ANSI norms...
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 18, 2012 at 12:14 pm
I am sooooo far behind in books to read this year. I have a pile of books on my nightstand and another pile in my kindle that I planned...
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 18, 2012 at 11:59 am
Viewing 15 posts - 5,926 through 5,940 (of 19,560 total)