Viewing 15 posts - 12,496 through 12,510 (of 19,560 total)
Anybody else want to try this 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
September 11, 2010 at 12:36 pm
It might even be for interview preparation.
The question seems to be fairly broad though, and a more specific question would more than likely garner an answer.
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 11, 2010 at 8:54 am
GilaMonster (9/11/2010)
Stefan Krzywicki (9/10/2010)
Heh, the XBOX version is a short version.
Yeah. The PC version can easily take (me) a week for a single game
Civ V comes out in 2 weeks...
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 11, 2010 at 7:22 am
what exactly about the architecture are you looking 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
September 11, 2010 at 7:18 am
Nice article. Thanks Tim.
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 10, 2010 at 11:35 pm
The Dixie Flatline (9/10/2010)
Have a great weekend, guys and guy-ettes.
You too
and the song I was thinking was along the lines of Walk of Life by Dire Straits
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 10, 2010 at 11:32 pm
Source Safe
Team Foundation server
or SVN are all viable options for source control of stored procedures. SVN does have a plugin to retrieve all of your objects from SQL server...
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 10, 2010 at 11:31 pm
Alvin Ramard (9/10/2010)
Alvin Ramard (9/10/2010)
Jeff Moden (9/10/2010)
..... Perfect for the game we all call "life". 😛
The game of life is hard to play
I'm gonna lose it anyway
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
September 10, 2010 at 9:28 pm
Looks like a viable option - for a one off situation.
Good luck.
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 10, 2010 at 9:21 pm
Alvin Ramard (9/10/2010)
Jeff Moden (9/10/2010)
..... Perfect for the game we all call "life". 😛
The game of life is hard to play
I'm gonna lose it anyway
The losing card...
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 10, 2010 at 7:51 pm
If you are still interested, I have a query I have been working on (still working on it to get it faster) that will report show you indexes with LOB...
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 10, 2010 at 7:51 pm
And the circle goes on.
Unless you are really hurting for disk space, I would not shrink them.
If you are really hurting - you can try to shrink them to about...
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 10, 2010 at 7:47 pm
If the older partitions are not changing, then why rebuild those indexes?
If the data is changing and the pages are getting split, then an index will become fragmented and 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 10, 2010 at 7:33 pm
I recommend not shrinking it like that. Shrinking after you reindex is causing your indexes to fragment again.
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 10, 2010 at 7:16 pm
Thanks for the article.
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 10, 2010 at 6:51 pm
Viewing 15 posts - 12,496 through 12,510 (of 19,560 total)