Viewing 15 posts - 8,551 through 8,565 (of 19,560 total)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Good thing NFL players don't work for Amazon. If...
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
September 23, 2011 at 10:44 am
bopeavy (9/23/2011)
crookj (9-23-11)
RetrospectiveAbstract
pointillism
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
September 23, 2011 at 10:14 am
you're welcome
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
September 23, 2011 at 9:43 am
Sudhir Dwivedi (9/22/2011)
Jason:
It is one of those cases where it is safe to bet that the question is about the current release or within the past 2 releases.
Yes, I...
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
September 22, 2011 at 10:58 pm
Sudhir Dwivedi (9/22/2011)
But still I think you should have added the versions of SQL Servers as In SQL 7.0 it's not a True case.
Maybe so, but given that SQL 7...
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
September 22, 2011 at 10:40 pm
Yes - audit records are registered in UTC.
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
September 22, 2011 at 10:20 pm
Thanks for the question Ron.
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
September 22, 2011 at 10:02 pm
Jim Murphy (9/22/2011)
People are asking me but I don't have a...
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
September 22, 2011 at 9:30 pm
Another factor could be sectors that were getting tagged as bad until you formatted the drive. Sometimes a format will correct that issue.
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
September 22, 2011 at 9:22 pm
I think the fragmentation is a very good candidate.
Even when writing a new file, if the space is not contiguous it will be written in a fragmented state which will...
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
September 22, 2011 at 9:21 pm
select REPLICATE(1,13)
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
September 22, 2011 at 9:16 pm
SQL Kiwi (9/22/2011)
Cliff Jones (9/22/2011)
Yes, I saw 1,2,3 and almost forgot to count the null value. Good straight forward question with all the likely wrong answers.
I did forget to...
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
September 22, 2011 at 9:13 pm
WayneS (9/22/2011)
Grant Fritchey (9/22/2011)
GilaMonster (9/22/2011)
SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/
Chapter 8: "The how and why of...
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
September 22, 2011 at 9:11 pm
Rebuilding your indexes on the primary should rebuild via logshipping when you rebuild on the primary.
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
September 22, 2011 at 5:16 pm
Try without the \MSSQLSERVER.
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
September 22, 2011 at 4:59 pm
Viewing 15 posts - 8,551 through 8,565 (of 19,560 total)