Viewing 15 posts - 10,606 through 10,620 (of 19,560 total)
Here is one reference.
http://weblogs.sqlteam.com/dmauri/articles/6914.aspx
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
April 5, 2011 at 10:08 am
Excellent. I re-read my last post and must confess that it must be too early ;-). Index should table - obviously as your evidence shows.
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
April 5, 2011 at 10:03 am
GSquared (4/5/2011)
David Burrows (4/5/2011)
Stefan Krzywicki (4/5/2011)
...What are you doing, standing around on people's lawns?Nah, bet he plays Knock-down Ginger :w00t:
We called it "knock and run" when/where I was a growing...
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
April 5, 2011 at 9:53 am
Growing your table and eventually growing the data file(s) on the disk subsystem can lead to external fragmentation and cannot be repaired from within SQL server at all. 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
April 5, 2011 at 9:52 am
Don't get sysadmin confused with other types of admins. Just because an account is sysadmin in SQL server does not mean that account has the appropriate NTFS permissions for...
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
April 5, 2011 at 9:50 am
Steve Jones - SSC Editor (4/5/2011)
GSquared (4/5/2011)
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
April 5, 2011 at 9:23 am
Jester
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
April 5, 2011 at 9:18 am
This is part of the reason why setting service accounts or job ownership to specific users is not necessarily a best practice. When their account is disabled or expires...
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
April 5, 2011 at 9:14 am
Because when you actually specify a job owner, the job will execute as that user and not the service account.
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
April 5, 2011 at 9:13 am
Steve Jones - SSC Editor (4/5/2011)
CirquedeSQLeil (4/4/2011)
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
April 5, 2011 at 9:11 am
John Mitchell-245523 (4/5/2011)
CirquedeSQLeil (4/5/2011)
You can rebuild the NC but fragmentation will persist. A clustered index is required to defrag the NCs.
Jason, I must confess I don't understand. What's...
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
April 5, 2011 at 9:10 am
natarshia.peck (4/5/2011)
i've googled bol and it's not helpful. any books i could buy on this topic that you guys recommend?thanks
You can try the Internals books. Also lookup Kimberly Tripp...
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
April 5, 2011 at 8:12 am
John Mitchell-245523 (4/5/2011)
CirquedeSQLeil (4/5/2011)
a non-clustered index cannot be defragged without the presence of a clustered index.
Jason, are you sure about this? My understanding is that you can rebuild the...
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
April 5, 2011 at 8:08 am
natarshia.peck (4/5/2011)
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
April 5, 2011 at 7:36 am
forsqlserver (4/5/2011)
Is there any free tool but good also?:hehe:
Yes there is a codeplex project. Check the list from the links I posted.
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
April 5, 2011 at 7:25 am
Viewing 15 posts - 10,606 through 10,620 (of 19,560 total)